{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "42.80"
},
"table": {
"table_name": "cscart_storefronts_companies",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"idx_storefront_id"
],
"key": "idx_storefront_id",
"used_key_parts": [
"storefront_id"
],
"key_length": "4",
"ref": [
"const"
],
"rows_examined_per_scan": 424,
"rows_produced_per_join": 424,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "0.40",
"eval_cost": "42.40",
"prefix_cost": "42.80",
"data_read_per_join": "6K"
},
"used_columns": [
"storefront_id",
"company_id"
]
}
}
}
company_id |
---|
33 |
44 |
72 |
73 |
74 |
75 |
76 |
77 |
78 |
79 |
80 |
81 |
82 |
83 |
84 |
85 |
86 |
87 |
88 |
89 |
90 |
91 |
92 |
93 |
94 |
95 |
96 |
97 |
98 |
99 |
100 |
101 |
102 |
103 |
104 |
105 |
106 |
107 |
108 |
109 |
110 |
111 |
112 |
113 |
114 |
115 |
116 |
117 |
118 |
119 |
120 |
121 |
122 |
127 |
128 |
129 |
130 |
131 |
132 |
133 |
134 |
135 |
136 |
137 |
138 |
139 |
140 |
141 |
142 |
143 |
144 |
145 |
146 |
147 |
148 |
149 |
150 |
151 |
152 |
153 |
154 |
155 |
156 |
157 |
158 |
159 |
160 |
161 |
162 |
163 |
164 |
165 |
166 |
167 |
168 |
169 |
170 |
171 |
172 |
173 |
174 |
175 |
176 |
177 |
178 |
180 |
183 |
185 |
186 |
187 |
188 |
191 |
192 |
193 |
195 |
196 |
197 |
214 |
215 |
217 |
249 |
267 |
273 |
287 |
288 |
300 |
301 |
302 |
310 |
314 |
315 |
321 |
326 |
332 |
333 |
334 |
335 |
338 |
342 |
343 |
344 |
347 |
348 |
352 |
358 |
359 |
363 |
366 |
370 |
381 |
382 |
384 |
388 |
389 |
390 |
391 |
392 |
395 |
398 |
400 |
402 |
403 |
405 |
406 |
407 |
409 |
410 |
411 |
412 |
415 |
419 |
420 |
421 |
422 |
423 |
424 |
425 |
426 |
427 |
428 |
432 |
434 |
436 |
437 |
438 |
439 |
440 |
441 |
443 |
446 |
447 |
448 |
450 |
451 |
453 |
455 |
456 |
457 |
459 |
460 |
461 |
462 |
465 |
470 |
471 |
472 |
473 |
474 |
475 |
476 |
479 |
480 |
481 |
482 |
483 |
484 |
485 |
486 |
489 |
491 |
492 |
493 |
494 |
495 |
496 |
497 |
498 |
499 |
501 |
502 |
503 |
504 |
505 |
506 |
507 |
508 |
509 |
510 |
511 |
512 |
513 |
514 |
515 |
516 |
517 |
518 |
519 |
520 |
521 |
522 |
523 |
524 |
525 |
526 |
527 |
528 |
529 |
530 |
531 |
532 |
533 |
534 |
535 |
536 |
537 |
538 |
539 |
540 |
542 |
545 |
546 |
547 |
548 |
549 |
550 |
551 |
552 |
554 |
555 |
556 |
558 |
559 |
561 |
562 |
563 |
564 |
566 |
567 |
568 |
569 |
570 |
571 |
572 |
573 |
574 |
575 |
576 |
577 |
580 |
581 |
582 |
583 |
584 |
585 |
586 |
588 |
589 |
590 |
591 |
592 |
593 |
594 |
595 |
597 |
598 |
599 |
600 |
601 |
602 |
603 |
604 |
606 |
610 |
611 |
613 |
615 |
616 |
617 |
619 |
620 |
622 |
625 |
626 |
633 |
635 |
637 |
638 |
639 |
641 |
642 |
643 |
644 |
646 |
647 |
648 |
649 |
650 |
651 |
652 |
653 |
654 |
655 |
657 |
659 |
660 |
661 |
662 |
664 |
667 |
668 |
670 |
671 |
672 |
673 |
674 |
675 |
677 |
678 |
682 |
683 |
684 |
686 |
687 |
688 |
689 |
690 |
691 |
692 |
693 |
694 |
695 |
696 |
697 |
699 |
701 |
702 |
703 |
704 |
707 |
708 |
709 |
713 |
714 |
715 |
716 |
717 |
718 |
719 |
720 |
721 |
722 |
723 |
724 |
725 |
726 |
727 |
728 |
729 |
730 |
731 |
732 |
733 |
735 |
736 |
737 |
738 |
739 |
740 |
741 |
742 |
743 |
744 |
745 |
746 |