MySQL статистика (200)
Query Rows Time Cached
SET SESSION sql_mode = '' - 0.000232 false
select count(*) from shop_carts where cart_id = 'f2999be67658c69ea03cbfbe50565690ddac31c06cb76968c7b90414c74162cf3e59789cb0bdec82aea8ef370a35b13fe16038bc4930d9455ebe3c298f349c3f' 1 0.000324 false
SHOW TABLES LIKE 'extrafields' 1 0.001852 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.000624 false
SHOW TABLES LIKE 'extrafields' 1 0.001643 false
update seo_settings set individual_seo_settings = 'a:0:{}' - 0.000216 false
SHOW TABLES LIKE 'extrafields' 1 0.001342 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.000714 false
SHOW TABLES LIKE 'extrafields' 1 0.001655 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 = '2934') LIMIT 0, 1 1 0.000744 false
SHOW TABLES LIKE 'extrafields' 1 0.001101 false
SELECT DISTINCT cs.name FROM catalog_skus cs JOIN catalog_products cp ON cs.product_id = cp.id WHERE cp.category_id = '2934' 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.000545 false
SELECT DISTINCT brand FROM catalog_products WHERE category_id = '2934' AND deleted IS NULL AND hidden IS NULL AND brand IS NOT NULL AND brand != '' ORDER BY brand 0 0.000405 false
SELECT DISTINCT collection FROM catalog_products WHERE category_id = '2934' AND deleted IS NULL AND hidden IS NULL AND collection IS NOT NULL AND collection != '' ORDER BY collection 0 0.000319 false
SELECT catalog_categories.* FROM catalog_categories ORDER BY sort_order asc 880 0.003168 false
SELECT id, level, parent_id FROM catalog_categories WHERE hidden is null AND deleted is null ORDER BY level ASC 876 0.001272 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 ('2934', '2101', '2103') 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.001734 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 ('2934', '2101', '2103') 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.000839 false
SHOW TABLES LIKE 'extrafields' 1 0.001114 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.000437 false
SHOW TABLES LIKE 'extrafields' 1 0.001293 false
SHOW TABLES LIKE 'extrafields' 1 0.001122 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 = 'f2999be67658c69ea03cbfbe50565690ddac31c06cb76968c7b90414c74162cf3e59789cb0bdec82aea8ef370a35b13fe16038bc4930d9455ebe3c298f349c3f') LIMIT 0, 1 0 0.000298 false
SHOW TABLES LIKE 'extrafields' 1 0.001427 false
SHOW TABLES LIKE 'extrafields' 1 0.001480 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.000848 false
SHOW TABLES LIKE 'extrafields' 1 0.001408 false
SHOW TABLES LIKE 'extrafields' 1 0.001442 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.001271 false
SHOW TABLES LIKE 'extrafields' 1 0.001496 false
SHOW TABLES LIKE 'extrafields' 1 0.001380 false
SHOW TABLES LIKE 'extrafields' 1 0.001402 false
SHOW TABLES LIKE 'extrafields' 1 0.001393 false
SHOW TABLES LIKE 'extrafields' 1 0.001386 false
SHOW TABLES LIKE 'extrafields' 1 0.001900 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.000656 false
SHOW TABLES LIKE 'extrafields' 1 0.001061 false
SHOW TABLES LIKE 'extrafields' 1 0.001098 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.000932 false
SHOW TABLES LIKE 'extrafields' 1 0.001121 false
SHOW TABLES LIKE 'extrafields' 1 0.001110 false
SHOW TABLES LIKE 'extrafields' 1 0.000993 false
SHOW TABLES LIKE 'extrafields' 1 0.001045 false
SHOW TABLES LIKE 'extrafields' 1 0.000961 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.000660 false
SHOW TABLES LIKE 'extrafields' 1 0.000978 false
SHOW TABLES LIKE 'extrafields' 1 0.001012 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.000908 false
SHOW TABLES LIKE 'extrafields' 1 0.000976 false
SHOW TABLES LIKE 'extrafields' 1 0.001122 false
SHOW TABLES LIKE 'extrafields' 1 0.001132 false
SHOW TABLES LIKE 'extrafields' 1 0.000962 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.000664 false
SHOW TABLES LIKE 'extrafields' 1 0.001120 false
SHOW TABLES LIKE 'extrafields' 1 0.000985 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.004066 false
SHOW TABLES LIKE 'extrafields' 1 0.001332 false
SHOW TABLES LIKE 'extrafields' 1 0.001070 false
SHOW TABLES LIKE 'extrafields' 1 0.001020 false
SHOW TABLES LIKE 'extrafields' 1 0.000985 false
SHOW TABLES LIKE 'extrafields' 1 0.001012 false
SHOW TABLES LIKE 'extrafields' 1 0.000992 false
SHOW TABLES LIKE 'extrafields' 1 0.000966 false
SHOW TABLES LIKE 'extrafields' 1 0.000987 false
SHOW TABLES LIKE 'extrafields' 1 0.001048 false
SHOW TABLES LIKE 'extrafields' 1 0.001020 false
SHOW TABLES LIKE 'extrafields' 1 0.001008 false
SHOW TABLES LIKE 'extrafields' 1 0.001085 false
SHOW TABLES LIKE 'extrafields' 1 0.001125 false
SHOW TABLES LIKE 'extrafields' 1 0.000970 false
SHOW TABLES LIKE 'extrafields' 1 0.001022 false
SHOW TABLES LIKE 'extrafields' 1 0.000964 false
SHOW TABLES LIKE 'extrafields' 1 0.001092 false
SHOW TABLES LIKE 'extrafields' 1 0.001116 false
SHOW TABLES LIKE 'extrafields' 1 0.000982 false
SHOW TABLES LIKE 'extrafields' 1 0.001035 false
SHOW TABLES LIKE 'extrafields' 1 0.000983 false
SHOW TABLES LIKE 'extrafields' 1 0.001627 false
SHOW TABLES LIKE 'extrafields' 1 0.001583 false
SHOW TABLES LIKE 'extrafields' 1 0.001540 false
SHOW TABLES LIKE 'extrafields' 1 0.001693 false
SHOW TABLES LIKE 'extrafields' 1 0.002020 false
SHOW TABLES LIKE 'extrafields' 1 0.001725 false
SHOW TABLES LIKE 'extrafields' 1 0.002398 false
SHOW TABLES LIKE 'extrafields' 1 0.001708 false
SHOW TABLES LIKE 'extrafields' 1 0.001636 false
SHOW TABLES LIKE 'extrafields' 1 0.002125 false
SHOW TABLES LIKE 'extrafields' 1 0.001886 false
SHOW TABLES LIKE 'extrafields' 1 0.001776 false
SHOW TABLES LIKE 'extrafields' 1 0.001580 false
SHOW TABLES LIKE 'extrafields' 1 0.001813 false
SHOW TABLES LIKE 'extrafields' 1 0.001830 false
SHOW TABLES LIKE 'extrafields' 1 0.001533 false
SHOW TABLES LIKE 'extrafields' 1 0.002132 false
SHOW TABLES LIKE 'extrafields' 1 0.001893 false
SHOW TABLES LIKE 'extrafields' 1 0.001413 false
SHOW TABLES LIKE 'extrafields' 1 0.001440 false
SHOW TABLES LIKE 'extrafields' 1 0.001381 false
SHOW TABLES LIKE 'extrafields' 1 0.001474 false
SHOW TABLES LIKE 'extrafields' 1 0.001384 false
SHOW TABLES LIKE 'extrafields' 1 0.001402 false
SHOW TABLES LIKE 'extrafields' 1 0.001710 false
SHOW TABLES LIKE 'extrafields' 1 0.001829 false
SHOW TABLES LIKE 'extrafields' 1 0.001776 false
SHOW TABLES LIKE 'extrafields' 1 0.001825 false
SHOW TABLES LIKE 'extrafields' 1 0.001836 false
SHOW TABLES LIKE 'extrafields' 1 0.001315 false
SHOW TABLES LIKE 'extrafields' 1 0.001385 false
SHOW TABLES LIKE 'extrafields' 1 0.001854 false
SHOW TABLES LIKE 'extrafields' 1 0.002477 false
SHOW TABLES LIKE 'extrafields' 1 0.001698 false
SHOW TABLES LIKE 'extrafields' 1 0.001554 false
SHOW TABLES LIKE 'extrafields' 1 0.001805 false
SHOW TABLES LIKE 'extrafields' 1 0.001568 false
SHOW TABLES LIKE 'extrafields' 1 0.001439 false
SHOW TABLES LIKE 'extrafields' 1 0.001275 false
SHOW TABLES LIKE 'extrafields' 1 0.001350 false
SHOW TABLES LIKE 'extrafields' 1 0.001592 false
SHOW TABLES LIKE 'extrafields' 1 0.001608 false
SHOW TABLES LIKE 'extrafields' 1 0.001198 false
SHOW TABLES LIKE 'extrafields' 1 0.001774 false
SHOW TABLES LIKE 'extrafields' 1 0.001570 false
SHOW TABLES LIKE 'extrafields' 1 0.001745 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.001024 false
SHOW TABLES LIKE 'extrafields' 1 0.001518 false
SHOW TABLES LIKE 'extrafields' 1 0.002492 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.001549 false
SHOW TABLES LIKE 'extrafields' 1 0.001432 false
SHOW TABLES LIKE 'extrafields' 1 0.001569 false
SHOW TABLES LIKE 'extrafields' 1 0.001381 false
SHOW TABLES LIKE 'extrafields' 1 0.002309 false
SHOW TABLES LIKE 'extrafields' 1 0.002254 false
SHOW TABLES LIKE 'extrafields' 1 0.001291 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.000809 false
SHOW TABLES LIKE 'extrafields' 1 0.001472 false
SHOW TABLES LIKE 'extrafields' 1 0.001222 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.000813 false
SHOW TABLES LIKE 'extrafields' 1 0.001521 false
SHOW TABLES LIKE 'extrafields' 1 0.001437 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.001077 false
SHOW TABLES LIKE 'extrafields' 1 0.001514 false
SHOW TABLES LIKE 'extrafields' 1 0.001644 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.000677 false
SHOW TABLES LIKE 'extrafields' 1 0.001809 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.001037 false
SHOW TABLES LIKE 'extrafields' 1 0.001461 false
SHOW TABLES LIKE 'extrafields' 1 0.001735 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.000776 false
SHOW TABLES LIKE 'extrafields' 1 0.001717 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.001126 false
SHOW TABLES LIKE 'extrafields' 1 0.001598 false
SHOW TABLES LIKE 'extrafields' 1 0.001503 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.000875 false
SHOW TABLES LIKE 'extrafields' 1 0.001675 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.001149 false
SHOW TABLES LIKE 'extrafields' 1 0.001887 false
SHOW TABLES LIKE 'extrafields' 1 0.001989 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.001005 false
SHOW TABLES LIKE 'extrafields' 1 0.001537 false
SHOW TABLES LIKE 'extrafields' 1 0.001495 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.000833 false
SHOW TABLES LIKE 'extrafields' 1 0.001368 false
SHOW TABLES LIKE 'extrafields' 1 0.001233 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.000974 false
SHOW TABLES LIKE 'extrafields' 1 0.001551 false
SHOW TABLES LIKE 'extrafields' 1 0.001230 false
SHOW TABLES LIKE 'extrafields' 1 0.001713 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.000969 false
SHOW TABLES LIKE 'extrafields' 1 0.001674 false
SHOW TABLES LIKE 'extrafields' 1 0.001563 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.000807 false
SHOW TABLES LIKE 'extrafields' 1 0.001597 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.000903 false
SHOW TABLES LIKE 'extrafields' 1 0.001656 false
SHOW TABLES LIKE 'extrafields' 1 0.001554 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.001216 false
SHOW TABLES LIKE 'extrafields' 1 0.001615 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.000519 false
SHOW TABLES LIKE 'extrafields' 1 0.001508 false
SHOW TABLES LIKE 'extrafields' 1 0.001521 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.000946 false
SHOW TABLES LIKE 'extrafields' 1 0.001498 false
SHOW TABLES LIKE 'extrafields' 1 0.001509 false
SHOW TABLES LIKE 'extrafields' 1 0.001476 false
SHOW TABLES LIKE 'extrafields' 1 0.001548 false
SHOW TABLES LIKE 'extrafields' 1 0.001456 false
SELECT admin_menu_items.* FROM admin_menu_items ORDER BY sort_order 7 0.000382 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 = 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.000522 false
SHOW TABLES LIKE 'extrafields' 1 0.001441 false
SHOW TABLES LIKE 'extrafields' 1 0.002096 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.000731 false
SHOW TABLES LIKE 'extrafields' 1 0.001545 false
SHOW TABLES LIKE 'extrafields' 1 0.001911 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.000915 false
SHOW TABLES LIKE 'extrafields' 1 0.001665 false
SHOW TABLES LIKE 'extrafields' 1 0.001114 false
SHOW TABLES LIKE 'extrafields' 1 0.001052 false
SHOW TABLES LIKE 'extrafields' 1 0.001222 false
SHOW TABLES LIKE 'extrafields' 1 0.001067 false