Database Queries

5 duplicated queries found.

Total 16 items.
TimeDurationTypeDuplicatedQuery
   
04:38:40.3000.1 msSELECT1
SELECT `store`.* FROM `store` LEFT JOIN `user` ON `store`.`user_id` = `user`.`id` WHERE `slug` IS NULL

04:38:40.3000.1 msSELECT1
SELECT * FROM `team` WHERE `slug`=''

04:38:40.3020.1 msSELECT1
SELECT `user_theme`.* FROM `user_theme` LEFT JOIN `league` ON `user_theme`.`user_id` = `league`.`user_id` LEFT JOIN `club` ON `user_theme`.`user_id` = `club`.`user_id` LEFT JOIN `team` ON `user_theme`.`team_id` = `team`.`id` WHERE (((league.slug = "") OR (club.slug = "")) OR (team.slug = "")) AND (`user_theme`.`is_active`=1)

04:38:40.3020.1 msSELECT1
SELECT `user_theme`.* FROM `user_theme` LEFT JOIN `user` ON `user_theme`.`user_id` = `user`.`id` WHERE (`user_theme`.`is_active`=1) AND (`user`.`type_id`=1)

04:38:40.3030.1 msSELECT1
SELECT * FROM `user` WHERE `id`=1

04:38:40.3040.1 msSELECT1
SELECT * FROM `club` WHERE `slug`=''

04:38:40.3050.1 msSELECT1
SELECT * FROM `faq` WHERE (`user_id`=1) AND (`name`=FALSE) AND (`is_active`=1) ORDER BY `ord`

04:38:40.3050.0 msSELECT1
SELECT * FROM `faq` WHERE `user_id`=1 ORDER BY `ord`

04:38:40.3140.1 msSELECT3
SELECT * FROM `user` WHERE `type_id`=1

04:38:40.3150.1 msSELECT3
SELECT * FROM `user` WHERE `type_id`=1

04:38:40.3160.1 msSELECT2
SELECT * FROM `site_setting` WHERE `option_name`='site_logo'

04:38:40.3170.1 msSELECT3
SELECT * FROM `user` WHERE `type_id`=1

04:38:40.3180.1 msSELECT1
SELECT * FROM `store` WHERE `user_id`=1

04:38:40.3210.1 msSELECT1
SELECT `site_page_type`.* FROM `site_page_type` LEFT JOIN `site_pages` ON `site_page_type`.`id` = `site_pages`.`type_id` WHERE `site_page_type`.`name` IN ('Footer Quick link', 'Footer Contact Us', 'Footer About Us')

04:38:40.3210.1 msSELECT1
SELECT * FROM `site_pages` WHERE `type_id` IN (32, 33, 34)

04:38:40.3220.1 msSELECT2
SELECT * FROM `site_setting` WHERE `option_name`='site_logo'