MySQL статистика (201)
Query Rows Time Cached
SET SESSION sql_mode = '' - 0.000122 false
SHOW TABLES LIKE 'extrafields' 1 0.002780 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = seo_settings.id and (object_class='Admin_SeoParams')) as extrafields_calculated, seo_settings.* FROM seo_settings ORDER BY id desc LIMIT 0, 1 1 0.000513 false
SHOW TABLES LIKE 'extrafields' 1 0.001332 false
update seo_settings set individual_seo_settings = 'a:0:{}' - 0.000215 false
SHOW TABLES LIKE 'extrafields' 1 0.001502 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = shop_carts.id and (object_class='Shop_Cart')) as extrafields_calculated, shop_carts.* FROM shop_carts WHERE (shop_carts.cart_id = '7cb82658b3f83f2671fc3e88984867a92ad9fb5fa9ce1ccd97be3787309de0995c1a2ca98be1c5388d55da0485ff5ff019447b56aec17554a0b179d2c323085b') LIMIT 0, 1 0 0.000365 false
SHOW TABLES LIKE 'extrafields' 1 0.001172 false
SELECT items.id, items.parent_id, items.title, items.is_hidden_in_menu, items.sort_order, items.href, menus.code as menu_code, menus.use_code_in_links as menu_code_in_links, blocks.id as block_id, blocks.code as block_code, blocks.description, blocks.content, blocks.template, blocks.block_type, f.id as image_id, f.disk_name as image_path FROM admin_menu_items as items LEFT JOIN admin_menus as menus ON menus.id = items.menu_id LEFT JOIN admin_text_blocks as blocks ON blocks.id = items.text_block_id LEFT JOIN db_files as f ON f.master_object_id = items.id AND f.master_object_class = 'Admin_MenuItem' AND f.field = 'image' WHERE items.is_hidden is null ORDER BY items.parent_id, items.sort_order 7 0.000882 false
SHOW TABLES LIKE 'extrafields' 1 0.001500 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '2104') LIMIT 0, 1 1 0.001542 false
SHOW TABLES LIKE 'extrafields' 1 0.001468 false
SELECT DISTINCT cs.name FROM catalog_skus cs JOIN catalog_products cp ON cs.product_id = cp.id WHERE cp.category_id = '2104' AND cp.deleted IS NULL AND cp.hidden IS NULL AND cs.name IS NOT NULL AND cs.name != '' ORDER BY cs.name 0 0.000463 false
SELECT DISTINCT brand FROM catalog_products WHERE category_id = '2104' AND deleted IS NULL AND hidden IS NULL AND brand IS NOT NULL AND brand != '' ORDER BY brand 0 0.000406 false
SELECT DISTINCT collection FROM catalog_products WHERE category_id = '2104' AND deleted IS NULL AND hidden IS NULL AND collection IS NOT NULL AND collection != '' ORDER BY collection 0 0.000312 false
SELECT catalog_categories.* FROM catalog_categories ORDER BY sort_order asc 880 0.002710 false
SELECT id, level, parent_id FROM catalog_categories WHERE hidden is null AND deleted is null ORDER BY level ASC 876 0.002268 false
SELECT count(*) FROM catalog_products as products WHERE EXISTS (SELECT 1 FROM catalog_skus WHERE catalog_skus.product_id = products.id) AND products.category_id in ('2104') AND products.hidden is null AND products.deleted is null AND products.category_id in ('5', '6', '7', '2074', '2075', '2076', '2102', '2105', '2107', '2932', '2933', '2937', '2938', '8', '9', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '2077', '2078', '2079', '2080', '2081', '2082', '2083', '2104', '2106', '2108', '2109', '2110', '2111', '2112', '2113', '2114', '2115', '2116', '2117', '2118', '2119', '2120', '2121', '2122', '2123', '2124', '2125', '2126', '2127', '2128', '2129', '2130', '2131', '2132', '2133', '2134', '2135', '2136', '2137', '2138', '2139', '2140', '2141', '2142', '2143', '2144', '2145', '2146', '2147', '2148', '2149', '2150', '2151', '2152', '2153', '2154', '2155', '2156', '2157', '2158', '2159', '2160', '2161', '2162', '2163', '2164', '2165', '2166', '2167', '2168', '2169', '2170', '2171', '2172', '2934', '2084', '2085', '2086', '2087', '2088', '2089', '2090', '2101', '2103', '2173', '2174', '2175', '2176', '2177', '2178', '2179', '2180', '2181', '2182', '2183', '2184', '2185', '2186', '2187', '2188', '2189', '2190', '2191', '2192', '2193', '2194', '2195', '2196', '2197', '2198', '2199', '2200', '2201', '2202', '2203', '2204', '2205', '2206', '2207', '2208', '2209', '2210', '2211', '2212', '2213', '2214', '2215', '2216', '2217', '2218', '2219', '2220', '2221', '2222', '2223', '2224', '2225', '2226', '2227', '2228', '2229', '2230', '2231', '2232', '2233', '2234', '2235', '2236', '2237', '2238', '2239', '2240', '2241', '2242', '2243', '2244', '2245', '2246', '2247', '2248', '2249', '2250', '2251', '2252', '2253', '2254', '2255', '2256', '2257', '2258', '2259', '2260', '2261', '2262', '2263', '2264', '2265', '2266', '2267', '2268', '2269', '2270', '2271', '2272', '2273', '2274', '2275', '2276', '2277', '2278', '2279', '2280', '2281', '2282', '2283', '2284', '2285', '2286', '2287', '2288', '2289', '2290', '2291', '2292', '2293', '2294', '2295', '2296', '2297', '2298', '2299', '2300', '2301', '2302', '2303', '2304', '2305', '2306', '2307', '2308', '2309', '2310', '2311', '2312', '2313', '2314', '2315', '2316', '2317', '2318', '2319', '2320', '2321', '2322', '2323', '2324', '2325', '2326', '2327', '2328', '2329', '2330', '2331', '2332', '2333', '2334', '2335', '2336', '2337', '2338', '2339', '2340', '2341', '2342', '2343', '2344', '2345', '2346', '2347', '2348', '2349', '2350', '2351', '2352', '2353', '2354', '2355', '2356', '2357', '2358', '2359', '2360', '2361', '2362', '2363', '2364', '2365', '2366', '2367', '2368', '2369', '2370', '2371', '2372', '2373', '2374', '2375', '2376', '2377', '2378', '2379', '2380', '2381', '2382', '2383', '2384', '2385', '2386', '2387', '2388', '2389', '2390', '2391', '2392', '2393', '2394', '2395', '2396', '2397', '2398', '2399', '2400', '2401', '2402', '2403', '2929', '2930', '2931', '2091', '2092', '2093', '2094', '2095', '2096', '2404', '2405', '2406', '2407', '2408', '2409', '2410', '2411', '2412', '2413', '2414', '2415', '2416', '2417', '2418', '2419', '2420', '2421', '2422', '2423', '2424', '2425', '2426', '2427', '2428', '2429', '2430', '2431', '2432', '2433', '2434', '2435', '2436', '2437', '2438', '2439', '2440', '2441', '2442', '2443', '2444', '2445', '2446', '2447', '2448', '2449', '2450', '2451', '2452', '2453', '2454', '2455', '2456', '2457', '2458', '2459', '2460', '2461', '2462', '2463', '2464', '2465', '2466', '2467', '2468', '2469', '2470', '2471', '2472', '2473', '2474', '2475', '2476', '2477', '2478', '2479', '2480', '2481', '2482', '2483', '2484', '2485', '2486', '2487', '2488', '2489', '2490', '2491', '2492', '2493', '2494', '2495', '2496', '2497', '2498', '2499', '2500', '2501', '2502', '2503', '2504', '2505', '2506', '2507', '2508', '2509', '2510', '2511', '2512', '2513', '2514', '2515', '2516', '2517', '2518', '2519', '2520', '2521', '2522', '2523', '2524', '2525', '2526', '2527', '2528', '2529', '2530', '2531', '2532', '2533', '2534', '2535', '2536', '2537', '2538', '2539', '2540', '2541', '2542', '2543', '2544', '2545', '2546', '2547', '2548', '2549', '2550', '2551', '2552', '2553', '2554', '2555', '2556', '2557', '2558', '2559', '2560', '2561', '2562', '2563', '2564', '2565', '2566', '2567', '2568', '2569', '2570', '2571', '2572', '2573', '2574', '2575', '2576', '2577', '2578', '2579', '2580', '2581', '2582', '2583', '2584', '2585', '2586', '2587', '2588', '2589', '2590', '2591', '2592', '2593', '2594', '2595', '2596', '2597', '2598', '2599', '2600', '2601', '2602', '2603', '2604', '2605', '2606', '2607', '2608', '2609', '2610', '2611', '2612', '2613', '2614', '2615', '2616', '2617', '2618', '2619', '2620', '2621', '2622', '2623', '2624', '2625', '2626', '2627', '2628', '2629', '2630', '2631', '2632', '2633', '2634', '2635', '2636', '2637', '2638', '2639', '2640', '2641', '2642', '2643', '2644', '2645', '2646', '2647', '2648', '2649', '2650', '2651', '2652', '2653', '2654', '2655', '2656', '2657', '2658', '2659', '2660', '2661', '2662', '2663', '2664', '2665', '2666', '2667', '2668', '2669', '2670', '2671', '2672', '2673', '2674', '2675', '2676', '2677', '2678', '2679', '2680', '2681', '2682', '2683', '2684', '2685', '2686', '2687', '2688', '2689', '2690', '2691', '2692', '2693', '2694', '2695', '2696', '2697', '2698', '2699', '2700', '2701', '2702', '2703', '2704', '2705', '2706', '2707', '2708', '2709', '2710', '2711', '2712', '2713', '2714', '2715', '2716', '2717', '2718', '2719', '2720', '2721', '2722', '2723', '2724', '2725', '2726', '2727', '2728', '2729', '2730', '2731', '2732', '2733', '2734', '2735', '2736', '2737', '2738', '2739', '2740', '2741', '2742', '2743', '2744', '2745', '2746', '2747', '2748', '2749', '2750', '2751', '2752', '2753', '2754', '2755', '2756', '2757', '2758', '2759', '2760', '2761', '2762', '2763', '2764', '2765', '2766', '2767', '2768', '2769', '2770', '2771', '2772', '2773', '2774', '2775', '2776', '2777', '2778', '2779', '2780', '2781', '2782', '2783', '2784', '2785', '2786', '2787', '2788', '2789', '2790', '2791', '2792', '2793', '2794', '2795', '2796', '2797', '2798', '2799', '2800', '2801', '2802', '2803', '2804', '2805', '2806', '2807', '2808', '2809', '2810', '2811', '2812', '2813', '2814', '2815', '2816', '2817', '2818', '2819', '2820', '2821', '2822', '2823', '2824', '2825', '2826', '2827', '2828', '2829', '2830', '2831', '2832', '2833', '2834', '2835', '2836', '2837', '2838', '2839', '2840', '2841', '2842', '2843', '2844', '2845', '2846', '2847', '2848', '2849', '2850', '2851', '2852', '2853', '2854', '2855', '2856', '2857', '2858', '2859', '2860', '2861', '2862', '2863', '2864', '2865', '2866', '2867', '2868', '2869', '2870', '2871', '2872', '2873', '2874', '2875', '2876', '2877', '2878', '2879', '2880', '2881', '2882', '2883', '2884', '2885', '2886', '2887', '2888', '2889', '2890', '2891', '2892', '2893', '2894', '2895', '2896', '2897', '2898', '2935', '2936', '2899', '2900', '2901', '2902', '2903', '2904', '2905', '2906', '2907', '2908', '2909', '2910', '2911', '2912', '2913', '2914', '2915', '2916', '2917', '2918', '2919', '2920', '2921', '2922', '2923', '2924', '2925', '2926', '2927', '2928') 1 0.003318 false
SELECT products.* FROM catalog_products as products WHERE EXISTS (SELECT 1 FROM catalog_skus WHERE catalog_skus.product_id = products.id) AND products.category_id in ('2104') AND products.hidden is null AND products.deleted is null AND products.category_id in ('5', '6', '7', '2074', '2075', '2076', '2102', '2105', '2107', '2932', '2933', '2937', '2938', '8', '9', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '2077', '2078', '2079', '2080', '2081', '2082', '2083', '2104', '2106', '2108', '2109', '2110', '2111', '2112', '2113', '2114', '2115', '2116', '2117', '2118', '2119', '2120', '2121', '2122', '2123', '2124', '2125', '2126', '2127', '2128', '2129', '2130', '2131', '2132', '2133', '2134', '2135', '2136', '2137', '2138', '2139', '2140', '2141', '2142', '2143', '2144', '2145', '2146', '2147', '2148', '2149', '2150', '2151', '2152', '2153', '2154', '2155', '2156', '2157', '2158', '2159', '2160', '2161', '2162', '2163', '2164', '2165', '2166', '2167', '2168', '2169', '2170', '2171', '2172', '2934', '2084', '2085', '2086', '2087', '2088', '2089', '2090', '2101', '2103', '2173', '2174', '2175', '2176', '2177', '2178', '2179', '2180', '2181', '2182', '2183', '2184', '2185', '2186', '2187', '2188', '2189', '2190', '2191', '2192', '2193', '2194', '2195', '2196', '2197', '2198', '2199', '2200', '2201', '2202', '2203', '2204', '2205', '2206', '2207', '2208', '2209', '2210', '2211', '2212', '2213', '2214', '2215', '2216', '2217', '2218', '2219', '2220', '2221', '2222', '2223', '2224', '2225', '2226', '2227', '2228', '2229', '2230', '2231', '2232', '2233', '2234', '2235', '2236', '2237', '2238', '2239', '2240', '2241', '2242', '2243', '2244', '2245', '2246', '2247', '2248', '2249', '2250', '2251', '2252', '2253', '2254', '2255', '2256', '2257', '2258', '2259', '2260', '2261', '2262', '2263', '2264', '2265', '2266', '2267', '2268', '2269', '2270', '2271', '2272', '2273', '2274', '2275', '2276', '2277', '2278', '2279', '2280', '2281', '2282', '2283', '2284', '2285', '2286', '2287', '2288', '2289', '2290', '2291', '2292', '2293', '2294', '2295', '2296', '2297', '2298', '2299', '2300', '2301', '2302', '2303', '2304', '2305', '2306', '2307', '2308', '2309', '2310', '2311', '2312', '2313', '2314', '2315', '2316', '2317', '2318', '2319', '2320', '2321', '2322', '2323', '2324', '2325', '2326', '2327', '2328', '2329', '2330', '2331', '2332', '2333', '2334', '2335', '2336', '2337', '2338', '2339', '2340', '2341', '2342', '2343', '2344', '2345', '2346', '2347', '2348', '2349', '2350', '2351', '2352', '2353', '2354', '2355', '2356', '2357', '2358', '2359', '2360', '2361', '2362', '2363', '2364', '2365', '2366', '2367', '2368', '2369', '2370', '2371', '2372', '2373', '2374', '2375', '2376', '2377', '2378', '2379', '2380', '2381', '2382', '2383', '2384', '2385', '2386', '2387', '2388', '2389', '2390', '2391', '2392', '2393', '2394', '2395', '2396', '2397', '2398', '2399', '2400', '2401', '2402', '2403', '2929', '2930', '2931', '2091', '2092', '2093', '2094', '2095', '2096', '2404', '2405', '2406', '2407', '2408', '2409', '2410', '2411', '2412', '2413', '2414', '2415', '2416', '2417', '2418', '2419', '2420', '2421', '2422', '2423', '2424', '2425', '2426', '2427', '2428', '2429', '2430', '2431', '2432', '2433', '2434', '2435', '2436', '2437', '2438', '2439', '2440', '2441', '2442', '2443', '2444', '2445', '2446', '2447', '2448', '2449', '2450', '2451', '2452', '2453', '2454', '2455', '2456', '2457', '2458', '2459', '2460', '2461', '2462', '2463', '2464', '2465', '2466', '2467', '2468', '2469', '2470', '2471', '2472', '2473', '2474', '2475', '2476', '2477', '2478', '2479', '2480', '2481', '2482', '2483', '2484', '2485', '2486', '2487', '2488', '2489', '2490', '2491', '2492', '2493', '2494', '2495', '2496', '2497', '2498', '2499', '2500', '2501', '2502', '2503', '2504', '2505', '2506', '2507', '2508', '2509', '2510', '2511', '2512', '2513', '2514', '2515', '2516', '2517', '2518', '2519', '2520', '2521', '2522', '2523', '2524', '2525', '2526', '2527', '2528', '2529', '2530', '2531', '2532', '2533', '2534', '2535', '2536', '2537', '2538', '2539', '2540', '2541', '2542', '2543', '2544', '2545', '2546', '2547', '2548', '2549', '2550', '2551', '2552', '2553', '2554', '2555', '2556', '2557', '2558', '2559', '2560', '2561', '2562', '2563', '2564', '2565', '2566', '2567', '2568', '2569', '2570', '2571', '2572', '2573', '2574', '2575', '2576', '2577', '2578', '2579', '2580', '2581', '2582', '2583', '2584', '2585', '2586', '2587', '2588', '2589', '2590', '2591', '2592', '2593', '2594', '2595', '2596', '2597', '2598', '2599', '2600', '2601', '2602', '2603', '2604', '2605', '2606', '2607', '2608', '2609', '2610', '2611', '2612', '2613', '2614', '2615', '2616', '2617', '2618', '2619', '2620', '2621', '2622', '2623', '2624', '2625', '2626', '2627', '2628', '2629', '2630', '2631', '2632', '2633', '2634', '2635', '2636', '2637', '2638', '2639', '2640', '2641', '2642', '2643', '2644', '2645', '2646', '2647', '2648', '2649', '2650', '2651', '2652', '2653', '2654', '2655', '2656', '2657', '2658', '2659', '2660', '2661', '2662', '2663', '2664', '2665', '2666', '2667', '2668', '2669', '2670', '2671', '2672', '2673', '2674', '2675', '2676', '2677', '2678', '2679', '2680', '2681', '2682', '2683', '2684', '2685', '2686', '2687', '2688', '2689', '2690', '2691', '2692', '2693', '2694', '2695', '2696', '2697', '2698', '2699', '2700', '2701', '2702', '2703', '2704', '2705', '2706', '2707', '2708', '2709', '2710', '2711', '2712', '2713', '2714', '2715', '2716', '2717', '2718', '2719', '2720', '2721', '2722', '2723', '2724', '2725', '2726', '2727', '2728', '2729', '2730', '2731', '2732', '2733', '2734', '2735', '2736', '2737', '2738', '2739', '2740', '2741', '2742', '2743', '2744', '2745', '2746', '2747', '2748', '2749', '2750', '2751', '2752', '2753', '2754', '2755', '2756', '2757', '2758', '2759', '2760', '2761', '2762', '2763', '2764', '2765', '2766', '2767', '2768', '2769', '2770', '2771', '2772', '2773', '2774', '2775', '2776', '2777', '2778', '2779', '2780', '2781', '2782', '2783', '2784', '2785', '2786', '2787', '2788', '2789', '2790', '2791', '2792', '2793', '2794', '2795', '2796', '2797', '2798', '2799', '2800', '2801', '2802', '2803', '2804', '2805', '2806', '2807', '2808', '2809', '2810', '2811', '2812', '2813', '2814', '2815', '2816', '2817', '2818', '2819', '2820', '2821', '2822', '2823', '2824', '2825', '2826', '2827', '2828', '2829', '2830', '2831', '2832', '2833', '2834', '2835', '2836', '2837', '2838', '2839', '2840', '2841', '2842', '2843', '2844', '2845', '2846', '2847', '2848', '2849', '2850', '2851', '2852', '2853', '2854', '2855', '2856', '2857', '2858', '2859', '2860', '2861', '2862', '2863', '2864', '2865', '2866', '2867', '2868', '2869', '2870', '2871', '2872', '2873', '2874', '2875', '2876', '2877', '2878', '2879', '2880', '2881', '2882', '2883', '2884', '2885', '2886', '2887', '2888', '2889', '2890', '2891', '2892', '2893', '2894', '2895', '2896', '2897', '2898', '2935', '2936', '2899', '2900', '2901', '2902', '2903', '2904', '2905', '2906', '2907', '2908', '2909', '2910', '2911', '2912', '2913', '2914', '2915', '2916', '2917', '2918', '2919', '2920', '2921', '2922', '2923', '2924', '2925', '2926', '2927', '2928') LIMIT 0, 0 0 0.001723 false
SHOW TABLES LIKE 'extrafields' 1 0.001942 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_module_settings.id and (object_class='Admin_ModuleSettings')) as extrafields_calculated, admin_module_settings.* FROM admin_module_settings WHERE (admin_module_settings.module_id='admin') AND (admin_module_settings.form_id='default') LIMIT 0, 1 1 0.000855 false
SHOW TABLES LIKE 'extrafields' 1 0.001996 false
SHOW TABLES LIKE 'extrafields' 1 0.001395 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = shop_carts.id and (object_class='Shop_Cart')) as extrafields_calculated, shop_carts.* FROM shop_carts WHERE (shop_carts.cart_id = '7cb82658b3f83f2671fc3e88984867a92ad9fb5fa9ce1ccd97be3787309de0995c1a2ca98be1c5388d55da0485ff5ff019447b56aec17554a0b179d2c323085b') LIMIT 0, 1 0 0.000354 false
SHOW TABLES LIKE 'extrafields' 1 0.001333 false
SHOW TABLES LIKE 'extrafields' 1 0.001338 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '5') LIMIT 0, 1 1 0.000759 false
SHOW TABLES LIKE 'extrafields' 1 0.001254 false
SHOW TABLES LIKE 'extrafields' 1 0.001440 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '5') AND (catalog_categories.deleted <> 1 or deleted is null) 5 0.001139 false
SHOW TABLES LIKE 'extrafields' 1 0.001340 false
SHOW TABLES LIKE 'extrafields' 1 0.001669 false
SHOW TABLES LIKE 'extrafields' 1 0.001611 false
SHOW TABLES LIKE 'extrafields' 1 0.001410 false
SHOW TABLES LIKE 'extrafields' 1 0.001614 false
SHOW TABLES LIKE 'extrafields' 1 0.001679 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '6') LIMIT 0, 1 1 0.001080 false
SHOW TABLES LIKE 'extrafields' 1 0.001717 false
SHOW TABLES LIKE 'extrafields' 1 0.001466 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '6') AND (catalog_categories.deleted <> 1 or deleted is null) 4 0.001036 false
SHOW TABLES LIKE 'extrafields' 1 0.001364 false
SHOW TABLES LIKE 'extrafields' 1 0.001410 false
SHOW TABLES LIKE 'extrafields' 1 0.001259 false
SHOW TABLES LIKE 'extrafields' 1 0.001277 false
SHOW TABLES LIKE 'extrafields' 1 0.001275 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '7') LIMIT 0, 1 1 0.000809 false
SHOW TABLES LIKE 'extrafields' 1 0.001212 false
SHOW TABLES LIKE 'extrafields' 1 0.001381 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '7') AND (catalog_categories.deleted <> 1 or deleted is null) 3 0.001188 false
SHOW TABLES LIKE 'extrafields' 1 0.001295 false
SHOW TABLES LIKE 'extrafields' 1 0.001447 false
SHOW TABLES LIKE 'extrafields' 1 0.001747 false
SHOW TABLES LIKE 'extrafields' 1 0.001731 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '2074') LIMIT 0, 1 1 0.000948 false
SHOW TABLES LIKE 'extrafields' 1 0.001652 false
SHOW TABLES LIKE 'extrafields' 1 0.001487 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '2074') AND (catalog_categories.deleted <> 1 or deleted is null) 66 0.004563 false
SHOW TABLES LIKE 'extrafields' 1 0.001532 false
SHOW TABLES LIKE 'extrafields' 1 0.001434 false
SHOW TABLES LIKE 'extrafields' 1 0.001717 false
SHOW TABLES LIKE 'extrafields' 1 0.001769 false
SHOW TABLES LIKE 'extrafields' 1 0.001749 false
SHOW TABLES LIKE 'extrafields' 1 0.001952 false
SHOW TABLES LIKE 'extrafields' 1 0.001768 false
SHOW TABLES LIKE 'extrafields' 1 0.001782 false
SHOW TABLES LIKE 'extrafields' 1 0.001981 false
SHOW TABLES LIKE 'extrafields' 1 0.001655 false
SHOW TABLES LIKE 'extrafields' 1 0.001859 false
SHOW TABLES LIKE 'extrafields' 1 0.002038 false
SHOW TABLES LIKE 'extrafields' 1 0.001776 false
SHOW TABLES LIKE 'extrafields' 1 0.001384 false
SHOW TABLES LIKE 'extrafields' 1 0.001246 false
SHOW TABLES LIKE 'extrafields' 1 0.001351 false
SHOW TABLES LIKE 'extrafields' 1 0.001210 false
SHOW TABLES LIKE 'extrafields' 1 0.001321 false
SHOW TABLES LIKE 'extrafields' 1 0.001347 false
SHOW TABLES LIKE 'extrafields' 1 0.001566 false
SHOW TABLES LIKE 'extrafields' 1 0.001315 false
SHOW TABLES LIKE 'extrafields' 1 0.001974 false
SHOW TABLES LIKE 'extrafields' 1 0.001586 false
SHOW TABLES LIKE 'extrafields' 1 0.001769 false
SHOW TABLES LIKE 'extrafields' 1 0.001569 false
SHOW TABLES LIKE 'extrafields' 1 0.001635 false
SHOW TABLES LIKE 'extrafields' 1 0.001551 false
SHOW TABLES LIKE 'extrafields' 1 0.001670 false
SHOW TABLES LIKE 'extrafields' 1 0.001479 false
SHOW TABLES LIKE 'extrafields' 1 0.001271 false
SHOW TABLES LIKE 'extrafields' 1 0.001246 false
SHOW TABLES LIKE 'extrafields' 1 0.001253 false
SHOW TABLES LIKE 'extrafields' 1 0.001233 false
SHOW TABLES LIKE 'extrafields' 1 0.001253 false
SHOW TABLES LIKE 'extrafields' 1 0.001353 false
SHOW TABLES LIKE 'extrafields' 1 0.001872 false
SHOW TABLES LIKE 'extrafields' 1 0.001423 false
SHOW TABLES LIKE 'extrafields' 1 0.001385 false
SHOW TABLES LIKE 'extrafields' 1 0.001367 false
SHOW TABLES LIKE 'extrafields' 1 0.001270 false
SHOW TABLES LIKE 'extrafields' 1 0.001169 false
SHOW TABLES LIKE 'extrafields' 1 0.001240 false
SHOW TABLES LIKE 'extrafields' 1 0.001153 false
SHOW TABLES LIKE 'extrafields' 1 0.001242 false
SHOW TABLES LIKE 'extrafields' 1 0.001108 false
SHOW TABLES LIKE 'extrafields' 1 0.001238 false
SHOW TABLES LIKE 'extrafields' 1 0.001317 false
SHOW TABLES LIKE 'extrafields' 1 0.001202 false
SHOW TABLES LIKE 'extrafields' 1 0.001328 false
SHOW TABLES LIKE 'extrafields' 1 0.001222 false
SHOW TABLES LIKE 'extrafields' 1 0.001276 false
SHOW TABLES LIKE 'extrafields' 1 0.001345 false
SHOW TABLES LIKE 'extrafields' 1 0.001308 false
SHOW TABLES LIKE 'extrafields' 1 0.002062 false
SHOW TABLES LIKE 'extrafields' 1 0.001669 false
SHOW TABLES LIKE 'extrafields' 1 0.002046 false
SHOW TABLES LIKE 'extrafields' 1 0.001712 false
SHOW TABLES LIKE 'extrafields' 1 0.002130 false
SHOW TABLES LIKE 'extrafields' 1 0.001521 false
SHOW TABLES LIKE 'extrafields' 1 0.001642 false
SHOW TABLES LIKE 'extrafields' 1 0.001375 false
SHOW TABLES LIKE 'extrafields' 1 0.001467 false
SHOW TABLES LIKE 'extrafields' 1 0.001373 false
SHOW TABLES LIKE 'extrafields' 1 0.001282 false
SHOW TABLES LIKE 'extrafields' 1 0.001311 false
SHOW TABLES LIKE 'extrafields' 1 0.001223 false
SHOW TABLES LIKE 'extrafields' 1 0.001688 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '2075') LIMIT 0, 1 1 0.001185 false
SHOW TABLES LIKE 'extrafields' 1 0.001763 false
SHOW TABLES LIKE 'extrafields' 1 0.002045 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '2075') AND (catalog_categories.deleted <> 1 or deleted is null) 5 0.001327 false
SHOW TABLES LIKE 'extrafields' 1 0.001665 false
SHOW TABLES LIKE 'extrafields' 1 0.001662 false
SHOW TABLES LIKE 'extrafields' 1 0.001688 false
SHOW TABLES LIKE 'extrafields' 1 0.002026 false
SHOW TABLES LIKE 'extrafields' 1 0.001941 false
SHOW TABLES LIKE 'extrafields' 1 0.001768 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '2076') LIMIT 0, 1 1 0.001322 false
SHOW TABLES LIKE 'extrafields' 1 0.001568 false
SHOW TABLES LIKE 'extrafields' 1 0.001535 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '2076') AND (catalog_categories.deleted <> 1 or deleted is null) 1 0.000957 false
SHOW TABLES LIKE 'extrafields' 1 0.002062 false
SHOW TABLES LIKE 'extrafields' 1 0.001600 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '2102') LIMIT 0, 1 1 0.000980 false
SHOW TABLES LIKE 'extrafields' 1 0.001496 false
SHOW TABLES LIKE 'extrafields' 1 0.001784 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '2102') AND (catalog_categories.deleted <> 1 or deleted is null) 0 0.001056 false
SHOW TABLES LIKE 'extrafields' 1 0.001736 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '2105') LIMIT 0, 1 1 0.000980 false
SHOW TABLES LIKE 'extrafields' 1 0.001291 false
SHOW TABLES LIKE 'extrafields' 1 0.001367 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '2105') AND (catalog_categories.deleted <> 1 or deleted is null) 0 0.000699 false
SHOW TABLES LIKE 'extrafields' 1 0.001265 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '2107') LIMIT 0, 1 1 0.000803 false
SHOW TABLES LIKE 'extrafields' 1 0.001454 false
SHOW TABLES LIKE 'extrafields' 1 0.001177 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '2107') AND (catalog_categories.deleted <> 1 or deleted is null) 0 0.000805 false
SHOW TABLES LIKE 'extrafields' 1 0.001569 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '2932') LIMIT 0, 1 1 0.000939 false
SHOW TABLES LIKE 'extrafields' 1 0.001397 false
SHOW TABLES LIKE 'extrafields' 1 0.001946 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '2932') AND (catalog_categories.deleted <> 1 or deleted is null) 1 0.001001 false
SHOW TABLES LIKE 'extrafields' 1 0.001654 false
SHOW TABLES LIKE 'extrafields' 1 0.001289 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '2933') LIMIT 0, 1 1 0.000921 false
SHOW TABLES LIKE 'extrafields' 1 0.001358 false
SHOW TABLES LIKE 'extrafields' 1 0.001354 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '2933') AND (catalog_categories.deleted <> 1 or deleted is null) 2 0.000959 false
SHOW TABLES LIKE 'extrafields' 1 0.001366 false
SHOW TABLES LIKE 'extrafields' 1 0.001313 false
SHOW TABLES LIKE 'extrafields' 1 0.001311 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '2937') LIMIT 0, 1 1 0.000809 false
SHOW TABLES LIKE 'extrafields' 1 0.001420 false
SHOW TABLES LIKE 'extrafields' 1 0.001431 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '2937') AND (catalog_categories.deleted <> 1 or deleted is null) 0 0.000763 false
SHOW TABLES LIKE 'extrafields' 1 0.001371 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '2938') LIMIT 0, 1 1 0.001020 false
SHOW TABLES LIKE 'extrafields' 1 0.001447 false
SHOW TABLES LIKE 'extrafields' 1 0.001342 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '2938') AND (catalog_categories.deleted <> 1 or deleted is null) 0 0.000758 false
SHOW TABLES LIKE 'extrafields' 1 0.001640 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menus.id and (object_class='Admin_Menu')) as extrafields_calculated, admin_menus.* FROM admin_menus WHERE (admin_menus.code = 'second_menu') LIMIT 0, 1 1 0.000586 false
SHOW TABLES LIKE 'extrafields' 1 0.001824 false
SHOW TABLES LIKE 'extrafields' 1 0.001660 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.menu_id = '4') AND (admin_menu_items.parent_id is null and (admin_menu_items.is_hidden is null or admin_menu_items.is_hidden=0) and (admin_menu_items.is_hidden_in_menu is null or admin_menu_items.is_hidden_in_menu=0)) ORDER BY group_name, sort_order 5 0.001081 false
SHOW TABLES LIKE 'extrafields' 1 0.001529 false
SHOW TABLES LIKE 'extrafields' 1 0.001564 false
SHOW TABLES LIKE 'extrafields' 1 0.001498 false
SHOW TABLES LIKE 'extrafields' 1 0.001847 false
SHOW TABLES LIKE 'extrafields' 1 0.001614 false
SELECT admin_menu_items.* FROM admin_menu_items ORDER BY sort_order 7 0.000562 false
SHOW TABLES LIKE 'extrafields' 1 0.001801 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menus.id and (object_class='Admin_Menu')) as extrafields_calculated, admin_menus.* FROM admin_menus WHERE (admin_menus.id = '4') LIMIT 0, 1 1 0.000533 false
SHOW TABLES LIKE 'extrafields' 1 0.001779 false
SHOW TABLES LIKE 'extrafields' 1 0.001585 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menus.id and (object_class='Admin_Menu')) as extrafields_calculated, admin_menus.* FROM admin_menus WHERE (admin_menus.code = 'second_menu') LIMIT 0, 1 1 0.000600 false
SHOW TABLES LIKE 'extrafields' 1 0.001499 false
SHOW TABLES LIKE 'extrafields' 1 0.001525 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.menu_id = '4') AND (admin_menu_items.parent_id is null and (admin_menu_items.is_hidden is null or admin_menu_items.is_hidden=0) and (admin_menu_items.is_hidden_in_menu is null or admin_menu_items.is_hidden_in_menu=0)) ORDER BY group_name, sort_order 5 0.000812 false
SHOW TABLES LIKE 'extrafields' 1 0.001505 false
SHOW TABLES LIKE 'extrafields' 1 0.001387 false
SHOW TABLES LIKE 'extrafields' 1 0.001798 false
SHOW TABLES LIKE 'extrafields' 1 0.001556 false
SHOW TABLES LIKE 'extrafields' 1 0.001511 false