Magento Profiler

                                    
                                        SELECT `main_table`.* FROM `core_store` AS `main_table`                                    
                                

                                    
                                        SELECT `main_table`.* FROM `core_website` AS `main_table`                                    
                                

                                    
                                        SELECT `main_table`.* FROM `core_store_group` AS `main_table`                                    
                                

                                    
                                        SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table`
 INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id
 LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1
 LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0
 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`product_id` = '77616') AND (default_option_title.store_id = 0)                                    
                                

                                    
                                        SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '560') AND (tdv.store_id = 0)                                    
                                

                                    
                                        SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `selection`.*, `e`.`name`, `e`.`description`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`status`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`required_options`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`is_imported`, `e`.`reference_fournisseur`, `e`.`options_obligatoires`, `e`.`options_obligatoires_value`, `e`.`type_objet`, `e`.`type_objet_value`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`delai_en_stock`, `e`.`delai_en_stock_value`, `e`.`delai_sur_commande`, `e`.`delai_sur_commande_value`, `e`.`stock_location`, `e`.`stock_location_value`, `e`.`transporteur`, `e`.`transporteur_value`, `e`.`ean`, `e`.`popularity`, `e`.`colisage`, `e`.`magasins`, `e`.`ean_colombus`, `e`.`vendor`, `e`.`vendor_value`, `e`.`desc_json`, `e`.`service`, `e`.`nb_colis`, `e`.`vendor_sku`, `e`.`nuance`, `e`.`nuance_value`, `e`.`diametre`, `e`.`profondeur`, `e`.`largeur`, `e`.`hauteur`, `e`.`longueur`, `e`.`longueur_allonge`, `e`.`outdoor_indoor_les_2`, `e`.`outdoor_indoor_les_2_value`, `e`.`type_parasol`, `e`.`type_parasol_value`, `e`.`puissance`, `e`.`puissance_value`, `e`.`norme`, `e`.`classe_de_consommation`, `e`.`classe_de_consommation_value`, `e`.`variateur`, `e`.`irc`, `e`.`flux`, `e`.`temperature`, `e`.`temperature_value`, `e`.`format_source`, `e`.`format_source_value`, `e`.`energie_radiateur`, `e`.`energie_radiateur_value`, `e`.`declinaisons`, `e`.`bestsellers`, `e`.`profondeur_posee_tout_compris`, `e`.`source_fournie`, `e`.`poids_colis`, `e`.`dimensions_colis`, `e`.`hauteur_assise`, `e`.`availability_status`, `e`.`availability_status_value`, `e`.`colombus_designation_courte`, `e`.`colombus_designation_longue`, `e`.`declinaisons_text`, `e`.`sev_variation_axis`, `e`.`sev_labels`, `e`.`is_purchasable`, `e`.`can_show_price`, `e`.`tax_class_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id WHERE (e.status = 1) AND (((e.required_options != '1') OR (e.required_options IS NULL))) AND (selection.option_id IN (751, 752)) ORDER BY `selection`.`position` asc, `selection`.`selection_id` asc                                    
                                

                                    
                                        SELECT `main_table`.*, `cp_table`.`type_id`, `status_table`.`stock_status` FROM `cataloginventory_stock_item` AS `main_table`
 INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id
 LEFT JOIN `cataloginventory_stock_status` AS `status_table` ON main_table.product_id=status_table.product_id AND main_table.stock_id=status_table.stock_id AND status_table.website_id=1 WHERE (`main_table`.`stock_id` = '1') AND (`main_table`.`product_id` IN(77615, 77614))                                    
                                

                                    
                                        SELECT `main_table`.*, `option_value_default`.`title` AS `default_title`, IF(option_value.title IS NOT NULL, option_value.title, option_value_default.title) AS `title` FROM `catalog_product_bundle_option` AS `main_table`
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value_default` ON main_table.option_id = option_value_default.option_id and option_value_default.store_id = 0
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value` ON main_table.option_id = option_value.option_id and option_value.store_id = 1 WHERE (`main_table`.`parent_id` = '77616') ORDER BY `main_table`.`position` asc, `main_table`.`option_id` asc