Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `EcCategory`.`id`, `EcCategory`.`position`, `EcCategory`.`cat_id`, `EcCategory`.`title_abr_fra`, `EcCategory`.`title_abr_eng`, `EcCategory`.`title_abr_spa`, `EcCategory`.`title_fra`, `EcCategory`.`title_eng`, `EcCategory`.`title_spa`, `EcCategory`.`serie`, `EcCategory`.`introduction_fra`, `EcCategory`.`introduction_eng`, `EcCategory`.`introduction_spa`, `EcCategory`.`features_fra`, `EcCategory`.`features_eng`, `EcCategory`.`features_spa`, `EcCategory`.`caracteristics_fra`, `EcCategory`.`caracteristics_eng`, `EcCategory`.`caracteristics_spa`, `EcCategory`.`operation_fra`, `EcCategory`.`operation_eng`, `EcCategory`.`operation_spa`, `EcCategory`.`spec_file_fra`, `EcCategory`.`spec_file_eng`, `EcCategory`.`spec_file_spa`, `EcCategory`.`image`, `EcCategory`.`active`, `EcCategory`.`created`, `EcCategory`.`modified` FROM `enert008_enertec_v2_4_0_RC2`.`ec_categories` AS `EcCategory` WHERE `cat_id` = 'gl' | 1 | 1 | 0 | |
SELECT `EcSubCategory`.`id`, `EcSubCategory`.`position`, `EcSubCategory`.`sub_cat_id`, `EcSubCategory`.`cat_id`, `EcSubCategory`.`title_abr_fra`, `EcSubCategory`.`title_abr_eng`, `EcSubCategory`.`title_abr_spa`, `EcSubCategory`.`title_fra`, `EcSubCategory`.`title_eng`, `EcSubCategory`.`title_spa`, `EcSubCategory`.`introduction_fra`, `EcSubCategory`.`introduction_eng`, `EcSubCategory`.`introduction_spa`, `EcSubCategory`.`image`, `EcSubCategory`.`active`, `EcSubCategory`.`created`, `EcSubCategory`.`modified`, `EcSubCategory`.`correction` FROM `enert008_enertec_v2_4_0_RC2`.`ec_sub_categories` AS `EcSubCategory` WHERE `cat_id` = 'gl' AND `active` = '1' ORDER BY `position` ASC | 4 | 4 | 0 | |
SELECT `EcModel`.`id`, `EcModel`.`modele_id`, `EcModel`.`manufacturier`, `EcModel`.`sub_cat_id`, `EcModel`.`cat_id`, `EcModel`.`serie`, `EcModel`.`title_fra`, `EcModel`.`title_eng`, `EcModel`.`title_spa`, `EcModel`.`description_fra`, `EcModel`.`description_eng`, `EcModel`.`description_spa`, `EcModel`.`body_file_fra`, `EcModel`.`body_file_eng`, `EcModel`.`body_file_spa`, `EcModel`.`caracteristics_fra`, `EcModel`.`caracteristics_eng`, `EcModel`.`caracteristics_spa`, `EcModel`.`features_fra`, `EcModel`.`features_eng`, `EcModel`.`features_spa`, `EcModel`.`introduction_fra`, `EcModel`.`introduction_eng`, `EcModel`.`introduction_spa`, `EcModel`.`operation_fra`, `EcModel`.`operation_eng`, `EcModel`.`operation_spa`, `EcModel`.`spec_file_fra`, `EcModel`.`spec_file_eng`, `EcModel`.`spec_file_spa`, `EcModel`.`status`, `EcModel`.`download`, `EcModel`.`image_certificate`, `EcModel`.`active`, `EcModel`.`created`, `EcModel`.`modified`, `EcModel`.`modified_by`, `EcModel`.`corrected`, `EcModel`.`corrected_date`, `EcModel`.`corrected_by`, `EcModel`.`note` FROM `enert008_enertec_v2_4_0_RC2`.`ec_models` AS `EcModel` WHERE `cat_id` = 'gl' AND `active` = '1' ORDER BY `sub_cat_id` ASC, `modele_id` ASC | 10 | 10 | 1 | maybe slow |
SELECT `EcSubCategory`.`id`, `EcSubCategory`.`position`, `EcSubCategory`.`sub_cat_id`, `EcSubCategory`.`cat_id`, `EcSubCategory`.`title_abr_fra`, `EcSubCategory`.`title_abr_eng`, `EcSubCategory`.`title_abr_spa`, `EcSubCategory`.`title_fra`, `EcSubCategory`.`title_eng`, `EcSubCategory`.`title_spa`, `EcSubCategory`.`introduction_fra`, `EcSubCategory`.`introduction_eng`, `EcSubCategory`.`introduction_spa`, `EcSubCategory`.`image`, `EcSubCategory`.`active`, `EcSubCategory`.`created`, `EcSubCategory`.`modified`, `EcSubCategory`.`correction` FROM `enert008_enertec_v2_4_0_RC2`.`ec_sub_categories` AS `EcSubCategory` WHERE `sub_cat_id` = 'gl-aut' AND `active` = '1' ORDER BY `position` ASC | 1 | 1 | 0 | |
SELECT `EcManufacturersOrder`.`id`, `EcManufacturersOrder`.`position`, `EcManufacturersOrder`.`manufacturer`, `EcManufacturersOrder`.`sub_cat_id`, `EcManufacturersOrder`.`cat_id`, `EcManufacturersOrder`.`active`, `EcManufacturersOrder`.`created`, `EcManufacturersOrder`.`modified` FROM `enert008_enertec_v2_4_0_RC2`.`ec_manufacturers_order` AS `EcManufacturersOrder` WHERE `sub_cat_id` = 'gl-aut' AND `active` = '1' ORDER BY `position` ASC | 1 | 1 | 0 | |
SELECT `EcModel`.`id`, `EcModel`.`modele_id`, `EcModel`.`manufacturier`, `EcModel`.`sub_cat_id`, `EcModel`.`cat_id`, `EcModel`.`serie`, `EcModel`.`title_fra`, `EcModel`.`title_eng`, `EcModel`.`title_spa`, `EcModel`.`description_fra`, `EcModel`.`description_eng`, `EcModel`.`description_spa`, `EcModel`.`body_file_fra`, `EcModel`.`body_file_eng`, `EcModel`.`body_file_spa`, `EcModel`.`caracteristics_fra`, `EcModel`.`caracteristics_eng`, `EcModel`.`caracteristics_spa`, `EcModel`.`features_fra`, `EcModel`.`features_eng`, `EcModel`.`features_spa`, `EcModel`.`introduction_fra`, `EcModel`.`introduction_eng`, `EcModel`.`introduction_spa`, `EcModel`.`operation_fra`, `EcModel`.`operation_eng`, `EcModel`.`operation_spa`, `EcModel`.`spec_file_fra`, `EcModel`.`spec_file_eng`, `EcModel`.`spec_file_spa`, `EcModel`.`status`, `EcModel`.`download`, `EcModel`.`image_certificate`, `EcModel`.`active`, `EcModel`.`created`, `EcModel`.`modified`, `EcModel`.`modified_by`, `EcModel`.`corrected`, `EcModel`.`corrected_date`, `EcModel`.`corrected_by`, `EcModel`.`note` FROM `enert008_enertec_v2_4_0_RC2`.`ec_models` AS `EcModel` WHERE `sub_cat_id` = 'gl-aut' AND `active` = '1' | 5 | 5 | 0 | |
SELECT `EcModel`.`id`, `EcModel`.`modele_id`, `EcModel`.`manufacturier`, `EcModel`.`sub_cat_id`, `EcModel`.`cat_id`, `EcModel`.`serie`, `EcModel`.`title_fra`, `EcModel`.`title_eng`, `EcModel`.`title_spa`, `EcModel`.`description_fra`, `EcModel`.`description_eng`, `EcModel`.`description_spa`, `EcModel`.`body_file_fra`, `EcModel`.`body_file_eng`, `EcModel`.`body_file_spa`, `EcModel`.`caracteristics_fra`, `EcModel`.`caracteristics_eng`, `EcModel`.`caracteristics_spa`, `EcModel`.`features_fra`, `EcModel`.`features_eng`, `EcModel`.`features_spa`, `EcModel`.`introduction_fra`, `EcModel`.`introduction_eng`, `EcModel`.`introduction_spa`, `EcModel`.`operation_fra`, `EcModel`.`operation_eng`, `EcModel`.`operation_spa`, `EcModel`.`spec_file_fra`, `EcModel`.`spec_file_eng`, `EcModel`.`spec_file_spa`, `EcModel`.`status`, `EcModel`.`download`, `EcModel`.`image_certificate`, `EcModel`.`active`, `EcModel`.`created`, `EcModel`.`modified`, `EcModel`.`modified_by`, `EcModel`.`corrected`, `EcModel`.`corrected_date`, `EcModel`.`corrected_by`, `EcModel`.`note` FROM `enert008_enertec_v2_4_0_RC2`.`ec_models` AS `EcModel` WHERE `modele_id` = 'gl4k800' AND `active` = '1' | 1 | 1 | 1 | |
SELECT `EcProduct`.`id`, `EcProduct`.`produit_id`, `EcProduct`.`localisation`, `EcProduct`.`modele_id`, `EcProduct`.`description_fra`, `EcProduct`.`description_eng`, `EcProduct`.`description_spa`, `EcProduct`.`instruction_fra`, `EcProduct`.`instruction_eng`, `EcProduct`.`instruction_spa`, `EcProduct`.`status`, `EcProduct`.`image`, `EcProduct`.`active`, `EcProduct`.`modele_img`, `EcProduct`.`created`, `EcProduct`.`modified` FROM `enert008_enertec_v2_4_0_RC2`.`ec_products` AS `EcProduct` WHERE `modele_id` = 'gl4k800' AND `active` = '1' | 1 | 1 | 1 | |
select * from ec_models_options INNER JOIN ec_products ON ec_models_options.produit_id = ec_products.produit_id WHERE ec_models_options.modele_id = 'gl4k800' AND ec_products.active=true | 4 | 4 | 2 | maybe slow |
SELECT `EcProduct`.`id`, `EcProduct`.`produit_id`, `EcProduct`.`localisation`, `EcProduct`.`modele_id`, `EcProduct`.`description_fra`, `EcProduct`.`description_eng`, `EcProduct`.`description_spa`, `EcProduct`.`instruction_fra`, `EcProduct`.`instruction_eng`, `EcProduct`.`instruction_spa`, `EcProduct`.`status`, `EcProduct`.`image`, `EcProduct`.`active`, `EcProduct`.`modele_img`, `EcProduct`.`created`, `EcProduct`.`modified` FROM `enert008_enertec_v2_4_0_RC2`.`ec_products` AS `EcProduct` WHERE 1 = 1 ORDER BY `produit_id` ASC | 304 | 304 | 2 | |
SELECT `EcModel`.`id`, `EcModel`.`modele_id`, `EcModel`.`manufacturier`, `EcModel`.`sub_cat_id`, `EcModel`.`cat_id`, `EcModel`.`serie`, `EcModel`.`title_fra`, `EcModel`.`title_eng`, `EcModel`.`title_spa`, `EcModel`.`description_fra`, `EcModel`.`description_eng`, `EcModel`.`description_spa`, `EcModel`.`body_file_fra`, `EcModel`.`body_file_eng`, `EcModel`.`body_file_spa`, `EcModel`.`caracteristics_fra`, `EcModel`.`caracteristics_eng`, `EcModel`.`caracteristics_spa`, `EcModel`.`features_fra`, `EcModel`.`features_eng`, `EcModel`.`features_spa`, `EcModel`.`introduction_fra`, `EcModel`.`introduction_eng`, `EcModel`.`introduction_spa`, `EcModel`.`operation_fra`, `EcModel`.`operation_eng`, `EcModel`.`operation_spa`, `EcModel`.`spec_file_fra`, `EcModel`.`spec_file_eng`, `EcModel`.`spec_file_spa`, `EcModel`.`status`, `EcModel`.`download`, `EcModel`.`image_certificate`, `EcModel`.`active`, `EcModel`.`created`, `EcModel`.`modified`, `EcModel`.`modified_by`, `EcModel`.`corrected`, `EcModel`.`corrected_date`, `EcModel`.`corrected_by`, `EcModel`.`note` FROM `enert008_enertec_v2_4_0_RC2`.`ec_models` AS `EcModel` WHERE `modele_id` = 'gl4k800' AND `active` = '1' | 1 | 1 | 1 | |
SELECT * FROM ec_models WHERE sub_cat_id = 'gl-aut' AND modele_id < 'gl4k800' AND manufacturier = 'ENERTEC' ORDER BY modele_id desc, manufacturier LIMIT 1 | 1 | 1 | 0 | |
SELECT * FROM ec_models WHERE sub_cat_id = 'gl-aut' AND modele_id > 'gl4k800' AND manufacturier = 'ENERTEC' ORDER BY modele_id, manufacturier LIMIT 1 | 1 | 1 | 0 | |