Hello,
Can somebody help me to understand why this query run in 18 seconds? It's a simple join between few lists. It might be because of where condition from query?
Showing rows 0 - 11 ( 12 total, Query took 18.2335 sec) [text: [BLOB - 9 B] - [BLOB - 26 B]]
Using explain i get this info (see attached image):
thank you
Can somebody help me to understand why this query run in 18 seconds? It's a simple join between few lists. It might be because of where condition from query?
Showing rows 0 - 11 ( 12 total, Query took 18.2335 sec) [text: [BLOB - 9 B] - [BLOB - 26 B]]
Code:
SELECT DISTINCT(`aplicatii_pipeline_campanii`.`stage`) AS `text`, `aplicatii_pipeline_campanii`.`stage` AS `value` FROM `aplicatii_pipeline_campanii`LEFT JOIN `aplicatii_pipeline_companii` AS `aplicatii_pipeline_companii` ON `aplicatii_pipeline_companii`.`id_campanie` = `aplicatii_pipeline_campanii`.`id` LEFT JOIN `jos_users` AS `jos_users` ON `jos_users`.`id` = `aplicatii_pipeline_companii`.`NAMEAGENTCONT` LEFT JOIN `jos_users` AS `jos_users_0` ON `jos_users_0`.`id` = `aplicatii_pipeline_companii`.`MAJ` LEFT JOIN `aplicatii_pipeline_categorii` AS `aplicatii_pipeline_categorii` ON `aplicatii_pipeline_categorii`.`id_pipeline_cat` = `aplicatii_pipeline_campanii`.`id` LEFT JOIN `aplicatii_pipeline_campanii` AS `aplicatii_pipeline_campanii_0` ON `aplicatii_pipeline_campanii_0`.`id` = `aplicatii_pipeline_categorii`.`id_pipeline_cat` LEFT JOIN `aplicatii_pipeline_info` AS `aplicatii_pipeline_info` ON `aplicatii_pipeline_info`.`id_pipeline_info` = `aplicatii_pipeline_campanii`.`id` LEFT JOIN `#__users` AS `jos_users_1` ON `jos_users_1`.`id` = `aplicatii_pipeline_info`.`actualizare` LEFT JOIN `aplicatii_pipeline_campanii` AS `aplicatii_pipeline_campanii_1` ON `aplicatii_pipeline_campanii_1`.`id` = `aplicatii_pipeline_info`.`id_pipeline_info` LEFT JOIN `aplicatii_pipeline_campanii` AS `aplicatii_pipeline_campanii_2` ON `aplicatii_pipeline_campanii_2`.`id` = `aplicatii_pipeline_companii`.`id_campanie` WHERE `aplicatii_pipeline_campanii`.`stage` IN ('Offering','Closed-not interested','Closed-Not proper to call','Call back','New opportunity','Closed-Healthcheck only','Closed-Lost','Closed-Won','Urgent issue-send to sales','New lead','Negotiating','Incorrect database ') ORDER BY text ASC
Using explain i get this info (see attached image):
thank you