Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Configuration`.`id`, `Configuration`.`key`, `Configuration`.`value`, `Configuration`.`help`, `Configuration`.`description`, `Configuration`.`multiple`, `Configuration`.`serialized`, `Configuration`.`created`, `Configuration`.`modified` FROM `jsscrm_crm`.`bf_configurations` AS `Configuration` WHERE 1 = 1 LIMIT 100 | 32 | 32 | 1 | |
SELECT COUNT(*) AS `count` FROM `jsscrm_crm`.`bf_tickets` AS `Ticket` WHERE `ticket_status_id` = 2 LIMIT 100 | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `jsscrm_crm`.`bf_tickets` AS `Ticket` WHERE `ticket_type_id` = 1 AND `ticket_status_id` = 2 LIMIT 100 | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `jsscrm_crm`.`bf_tickets` AS `Ticket` WHERE `ticket_type_id` = 5 AND `ticket_status_id` = 2 LIMIT 100 | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `jsscrm_crm`.`bf_tickets` AS `Ticket` WHERE `ticket_type_id` = 4 AND `ticket_status_id` = 2 LIMIT 100 | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `jsscrm_crm`.`bf_tickets` AS `Ticket` WHERE `ticket_type_id` = 3 AND `ticket_status_id` = 2 LIMIT 100 | 1 | 1 | 1 | |
SELECT `Localization`.`id`, `Localization`.`name`, `Localization`.`icon`, `Localization`.`iso_code` FROM `jsscrm_crm`.`bf_localizations` AS `Localization` WHERE `iso_code` = 'en' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Localization`.`id`, `Localization`.`name`, `Localization`.`icon`, `Localization`.`iso_code` FROM `jsscrm_crm`.`bf_localizations` AS `Localization` WHERE `iso_code` = 'en' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Localization`.`id`, `Localization`.`name`, `Localization`.`icon`, `Localization`.`iso_code` FROM `jsscrm_crm`.`bf_localizations` AS `Localization` WHERE 1 = 1 LIMIT 100 | 1 | 1 | 1 | |
SELECT `Navigation`.`id` FROM `jsscrm_crm`.`bf_navigations` AS `Navigation` WHERE `key` = 'SYSTEM_MENU' AND `parent_id` IS NULL LIMIT 1 | 1 | 1 | 1 | |
SELECT `Navigation`.`id`, `Navigation`.`parent_id`, `Navigation`.`lft`, `Navigation`.`rght`, `Navigation`.`name`, `Navigation`.`key`, `Navigation`.`url`, `Navigation`.`icon`, `Navigation`.`class`, `Navigation`.`target`, `Navigation`.`badge`, `Navigation`.`is_mobile`, `Navigation`.`created`, `Navigation`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Navigation` WHERE 1 = 1 AND `Navigation`.`parent_id` = 88 ORDER BY `Navigation`.`lft` asc | 10 | 10 | 1 | maybe slow |
SELECT `Children`.`id`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`name`, `Children`.`key`, `Children`.`url`, `Children`.`icon`, `Children`.`class`, `Children`.`target`, `Children`.`badge`, `Children`.`is_mobile`, `Children`.`created`, `Children`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Children` WHERE `Children`.`parent_id` IN (12, 121, 181, 141, 69, 195, 168, 167, 86, 16) ORDER BY `lft` asc | 42 | 42 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 121 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 121 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 181 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 181 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 181 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 181 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 141 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 141 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 141 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 141 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 141 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 69 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 195 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 195 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 195 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 195 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 195 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 195 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 168 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 168 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 168 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 168 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 168 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 168 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 168 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 168 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 168 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 168 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 168 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 168 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 168 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 86 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 86 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 16 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 16 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 16 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 16 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 16 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 16 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 16 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 16 | 1 | 1 | 1 | |
SELECT `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Parent` WHERE `Parent`.`id` = 16 | 1 | 1 | 1 | |
SELECT `Children`.`id`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`name`, `Children`.`key`, `Children`.`url`, `Children`.`icon`, `Children`.`class`, `Children`.`target`, `Children`.`badge`, `Children`.`is_mobile`, `Children`.`created`, `Children`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Children` WHERE `Children`.`parent_id` IN (124, 176, 182, 188, 189, 183, 159, 156, 144, 171, 192, 70, 196, 199, 200, 197, 201, 198, 169, 202, 173, 178, 193, 203, 174, 204, 205, 208, 206, 175, 170, 112, 177, 127, 130, 172, 185, 190, 118, 133, 191, 101) ORDER BY `lft` asc | 27 | 27 | 1 | |
SELECT `Publication`.`id`, `Publication`.`localization_id`, `Publication`.`theme_id`, `Publication`.`subscription_id`, `Publication`.`color`, `Publication`.`symbol`, `Publication`.`name`, `Publication`.`domain`, `Publication`.`edition`, `Publication`.`description`, `Publication`.`read_more`, `Publication`.`email`, `Publication`.`phone`, `Publication`.`address`, `Publication`.`slogan`, `Publication`.`google_analytics_code`, `Publication`.`google_site_code`, `Publication`.`bing_site_code`, `Publication`.`active`, `Publication`.`is_public`, `Publication`.`created`, `Publication`.`modified`, (CONCAT('', `Publication`.`domain`)) AS `Publication__actual_domain`, (CONCAT(`Publication`.`name`, COALESCE(NULLIF(CONCAT('(', `Publication`.`edition`, ')'), '()'), ''))) AS `Publication__edition_name`, `NavigationsPublication`.`id`, `NavigationsPublication`.`navigation_id`, `NavigationsPublication`.`publication_id` FROM `jsscrm_crm`.`bf_publications` AS `Publication` JOIN `jsscrm_crm`.`bf_navigations_publications` AS `NavigationsPublication` ON (`NavigationsPublication`.`navigation_id` IN (124, 176, 182, 188, 189, 183, 159, 156, 144, 171, 192, 70, 196, 199, 200, 197, 201, 198, 169, 202, 173, 178, 193, 203, 174, 204, 205, 208, 206, 175, 170, 112, 177, 127, 130, 172, 185, 190, 118, 133, 191, 101) AND `NavigationsPublication`.`publication_id` = `Publication`.`id`) | 0 | 0 | 1 | maybe slow |
SELECT `Publication`.`id`, `Publication`.`localization_id`, `Publication`.`theme_id`, `Publication`.`subscription_id`, `Publication`.`color`, `Publication`.`symbol`, `Publication`.`name`, `Publication`.`domain`, `Publication`.`edition`, `Publication`.`description`, `Publication`.`read_more`, `Publication`.`email`, `Publication`.`phone`, `Publication`.`address`, `Publication`.`slogan`, `Publication`.`google_analytics_code`, `Publication`.`google_site_code`, `Publication`.`bing_site_code`, `Publication`.`active`, `Publication`.`is_public`, `Publication`.`created`, `Publication`.`modified`, (CONCAT('', `Publication`.`domain`)) AS `Publication__actual_domain`, (CONCAT(`Publication`.`name`, COALESCE(NULLIF(CONCAT('(', `Publication`.`edition`, ')'), '()'), ''))) AS `Publication__edition_name`, `NavigationsPublication`.`id`, `NavigationsPublication`.`navigation_id`, `NavigationsPublication`.`publication_id` FROM `jsscrm_crm`.`bf_publications` AS `Publication` JOIN `jsscrm_crm`.`bf_navigations_publications` AS `NavigationsPublication` ON (`NavigationsPublication`.`navigation_id` IN (12, 121, 181, 141, 69, 195, 168, 167, 86, 16) AND `NavigationsPublication`.`publication_id` = `Publication`.`id`) | 0 | 0 | 1 | maybe slow |
SELECT `Navigation`.`id`, `Navigation`.`parent_id`, `Navigation`.`lft`, `Navigation`.`rght`, `Navigation`.`name`, `Navigation`.`key`, `Navigation`.`url`, `Navigation`.`icon`, `Navigation`.`class`, `Navigation`.`target`, `Navigation`.`badge`, `Navigation`.`is_mobile`, `Navigation`.`created`, `Navigation`.`modified`, `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Navigation` LEFT JOIN `jsscrm_crm`.`bf_navigations` AS `Parent` ON (`Navigation`.`parent_id` = `Parent`.`id`) WHERE `Navigation`.`url` = '/admin/Employees/Login' LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `Navigation`.`id`, `Navigation`.`parent_id`, `Navigation`.`lft`, `Navigation`.`rght`, `Navigation`.`name`, `Navigation`.`key`, `Navigation`.`url`, `Navigation`.`icon`, `Navigation`.`class`, `Navigation`.`target`, `Navigation`.`badge`, `Navigation`.`is_mobile`, `Navigation`.`created`, `Navigation`.`modified`, `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`key`, `Parent`.`url`, `Parent`.`icon`, `Parent`.`class`, `Parent`.`target`, `Parent`.`badge`, `Parent`.`is_mobile`, `Parent`.`created`, `Parent`.`modified` FROM `jsscrm_crm`.`bf_navigations` AS `Navigation` LEFT JOIN `jsscrm_crm`.`bf_navigations` AS `Parent` ON (`Navigation`.`parent_id` = `Parent`.`id`) WHERE `Navigation`.`url` = '/admin/Employees/Index' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Authentication`.`id`, `Authentication`.`name` FROM `jsscrm_crm`.`bf_authentications` AS `Authentication` WHERE 1 = 1 ORDER BY `Authentication`.`name` asc | 0 | 0 | 1 | maybe slow |
SELECT `Department`.`id`, `Department`.`name` FROM `jsscrm_crm`.`bf_departments` AS `Department` WHERE 1 = 1 ORDER BY `Department`.`name` asc | 1 | 1 | 1 | |
SELECT `Role`.`id`, `Role`.`name` FROM `jsscrm_crm`.`bf_roles` AS `Role` WHERE 1 = 1 ORDER BY `Role`.`name` asc | 6 | 6 | 1 | maybe slow |