Skip to content

Instantly share code, notes, and snippets.

@nicksherron

nicksherron/198.dbout

Created January 19, 2022 03:15
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save nicksherron/552080c497247f60f505daaf94423099 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save nicksherron/552080c497247f60f505daaf94423099 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
198.dbout
mysql: [Warning] Using a password on the command line interface can be insecure.
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| EXPLAIN |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| -> Nested loop inner join (actual time=191.008..307.423 rows=519 loops=1)
-> Nested loop semijoin (actual time=190.912..258.458 rows=519 loops=1)
-> Nested loop inner join (actual time=190.855..230.314 rows=519 loops=1)
-> Table scan on c (cost=2.73 rows=2) (actual time=0.009..2.550 rows=519 loops=1)
-> Materialize CTE c (actual time=190.787..198.605 rows=519 loops=1)
-> Group aggregate: group_concat(product_variants.product_id separator ',') (actual time=179.879..187.681 rows=519 loops=1)
-> Sort: product_variants.variant_id (actual time=179.840..182.222 rows=522 loops=1)
-> Stream results (actual time=140.894..176.828 rows=522 loops=1)
-> Nested loop inner join (actual time=140.877..171.150 rows=522 loops=1)
-> Table scan on <subquery10> (cost=0.78 rows=4) (actual time=0.007..2.343 rows=519 loops=1)
-> Materialize with deduplication (actual time=140.827..148.511 rows=519 loops=1)
-> Table scan on b (cost=2.95 rows=4) (actual time=0.008..5.008 rows=1044 loops=1)
-> Materialize union CTE b (actual time=120.747..135.509 rows=1044 loops=1)
-> Nested loop inner join (actual time=54.688..66.513 rows=522 loops=1)
-> Table scan on <subquery12> (cost=8.26 rows=102) (actual time=0.008..2.867 rows=619 loops=1)
-> Materialize with deduplication (actual time=33.701..42.513 rows=619 loops=1)
-> Table scan on a (cost=13.97 rows=102) (actual time=0.008..2.728 rows=622 loops=1)
-> Materialize union CTE a if needed (query plan printed elsewhere) (actual time=22.559..30.772 rows=622 loops=1)
-> Index lookup on product_variants using fk_product_variants_product (product_id=`<subquery12>`.id) (cost=25.86 rows=2) (actual time=0.012..0.016 rows=1 loops=619)
-> Nested loop inner join (actual time=12.414..48.536 rows=522 loops=1)
-> Table scan on <subquery19> (cost=19.99 rows=102) (actual time=0.008..3.446 rows=619 loops=1)
-> Materialize with deduplication (actual time=12.352..22.425 rows=619 loops=1)
-> Table scan on a (cost=13.97 rows=102) (actual time=0.009..3.100 rows=622 loops=1)
-> Materialize union CTE a if needed (query plan printed elsewhere) (actual time=0.029..9.004 rows=622 loops=1)
-> Index lookup on product_variants using PRIMARY (variant_id=`<subquery19>`.id) (cost=49.14 rows=1) (actual time=0.012..0.018 rows=1 loops=619)
-> Index lookup on product_variants using PRIMARY (variant_id=`<subquery10>`.variant_id) (cost=2.03 rows=1) (actual time=0.013..0.019 rows=1 loops=519)
-> Single-row index lookup on product using PRIMARY (id=c.variant_id) (cost=1.05 rows=1) (actual time=0.028..0.033 rows=1 loops=519)
-> Index lookup on a using <auto_key0> (id=c.variant_id) (actual time=0.011..0.011 rows=1 loops=519)
-> Materialize union CTE a if needed (actual time=0.033..0.033 rows=1 loops=519)
-> Nested loop inner join (cost=1697.95 rows=247) (never executed)
-> Table scan on <subquery5> (cost=8.10 rows=100) (never executed)
-> Materialize with deduplication (cost=1648.16 rows=100) (never executed)
-> Table scan on og (cost=13.75 rows=100) (never executed)
-> Materialize CTE og if needed (cost=1648.16 rows=100) (never executed)
-> Limit: 100 row(s) (cost=1648.16 rows=100) (never executed)
-> Filter: (product.`group` = 'product') (cost=1648.16 rows=16429) (never executed)
-> Index lookup on product using idx_product_group (group='product') (cost=1648.16 rows=16429) (never executed)
-> Index lookup on product_variants using fk_product_variants_product (product_id=`<subquery5>`.id) (cost=25.35 rows=2) (never executed)
-> Table scan on og (cost=13.75 rows=100) (never executed)
-> Materialize CTE og if needed (query plan printed elsewhere) (cost=1648.16 rows=100) (never executed)
-> Materialize table function (actual time=0.053..0.068 rows=1 loops=519)
|
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment