{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "53.72"
},
"table": {
"table_name": "cscart_categories",
"access_type": "ALL",
"possible_keys": [
"parent"
],
"rows_examined_per_scan": 233,
"rows_produced_per_join": 233,
"filtered": "100.00",
"cost_info": {
"read_cost": "7.12",
"eval_cost": "46.60",
"prefix_cost": "53.72",
"data_read_per_join": "607K"
},
"used_columns": [
"category_id",
"parent_id"
],
"attached_condition": "(`ea201_diorama`.`cscart_categories`.`parent_id` in (701,706,634,402,170,217,179,195,307,494,635,210,341,190,345,349,353,538,269,406,331,319,377,623,327,554,357,363,416,192,632,697,321,177,626,677,412,267,167,171,180,219,196,266,646,495,343,188,348,346,354,411,311,211,206,407,332,320,624,633,328,555,360,356,361,364,415,193,376,322,627,678,667,400,172,181,197,549,324,221,660,496,344,168,165,393,355,540,312,268,212,333,556,362,358,365,414,350,347,323,628,399,169,182,403,661,543,342,382,541,622,334,213,326,329,351,359,366,413,325,409,396,629,639,662,641,243,689,390,647,676,223,542,199,405,335,352,330,214,669,398,185,397,209,194,178,242,218,687,631,204,336,690,191,698,200,215,670,271,640,381,224,203,338,216,201,386,552,226,656,229,245,337,316,208,672,379,264,642,202,685,679,225,340,700,668,711,643,233,696,228,688,395,644,232,391,339,537,539,645,231,383,310,220,657,256,707,234,404,230,658,189,671,712,708,183,686,544))"
}
}
}
category_id | parent_id |
---|---|
679 | 203 |
701 | 179 |
402 | 194 |
179 | 177 |
192 | 191 |
195 | 194 |
210 | 209 |
207 | 204 |
170 | 167 |
217 | 179 |
327 | 326 |
319 | 316 |
321 | 323 |
331 | 319 |
341 | 218 |
345 | 223 |
349 | 224 |
353 | 245 |
357 | 353 |
363 | 355 |
377 | 208 |
406 | 405 |
416 | 412 |
494 | 185 |
307 | 203 |
538 | 202 |
269 | 264 |
626 | 398 |
554 | 214 |
623 | 402 |
190 | 168 |
632 | 190 |
635 | 634 |
697 | 668 |
412 | 177 |
677 | 185 |
267 | 177 |
266 | 264 |
180 | 179 |
167 | 165 |
193 | 191 |
196 | 194 |
206 | 204 |
211 | 209 |
219 | 177 |
171 | 167 |
328 | 326 |
322 | 323 |
320 | 316 |
332 | 319 |
343 | 218 |
346 | 223 |
348 | 224 |
354 | 245 |
356 | 353 |
360 | 354 |
361 | 354 |
364 | 355 |
376 | 208 |
407 | 405 |
415 | 412 |
495 | 185 |
311 | 203 |
411 | 202 |
555 | 214 |
627 | 398 |
624 | 402 |
188 | 168 |
633 | 190 |
646 | 634 |
678 | 185 |
667 | 185 |
400 | 354 |
172 | 167 |
181 | 179 |
168 | 165 |
197 | 194 |
212 | 209 |
221 | 177 |
268 | 204 |
323 | 316 |
324 | 323 |
333 | 319 |
344 | 218 |
347 | 177 |
350 | 224 |
355 | 245 |
358 | 353 |
362 | 354 |
365 | 355 |
393 | 208 |
414 | 412 |
496 | 185 |
312 | 203 |
540 | 202 |
549 | 264 |
556 | 214 |
628 | 398 |
660 | 634 |
399 | 353 |
403 | 264 |
169 | 167 |
182 | 179 |
213 | 209 |
329 | 326 |
325 | 323 |
326 | 316 |
334 | 319 |
342 | 218 |
351 | 224 |
359 | 353 |
366 | 355 |
382 | 177 |
396 | 204 |
409 | 208 |
413 | 412 |
541 | 202 |
543 | 185 |
622 | 203 |
629 | 398 |
661 | 634 |
639 | 634 |
662 | 634 |
641 | 634 |
390 | 264 |
199 | 194 |
214 | 209 |
223 | 224 |
243 | 167 |
330 | 326 |
335 | 319 |
352 | 224 |
405 | 204 |
542 | 202 |
647 | 634 |
669 | 398 |
676 | 208 |
689 | 316 |
397 | 194 |
218 | 177 |
191 | 165 |
200 | 194 |
215 | 209 |
242 | 167 |
336 | 319 |
631 | 190 |
670 | 398 |
687 | 264 |
690 | 316 |
698 | 208 |
201 | 194 |
216 | 209 |
224 | 177 |
271 | 167 |
338 | 319 |
381 | 168 |
630 | 190 |
640 | 634 |
229 | 168 |
245 | 177 |
316 | 203 |
337 | 319 |
379 | 209 |
386 | 194 |
552 | 167 |
656 | 634 |
672 | 190 |
225 | 177 |
317 | 203 |
340 | 319 |
408 | 194 |
642 | 634 |
685 | 190 |
700 | 209 |
228 | 177 |
233 | 168 |
318 | 203 |
643 | 634 |
688 | 190 |
198 | 202 |
232 | 168 |
339 | 319 |
395 | 203 |
391 | 177 |
644 | 634 |
537 | 168 |
231 | 168 |
383 | 177 |
539 | 203 |
645 | 634 |
310 | 203 |
220 | 177 |
256 | 168 |
657 | 634 |
234 | 168 |
404 | 177 |
707 | 203 |
230 | 168 |
189 | 168 |
658 | 634 |
671 | 168 |