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` = '39001')                                    
                                

                                    
                                        SELECT `e`.*, `link_table`.`parent_id`, `at_options_obligatoires`.`value` AS `options_obligatoires`, `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_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)
 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 = 39001) AND (at_options_obligatoires.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(29703, 29705, 29707, 29708, 29714, 29717, 29721, 29722, 39002, 39004, 39006, 39007, 39008, 39009, 39016, 39017, 39023, 39024, 39025, 29726, 35915, 44613, 44614, 59160, 59161, 59162, 59163, 69823, 69824, 69825, 69826, 69827, 69828, 70236, 71438, 71440, 71441, 71446, 71447, 71450, 71451, 71452, 71454, 71455, 71456, 71457, 71458, 71459, 71460, 83544, 83545, 83546, 83549, 83551, 83552, 83554, 83556, 83557, 75996, 76940, 77325, 82382, 83561, 83562, 83563, 83565, 83566, 83567, 83568, 83569, 83570, 83571, 83572, 83573, 83575, 83577, 87784, 87785, 87786, 87787, 87788, 87789, 87790, 87791, 87792, 87793, 87794, 87795, 82333, 99987, 99988, 99989, 99990))