{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "678.25"
},
"table": {
"table_name": "cscart_categories",
"access_type": "range",
"possible_keys": [
"parent"
],
"key": "parent",
"used_key_parts": [
"parent_id"
],
"key_length": "3",
"rows_examined_per_scan": 1690,
"rows_produced_per_join": 1690,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "340.25",
"eval_cost": "338.00",
"prefix_cost": "678.25",
"data_read_per_join": "9M"
},
"used_columns": [
"category_id",
"parent_id"
],
"attached_condition": "(`webmarco`.`cscart_categories`.`parent_id` in (9401,2269,2534,2399,2376,1696,2537,2377,2396,2390,2272,2268,2530,2392,2391,2375,356,2395,2394,2398,2393,2532,2531,2400,2271,2401,2266,2273,2535,2538,2536,2402,2267,10667,10669,2270,2533,9624,2403,10249,328,2406,9955,395,936,2612,933,1514,1407,2434,342,9963,2480,2172,2592,2548,9841,1501,2578,1516,345,1480,2405,2479,1415,267,2435,1522,1909,1411,1908,9695,2470,2616,1499,716,9845,946,2466,991,1519,9944,2374,1441,2179,444,2631,9693,953,955,1937,2387,1511,1691,1697,2455,2618,9927,9930,2174,994,10250,1698,1523,2617,2175,947,1938,398,9846,393,934,1692,2483,1442,2481,346,1481,2173,9928,1517,1910,9956,2407,1412,2370,992,956,954,1408,1502,445,2539,1515,2471,1512,1584,1416,9694,2456,932,343,2467,1018,2436,9945,2388,944,1500,1315,2604,1513,9847,397,1417,10409,1524,1911,347,399,2265,2540,2371,396,9946,2621,1496,1939,446,941,1306,952,2568,2437,1316,9957,344,1693,1503,1438,935,2482,2623,1413,2338,1418,1497,394,1861,2372,9848,2472,1694,2587,447,2404,929,1912,1695,945,10410,1521,1525,9867,1504,348,1414,2581,2389,9855,443,10411,1913,1427,8944,2528,2559,2579,9920,349,1419,1409,2542,2566,2580,1420,2176,2554,352,1936,9856,1410,10247,2582,1508,9961,1907,990,2478,1505,2180,9294,10413,2567,9857,1520,10248,2583,2541,2584,1509,9858,2597,9849,2549,2599,2585,9864,9859,1510,1479,2602,930,1303,2586,1518,1498,9860,1309,2386,1690,1506,2473,9861,2601,2469,341,9929,1714,2553,2596,9862,2454,9863,1715,2613,1914,9958,9865,327,9866,715,2397,2171,9918,2468,2529,2178,9919,2373,2552,2433,9290,2465,2577,2591,2611,2615,9692,9830,2603,2595,2593,2610,2634,2594,9840,9264,9844,9842,9843,9926,9936,10425,10631,10426,10632,10633,2638,9623,9921,9922,9923,9924,9940,9941,9942,9943))"
}
}
}
category_id | parent_id |
---|---|
328 | 327 |
1018 | 327 |
1438 | 327 |
1695 | 327 |
2528 | 327 |
2566 | 327 |
2567 | 327 |
2597 | 327 |
342 | 341 |
343 | 341 |
397 | 341 |
345 | 344 |
346 | 344 |
348 | 344 |
349 | 344 |
352 | 344 |
2595 | 344 |
9264 | 344 |
347 | 346 |
2470 | 346 |
2471 | 346 |
2472 | 346 |
2638 | 346 |
393 | 356 |
396 | 356 |
929 | 356 |
1506 | 356 |
1714 | 356 |
1715 | 356 |
1914 | 356 |
2397 | 356 |
2468 | 356 |
2529 | 356 |
2552 | 356 |
9290 | 356 |
1516 | 393 |
1517 | 393 |
395 | 394 |
398 | 394 |
399 | 394 |
1861 | 394 |
2389 | 394 |
2554 | 394 |
9294 | 394 |
9623 | 394 |
9921 | 394 |
9922 | 394 |
9923 | 394 |
9924 | 394 |
9940 | 394 |
9941 | 394 |
9942 | 394 |
9943 | 394 |
267 | 443 |
444 | 443 |
445 | 443 |
446 | 443 |
447 | 443 |
1409 | 443 |
1410 | 443 |
1505 | 443 |
1509 | 443 |
1510 | 443 |
1518 | 443 |
1690 | 443 |
2454 | 443 |
2610 | 443 |
2634 | 443 |
9842 | 443 |
9843 | 443 |
10425 | 443 |
10426 | 443 |
2631 | 444 |
1407 | 445 |
1408 | 445 |
1441 | 447 |
1442 | 447 |
10409 | 447 |
10410 | 447 |
10411 | 447 |
10413 | 447 |
716 | 715 |
1315 | 715 |
1415 | 929 |
1416 | 929 |
1417 | 929 |
1418 | 929 |
1419 | 929 |
1420 | 929 |
2541 | 929 |
932 | 930 |
935 | 930 |
945 | 930 |
8944 | 930 |
9961 | 930 |
933 | 932 |
934 | 932 |
941 | 932 |
953 | 933 |
954 | 933 |
955 | 934 |
956 | 934 |
936 | 935 |
944 | 935 |
952 | 935 |
946 | 945 |
947 | 945 |
1316 | 945 |
991 | 990 |
992 | 990 |
994 | 990 |
2265 | 990 |
2603 | 991 |
9401 | 1309 |
1514 | 1409 |
1515 | 1409 |
1411 | 1410 |
1412 | 1410 |
1413 | 1410 |
1414 | 1410 |
1427 | 1410 |
1508 | 1410 |
1520 | 1410 |
1480 | 1479 |
1481 | 1479 |
1496 | 1479 |
1497 | 1479 |
1522 | 1497 |
1523 | 1497 |
1524 | 1497 |
1525 | 1497 |
1479 | 1498 |
1499 | 1498 |
1500 | 1498 |
2386 | 1498 |
2469 | 1498 |
2553 | 1498 |
1501 | 1500 |
1502 | 1500 |
1503 | 1500 |
1504 | 1500 |
1511 | 1510 |
1512 | 1510 |
1513 | 1510 |
1521 | 1510 |
2542 | 1510 |
1519 | 1518 |
1303 | 1584 |
1309 | 1584 |
2473 | 1584 |
2596 | 1584 |
2613 | 1584 |
9958 | 1584 |
1691 | 1690 |
1692 | 1690 |
1693 | 1690 |
1694 | 1690 |
1696 | 1695 |
1697 | 1695 |
1698 | 1695 |
2568 | 1695 |
2599 | 1695 |
2602 | 1695 |
1908 | 1907 |
1909 | 1907 |
1910 | 1907 |
1911 | 1907 |
1912 | 1907 |
1913 | 1907 |
2180 | 1907 |
9849 | 1907 |
9864 | 1907 |
1937 | 1936 |
1938 | 1936 |
1939 | 1936 |
2579 | 1936 |
2580 | 1936 |
2583 | 1936 |
2584 | 1936 |
2585 | 1936 |
2586 | 1936 |
2601 | 1936 |
9929 | 1936 |
2172 | 2171 |
2173 | 2171 |
2174 | 2173 |
2175 | 2173 |
2621 | 2173 |
2179 | 2178 |
2370 | 2178 |
2371 | 2178 |
2372 | 2178 |
2559 | 2178 |
9748 | 2178 |
9749 | 2178 |
9750 | 2178 |
2266 | 2265 |
2267 | 2265 |
2268 | 2265 |
2269 | 2265 |
2270 | 2265 |
2271 | 2265 |
2272 | 2265 |
2273 | 2265 |
2374 | 2373 |
2388 | 2373 |
2375 | 2374 |
2376 | 2374 |
2377 | 2374 |
2548 | 2374 |
2387 | 2386 |
2390 | 2388 |
2391 | 2388 |
2392 | 2388 |
2393 | 2388 |
2394 | 2388 |
2395 | 2388 |
2396 | 2388 |
2479 | 2388 |
2483 | 2388 |
9624 | 2393 |
2398 | 2397 |
2399 | 2397 |
2400 | 2397 |
2401 | 2397 |
2402 | 2397 |
2403 | 2397 |
2405 | 2404 |
2539 | 2404 |
2540 | 2404 |
2406 | 2405 |
2407 | 2405 |
2176 | 2433 |
2434 | 2433 |
2478 | 2433 |
2549 | 2433 |
2435 | 2434 |
2436 | 2434 |
2437 | 2434 |
2455 | 2454 |
2456 | 2454 |
2466 | 2465 |
2467 | 2465 |
2480 | 2478 |
2481 | 2478 |
2482 | 2478 |
2587 | 2478 |
2530 | 2529 |
2531 | 2529 |
2532 | 2529 |
2533 | 2529 |
2534 | 2529 |
2535 | 2529 |
2536 | 2529 |
2537 | 2529 |
2538 | 2529 |
2578 | 2577 |
2604 | 2577 |
2623 | 2577 |
9867 | 2577 |
9920 | 2577 |
10247 | 2577 |
10248 | 2577 |
2338 | 2580 |
2581 | 2580 |
2582 | 2580 |
2592 | 2591 |
2593 | 2591 |
2594 | 2591 |
9955 | 2604 |
9956 | 2604 |
9957 | 2604 |
1306 | 2611 |
2612 | 2611 |
2616 | 2615 |
2617 | 2615 |
2618 | 2616 |
9693 | 9692 |
9694 | 9692 |
9695 | 9694 |
9841 | 9840 |
9845 | 9844 |
9846 | 9844 |
9847 | 9844 |
9848 | 9844 |
9855 | 9844 |
9856 | 9844 |
9857 | 9844 |
9858 | 9844 |
9859 | 9844 |
9860 | 9844 |
9861 | 9844 |
9862 | 9844 |
9863 | 9844 |
9865 | 9844 |
9866 | 9844 |
9918 | 9844 |
9919 | 9844 |
9927 | 9926 |
9928 | 9926 |
9930 | 9927 |
9963 | 9928 |
9944 | 9941 |
9945 | 9941 |
9946 | 9941 |
10249 | 10248 |
10250 | 10248 |
10669 | 10667 |