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` = '76074') 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 `main_table`.* FROM `catalog_product_super_attribute` AS `main_table` WHERE (`product_id` = '76074')                                    
                                

                                    
                                        SELECT `e`.*, `link_table`.`parent_id`, `at_color`.`value` AS `color`, `at_options_obligatoires`.`value` AS `options_obligatoires` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_product_super_link` AS `link_table` ON link_table.product_id = e.entity_id
 INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
 INNER JOIN `catalog_product_entity_int` AS `at_color` ON (`at_color`.`entity_id` = `e`.`entity_id`) AND (`at_color`.`attribute_id` = 76) AND (`at_color`.`store_id` = 0)
 INNER JOIN `catalog_product_entity_int` AS `at_options_obligatoires` ON (`at_options_obligatoires`.`entity_id` = `e`.`entity_id`) AND (`at_options_obligatoires`.`attribute_id` = 553) AND (`at_options_obligatoires`.`store_id` = 0) WHERE (link_table.parent_id = 76074) AND (at_color.value IS NOT NULL) AND (at_options_obligatoires.value IS NOT NULL)                                    
                                

                                    
                                        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(76075, 76077, 76078, 76083, 76084, 76085, 76087, 76088, 76089, 76090, 76091, 76092, 76093, 76094, 76095, 76096, 76097, 76098, 76100, 76101, 76106, 76107, 76108, 76110, 76111, 76112, 76113, 76114, 76115, 76116, 76117, 76118, 76119, 76120, 76121, 76123, 76124, 76129, 76130, 76131, 76133, 76134, 76135, 76136, 76137, 76138, 76139, 76140, 76141, 76142, 76143, 76144, 76146, 76147, 76152, 76153, 76154, 76156, 76157, 76158, 76159, 76160, 76161, 76162, 76163, 76164, 76165, 76166, 87750, 87751, 87752, 87753, 87754, 87755, 87756, 87757, 87758, 87759, 87760, 87761, 87762, 87763, 87764, 87765, 87766, 87767, 87768, 87769, 99895, 99896, 99897, 99898, 103057, 103058, 103059, 103060, 103083, 103084, 103085, 103086))