Database Queries

6 duplicated queries found.

Total 21 items.
TimeDurationTypeDuplicatedQuery
   
20:31:50.0710.1 msSELECT1
SELECT `store`.* FROM `store` LEFT JOIN `user` ON `store`.`user_id` = `user`.`id` WHERE `slug` IS NULL

20:31:50.0710.1 msSELECT1
SELECT * FROM `team` WHERE `slug`=''

20:31:50.0730.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)

20:31:50.0730.0 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)

20:31:50.0740.1 msSELECT1
SELECT * FROM `user` WHERE `id`=1

20:31:50.0750.1 msSELECT1
SELECT * FROM `club` WHERE `slug`=''

20:31:50.0750.1 msSELECT1
SELECT * FROM `site_pages` WHERE `type_id`=1

20:31:50.0760.1 msSELECT1
SELECT `post_id` FROM `wp_postmeta` WHERE (`meta_key`='yii-page') AND (`meta_Value`='1')

20:31:50.0760.0 msSELECT1
SELECT * FROM `wp_postmeta` WHERE (`post_id`='1') AND (`meta_key`='_wpb_shortcodes_custom_css')

20:31:50.0850.1 msSELECT4
SELECT * FROM `user` WHERE `type_id`=1

20:31:50.0870.1 msSELECT4
SELECT * FROM `user` WHERE `type_id`=1

20:31:50.0880.9 msSELECT2
SELECT * FROM `site_setting` WHERE `option_name`='site_logo'

20:31:50.0900.1 msSELECT4
SELECT * FROM `user` WHERE `type_id`=1

20:31:50.0910.1 msSELECT1
SELECT * FROM `store` WHERE `user_id`=1

20:31:50.0960.1 msSELECT4
SELECT * FROM `user` WHERE `type_id`=1

20:31:50.0960.1 msSELECT1
SELECT * FROM `footer_slider` WHERE (`user_id`=1) AND (`slider_set_for`=1) ORDER BY `footer_slider`.`created_at` DESC

20:31:50.0990.1 msSELECT1
SELECT * FROM `footer_cta` WHERE `user_id`=1

20:31:50.0990.0 msSELECT1
SELECT * FROM `footer_slider` WHERE `slider_set_for`=2 ORDER BY `footer_slider`.`created_at` DESC

20:31:50.1000.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')

20:31:50.1000.1 msSELECT1
SELECT * FROM `site_pages` WHERE `type_id` IN (32, 33, 34)

20:31:50.1010.1 msSELECT2
SELECT * FROM `site_setting` WHERE `option_name`='site_logo'