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`.*, `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` = '23096')                                    
                                

                                    
                                        SELECT `e`.*, `link_table`.`parent_id`, `at_taille`.`value` AS `taille`, `at_color`.`value` AS `color` 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_taille` ON (`at_taille`.`entity_id` = `e`.`entity_id`) AND (`at_taille`.`attribute_id` = 492) AND (`at_taille`.`store_id` = 0)
 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) WHERE (link_table.parent_id = 23096) AND (at_taille.value IS NOT NULL) AND (at_color.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(23102, 23107, 23112, 23114, 23116, 23118, 23121, 23126, 23131, 23136, 23138, 23140, 23142, 23145, 23150, 23155, 23160, 23162, 23164, 23166, 23169, 23174, 23179, 23184, 23186, 23188, 23190, 23193, 27114, 27116, 27118, 27121, 30482, 30483, 30484, 30485, 35815, 35817, 35818, 35820, 44645, 44647, 44649, 44651, 58320, 58321, 58322, 58323, 58324, 58325, 58326, 58327, 69780, 69781, 69782, 69783, 69784, 69785, 69787, 69788, 69789, 69792, 69793, 69794, 76021, 76022, 76023, 76024, 80852, 81979, 81980, 81998, 81999, 83325, 83326, 83327, 87223, 87224, 87225, 87227, 87228, 87229, 87230, 87231, 87232, 87233, 87234, 87235, 100655, 100656, 100657, 100662, 105078, 105079, 105440, 105441, 105442, 105443, 105444, 105445))