| 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 `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`, `Theme`.`id`, `Theme`.`name`, `Theme`.`path` FROM `jsscrm_crm`.`bf_publications` AS `Publication` LEFT JOIN `jsscrm_crm`.`bf_themes` AS `Theme` ON (`Publication`.`theme_id` = `Theme`.`id`) WHERE `domain` = 'portal.jobsupportservices.com' 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`, `NavigationsPublication`.`id`, `NavigationsPublication`.`navigation_id`, `NavigationsPublication`.`publication_id` FROM `jsscrm_crm`.`bf_navigations` AS `Navigation` JOIN `jsscrm_crm`.`bf_navigations_publications` AS `NavigationsPublication` ON (`NavigationsPublication`.`publication_id` = 1 AND `NavigationsPublication`.`navigation_id` = `Navigation`.`id`) | 0 | 0 | 1 | maybe slow |
| SELECT `SearchType`.`id`, `SearchType`.`constant`, `SearchType`.`name`, `SearchType`.`icon`, `SearchType`.`is_fulltext`, `SearchType`.`created`, `SearchType`.`modified` FROM `jsscrm_crm`.`bf_search_types` AS `SearchType` WHERE 1 = 1 LIMIT 100 | 1 | 1 | 1 | |
| SELECT `Publication`.`edition`, (CONCAT('', `Publication`.`domain`)) AS `Publication__actual_domain` FROM `jsscrm_crm`.`bf_publications` AS `Publication` WHERE 1 = 1 ORDER BY `edition` asc | 2 | 2 | 1 | maybe slow |
| SELECT `Publication`.`id`, `Publication`.`edition` FROM `jsscrm_crm`.`bf_publications` AS `Publication` WHERE 1 = 1 ORDER BY `edition` asc | 2 | 2 | 1 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `jsscrm_crm`.`bf_tickets` AS `Ticket` WHERE `ticket_status_id` = 2 LIMIT 100 | 1 | 1 | 4 | maybe slow |
| 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 | 5 | maybe slow |
| 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 | 5 | maybe slow |
| 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 | 5 | maybe slow |
| 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 | 5 | maybe slow |
| 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 `ClientAgreement`.`id`, `ClientAgreement`.`client_agreement_status_id`, `ClientAgreement`.`client_id`, `ClientAgreement`.`employee_id`, `ClientAgreement`.`product_id`, `ClientAgreement`.`reconciled`, `ClientAgreement`.`balance`, `ClientAgreement`.`outstanding`, `ClientAgreement`.`ip_address`, `ClientAgreement`.`active`, `ClientAgreement`.`initialized`, `ClientAgreement`.`accessed`, `ClientAgreement`.`scanned`, `ClientAgreement`.`delete`, `ClientAgreement`.`deleted`, `ClientAgreement`.`expired`, `ClientAgreement`.`cancelled`, `ClientAgreement`.`renew`, `ClientAgreement`.`renewed`, `ClientAgreement`.`dirtied`, `ClientAgreement`.`created`, `ClientAgreement`.`updated` FROM `jsscrm_crm`.`bf_client_agreements` AS `ClientAgreement` WHERE `client_id` = 'www.CareerStarters.org' AND `client_agreement_status_id` NOT IN (3, 6) LIMIT 1 | 0 | 0 | 1 | maybe slow |
| SELECT `Client`.`id`, `Client`.`agent_id`, `Client`.`job_id`, `Client`.`product_id`, `Client`.`state_id`, `Client`.`gateway_profile_id`, `Client`.`agent_code`, `Client`.`email`, `Client`.`password`, `Client`.`first`, `Client`.`last`, `Client`.`phone`, `Client`.`address1`, `Client`.`address2`, `Client`.`city`, `Client`.`state`, `Client`.`zip`, `Client`.`aff`, `Client`.`aff2`, `Client`.`ip_address`, `Client`.`invoice`, `Client`.`flag`, `Client`.`created`, `Client`.`modified`, (CONCAT(`Client`.`first`, ' ', `Client`.`last`)) AS `Client__name` FROM `jsscrm_crm`.`bf_clients` AS `Client` WHERE `Client`.`id` = 'www.CareerStarters.org' LIMIT 1 | 0 | 0 | 1 | maybe slow |
| SELECT `Agent`.`id`, `Agent`.`employee_id`, `Agent`.`manager_id`, `Agent`.`alias`, `Agent`.`code`, `Agent`.`extension`, `Agent`.`analytics_code`, `Agent`.`created`, `Agent`.`updated` FROM `jsscrm_crm`.`bf_agents` AS `Agent` WHERE `Agent`.`id` = 170 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Product`.`id`, `Product`.`parent_id`, `Product`.`product_whitelabel_id`, `Product`.`product_benefit_id`, `Product`.`billing_network_id`, `Product`.`email_template_id`, `Product`.`sms_template_id`, `Product`.`name`, `Product`.`description`, `Product`.`group_title`, `Product`.`group_description`, `Product`.`group_button`, `Product`.`group_icon`, `Product`.`terms`, `Product`.`price`, `Product`.`payments`, `Product`.`term`, `Product`.`renews`, `Product`.`expires`, `Product`.`thank_you_url`, `Product`.`agent_screen`, `Product`.`already_purchased_url`, `Product`.`pixel_lead`, `Product`.`pixel_sale`, `Product`.`analytic_code`, `Product`.`metric_pay_id`, `Product`.`metric_pay_void_id`, `Product`.`metric_split_id`, `Product`.`metric_split_void_id`, `Product`.`delete`, `Product`.`deleted`, `Product`.`created`, `Product`.`updated`, `ProductBenefit`.`id`, `ProductBenefit`.`name`, `ProductBenefit`.`created`, `ProductBenefit`.`updated`, `ProductWhitelabel`.`id`, `ProductWhitelabel`.`analytic_code`, `ProductWhitelabel`.`name`, `ProductWhitelabel`.`title`, `ProductWhitelabel`.`company`, `ProductWhitelabel`.`hours`, `ProductWhitelabel`.`address`, `ProductWhitelabel`.`phone`, `ProductWhitelabel`.`website`, `ProductWhitelabel`.`email`, `ProductWhitelabel`.`terms_url`, `ProductWhitelabel`.`privacy_url`, `ProductWhitelabel`.`logo`, `ProductWhitelabel`.`primary`, `ProductWhitelabel`.`secondary`, `ProductWhitelabel`.`button`, `ProductWhitelabel`.`hover`, `ProductWhitelabel`.`border`, `ProductWhitelabel`.`created`, `ProductWhitelabel`.`updated` FROM `jsscrm_crm`.`bf_products` AS `Product` LEFT JOIN `jsscrm_crm`.`bf_product_benefits` AS `ProductBenefit` ON (`Product`.`product_benefit_id` = `ProductBenefit`.`id`) LEFT JOIN `jsscrm_crm`.`bf_product_whitelabels` AS `ProductWhitelabel` ON (`Product`.`product_whitelabel_id` = `ProductWhitelabel`.`id`) WHERE `Product`.`id` = 58 AND `delete` = '0' ORDER BY `Product`.`name` asc LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ProductBenefitItem`.`id`, `ProductBenefitItem`.`product_benefit_id`, `ProductBenefitItem`.`title`, `ProductBenefitItem`.`description`, `ProductBenefitItem`.`icon`, `ProductBenefitItem`.`color`, `ProductBenefitItem`.`mobile`, `ProductBenefitItem`.`order`, `ProductBenefitItem`.`created`, `ProductBenefitItem`.`updated` FROM `jsscrm_crm`.`bf_product_benefit_items` AS `ProductBenefitItem` WHERE `ProductBenefitItem`.`product_benefit_id` = (2) | 6 | 6 | 1 | maybe slow |
| SELECT `ProductGroup`.`id`, `ProductGroup`.`name`, `ProductGroup`.`created`, `ProductGroup`.`updated`, `ProductGroupsProduct`.`id`, `ProductGroupsProduct`.`product_id`, `ProductGroupsProduct`.`product_group_id` FROM `jsscrm_crm`.`bf_product_groups` AS `ProductGroup` JOIN `jsscrm_crm`.`bf_product_groups_products` AS `ProductGroupsProduct` ON (`ProductGroupsProduct`.`product_id` = 58 AND `ProductGroupsProduct`.`product_group_id` = `ProductGroup`.`id`) | 3 | 3 | 1 | maybe slow |
| SELECT `ProductGroup`.`id`, `ProductGroup`.`name`, `ProductGroup`.`created`, `ProductGroup`.`updated` FROM `jsscrm_crm`.`bf_product_groups` AS `ProductGroup` WHERE `ProductGroup`.`id` = 2 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Product`.`id`, `Product`.`parent_id`, `Product`.`product_whitelabel_id`, `Product`.`product_benefit_id`, `Product`.`billing_network_id`, `Product`.`email_template_id`, `Product`.`sms_template_id`, `Product`.`name`, `Product`.`description`, `Product`.`group_title`, `Product`.`group_description`, `Product`.`group_button`, `Product`.`group_icon`, `Product`.`terms`, `Product`.`price`, `Product`.`payments`, `Product`.`term`, `Product`.`renews`, `Product`.`expires`, `Product`.`thank_you_url`, `Product`.`agent_screen`, `Product`.`already_purchased_url`, `Product`.`pixel_lead`, `Product`.`pixel_sale`, `Product`.`analytic_code`, `Product`.`metric_pay_id`, `Product`.`metric_pay_void_id`, `Product`.`metric_split_id`, `Product`.`metric_split_void_id`, `Product`.`delete`, `Product`.`deleted`, `Product`.`created`, `Product`.`updated`, `ProductGroupsProduct`.`id`, `ProductGroupsProduct`.`product_id`, `ProductGroupsProduct`.`product_group_id` FROM `jsscrm_crm`.`bf_products` AS `Product` JOIN `jsscrm_crm`.`bf_product_groups_products` AS `ProductGroupsProduct` ON (`ProductGroupsProduct`.`product_group_id` = 2 AND `ProductGroupsProduct`.`product_id` = `Product`.`id`) | 1 | 1 | 1 | |
| SELECT `State`.`id`, `State`.`name` FROM `jsscrm_crm`.`bf_states` AS `State` WHERE 1 = 1 ORDER BY `State`.`name` asc | 54 | 54 | 1 | |
| SELECT `Agent`.`analytics_code` FROM `jsscrm_crm`.`bf_agents` AS `Agent` WHERE `Agent`.`id` = 170 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 `BillingNetwork`.`id`, `BillingNetwork`.`name` FROM `jsscrm_crm`.`bf_billing_networks` AS `BillingNetwork` WHERE 1 = 1 ORDER BY `BillingNetwork`.`name` asc | 3 | 3 | 1 | maybe slow |
| SELECT `Exam`.`id`, `Exam`.`name` FROM `jsscrm_crm`.`bf_exams` AS `Exam` WHERE 1 = 1 ORDER BY `Exam`.`name` asc | 8 | 8 | 1 | maybe slow |
| SELECT `FullPayMetric`.`id`, `FullPayMetric`.`name` FROM `jsscrm_crm`.`bf_metric_types` AS `FullPayMetric` WHERE 1 = 1 ORDER BY `FullPayMetric`.`name` asc | 28 | 28 | 1 | |
| SELECT `ParentProduct`.`id`, `ParentProduct`.`name` FROM `jsscrm_crm`.`bf_products` AS `ParentProduct` WHERE `delete` = '0' ORDER BY `ParentProduct`.`name` asc | 14 | 14 | 1 | maybe slow |
| SELECT `ProductBenefit`.`id`, `ProductBenefit`.`name` FROM `jsscrm_crm`.`bf_product_benefits` AS `ProductBenefit` WHERE 1 = 1 ORDER BY `ProductBenefit`.`name` asc | 6 | 6 | 1 | maybe slow |
| SELECT `ProductGroup`.`id`, `ProductGroup`.`name` FROM `jsscrm_crm`.`bf_product_groups` AS `ProductGroup` WHERE 1 = 1 ORDER BY `ProductGroup`.`name` asc | 4 | 4 | 1 | maybe slow |
| SELECT `ProductWhitelabel`.`id`, `ProductWhitelabel`.`title` FROM `jsscrm_crm`.`bf_product_whitelabels` AS `ProductWhitelabel` WHERE 1 = 1 ORDER BY `ProductWhitelabel`.`title` asc | 2 | 2 | 1 | maybe slow |