Query Metrics
32
Database Queries
19
Different statements
45.94 ms
Query time
0
Invalid entities
30
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.57 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.position AS position_6, t0.depth AS depth_7, t0.sort_path AS sort_path_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.id = ?
Parameters:
[
"6"
]
|
||||||||||||||||||||||||||||||||||
| 2 | 2.15 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.visible AS visible_4, t0.position AS position_5, t0.depth AS depth_6, t0.sort_path AS sort_path_7, t0.parent_id AS parent_id_8 FROM attribute t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"page"
]
|
||||||||||||||||||||||||||||||||||
| 3 | 0.63 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
null
]
|
||||||||||||||||||||||||||||||||||
| 4 | 3.80 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT p0_.id AS id_0, p0_.remote_id AS remote_id_1, p0_.name AS name_2, p0_.title AS title_3, p0_.specification AS specification_4, p0_.description AS description_5, p0_.visible AS visible_6 FROM product p0_ INNER JOIN remote_category r1_ ON p0_.remote_category_id = r1_.id INNER JOIN product_variant p2_ ON p0_.id = p2_.product_id WHERE r1_.category_id = ? AND p0_.visible = true AND p2_.visible = true GROUP BY p0_.id) dctrn_table
Parameters:
[
6
]
|
||||||||||||||||||||||||||||||||||
| 5 | 1.82 ms |
SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.remote_id AS remote_id_1, p0_.name AS name_2, p0_.title AS title_3, p0_.specification AS specification_4, p0_.description AS description_5, p0_.visible AS visible_6 FROM product p0_ INNER JOIN remote_category r1_ ON p0_.remote_category_id = r1_.id INNER JOIN product_variant p2_ ON p0_.id = p2_.product_id WHERE r1_.category_id = ? AND p0_.visible = true AND p2_.visible = true GROUP BY p0_.id) dctrn_result LIMIT 9 OFFSET 27
Parameters:
[
6
]
|
||||||||||||||||||||||||||||||||||
| 6 | 1.94 ms |
SELECT p0_.id AS id_0, p0_.remote_id AS remote_id_1, p0_.name AS name_2, p0_.title AS title_3, p0_.specification AS specification_4, p0_.description AS description_5, p0_.visible AS visible_6, p0_.source_id AS source_id_7, p0_.manufacturer_id AS manufacturer_id_8, p0_.remote_category_id AS remote_category_id_9 FROM product p0_ INNER JOIN remote_category r1_ ON p0_.remote_category_id = r1_.id INNER JOIN product_variant p2_ ON p0_.id = p2_.product_id WHERE r1_.category_id = ? AND p0_.visible = true AND p2_.visible = true AND p0_.id IN (?, ?, ?, ?, ?, ?) GROUP BY p0_.id
Parameters:
[ 6 313 210 316 319 110 397 ]
|
||||||||||||||||||||||||||||||||||
| 7 | 0.50 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
110
]
|
||||||||||||||||||||||||||||||||||
| 8 | 5.18 ms |
SELECT i0_.id AS id_0, i0_.url AS url_1, i0_.path AS path_2, i0_.filename AS filename_3, i0_.hash AS hash_4 FROM image i0_ INNER JOIN product_variant_image p1_ ON i0_.id = p1_.image_id INNER JOIN product_variant p2_ ON p1_.variant_id = p2_.id INNER JOIN product p3_ ON p2_.product_id = p3_.id WHERE p3_.id = ? AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY i0_.id, i0_.url, i0_.path, i0_.filename, i0_.hash ORDER BY i0_.path ASC LIMIT 1
Parameters:
[ 110 5652 5653 5654 5655 5656 5657 5658 5659 5660 5661 5662 5663 5664 5665 5666 5667 5668 5669 5670 5671 5672 5673 5674 5675 5676 5677 5678 5679 5680 5681 5682 5683 5684 5685 5686 5687 5688 5689 5690 5691 5692 5693 5694 5695 5696 5697 5698 5699 5700 5701 5702 5703 5704 5705 5706 5707 5708 5709 5710 5711 5712 5713 5714 5715 5716 5717 5718 5719 5720 5721 5722 5723 5724 5725 5726 9824 9825 9826 9827 9828 9829 9830 9831 9832 9833 9834 9835 11687 11688 11689 11690 11691 11692 14741 14742 14743 14744 14745 14746 14747 14748 14824 14825 14826 14827 14828 14829 14830 14831 14968 14969 14970 14971 14972 14973 14974 14975 ]
|
||||||||||||||||||||||||||||||||||
| 9 | 0.50 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
110
]
|
||||||||||||||||||||||||||||||||||
| 10 | 1.89 ms |
SELECT MIN(p0_.price) AS sclr_0, MAX(p0_.price) AS sclr_1 FROM product_variant p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p1_.id = ? AND p1_.visible = true AND p0_.visible = true AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 110 5652 5653 5654 5655 5656 5657 5658 5659 5660 5661 5662 5663 5664 5665 5666 5667 5668 5669 5670 5671 5672 5673 5674 5675 5676 5677 5678 5679 5680 5681 5682 5683 5684 5685 5686 5687 5688 5689 5690 5691 5692 5693 5694 5695 5696 5697 5698 5699 5700 5701 5702 5703 5704 5705 5706 5707 5708 5709 5710 5711 5712 5713 5714 5715 5716 5717 5718 5719 5720 5721 5722 5723 5724 5725 5726 9824 9825 9826 9827 9828 9829 9830 9831 9832 9833 9834 9835 11687 11688 11689 11690 11691 11692 14741 14742 14743 14744 14745 14746 14747 14748 14824 14825 14826 14827 14828 14829 14830 14831 14968 14969 14970 14971 14972 14973 14974 14975 ]
|
||||||||||||||||||||||||||||||||||
| 11 | 0.49 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
210
]
|
||||||||||||||||||||||||||||||||||
| 12 | 1.84 ms |
SELECT i0_.id AS id_0, i0_.url AS url_1, i0_.path AS path_2, i0_.filename AS filename_3, i0_.hash AS hash_4 FROM image i0_ INNER JOIN product_variant_image p1_ ON i0_.id = p1_.image_id INNER JOIN product_variant p2_ ON p1_.variant_id = p2_.id INNER JOIN product p3_ ON p2_.product_id = p3_.id WHERE p3_.id = ? AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY i0_.id, i0_.url, i0_.path, i0_.filename, i0_.hash ORDER BY i0_.path ASC LIMIT 1
Parameters:
[ 210 8003 8004 8005 8006 8007 8008 8009 8010 8011 8012 8013 8014 8015 8016 8017 8018 8019 8020 ]
|
||||||||||||||||||||||||||||||||||
| 13 | 0.58 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
210
]
|
||||||||||||||||||||||||||||||||||
| 14 | 0.96 ms |
SELECT MIN(p0_.price) AS sclr_0, MAX(p0_.price) AS sclr_1 FROM product_variant p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p1_.id = ? AND p1_.visible = true AND p0_.visible = true AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 210 8003 8004 8005 8006 8007 8008 8009 8010 8011 8012 8013 8014 8015 8016 8017 8018 8019 8020 ]
|
||||||||||||||||||||||||||||||||||
| 15 | 0.55 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
313
]
|
||||||||||||||||||||||||||||||||||
| 16 | 1.81 ms |
SELECT i0_.id AS id_0, i0_.url AS url_1, i0_.path AS path_2, i0_.filename AS filename_3, i0_.hash AS hash_4 FROM image i0_ INNER JOIN product_variant_image p1_ ON i0_.id = p1_.image_id INNER JOIN product_variant p2_ ON p1_.variant_id = p2_.id INNER JOIN product p3_ ON p2_.product_id = p3_.id WHERE p3_.id = ? AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY i0_.id, i0_.url, i0_.path, i0_.filename, i0_.hash ORDER BY i0_.path ASC LIMIT 1
Parameters:
[ 313 12208 12209 12210 12211 12212 12213 12214 12215 12222 12223 12224 12225 12226 12227 12228 12229 12312 12313 12314 12315 12316 12317 12318 12319 12326 12327 12328 12329 12330 12331 12332 12333 ]
|
||||||||||||||||||||||||||||||||||
| 17 | 0.52 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
313
]
|
||||||||||||||||||||||||||||||||||
| 18 | 0.96 ms |
SELECT MIN(p0_.price) AS sclr_0, MAX(p0_.price) AS sclr_1 FROM product_variant p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p1_.id = ? AND p1_.visible = true AND p0_.visible = true AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 313 12208 12209 12210 12211 12212 12213 12214 12215 12222 12223 12224 12225 12226 12227 12228 12229 12312 12313 12314 12315 12316 12317 12318 12319 12326 12327 12328 12329 12330 12331 12332 12333 ]
|
||||||||||||||||||||||||||||||||||
| 19 | 0.43 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
316
]
|
||||||||||||||||||||||||||||||||||
| 20 | 1.60 ms |
SELECT i0_.id AS id_0, i0_.url AS url_1, i0_.path AS path_2, i0_.filename AS filename_3, i0_.hash AS hash_4 FROM image i0_ INNER JOIN product_variant_image p1_ ON i0_.id = p1_.image_id INNER JOIN product_variant p2_ ON p1_.variant_id = p2_.id INNER JOIN product p3_ ON p2_.product_id = p3_.id WHERE p3_.id = ? AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY i0_.id, i0_.url, i0_.path, i0_.filename, i0_.hash ORDER BY i0_.path ASC LIMIT 1
Parameters:
[ 316 12236 12237 12238 12239 12240 12241 12242 12243 12254 12255 12256 12257 12258 12259 12260 12261 ]
|
||||||||||||||||||||||||||||||||||
| 21 | 0.61 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
316
]
|
||||||||||||||||||||||||||||||||||
| 22 | 0.98 ms |
SELECT MIN(p0_.price) AS sclr_0, MAX(p0_.price) AS sclr_1 FROM product_variant p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p1_.id = ? AND p1_.visible = true AND p0_.visible = true AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 316 12236 12237 12238 12239 12240 12241 12242 12243 12254 12255 12256 12257 12258 12259 12260 12261 ]
|
||||||||||||||||||||||||||||||||||
| 23 | 0.58 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
319
]
|
||||||||||||||||||||||||||||||||||
| 24 | 4.42 ms |
SELECT i0_.id AS id_0, i0_.url AS url_1, i0_.path AS path_2, i0_.filename AS filename_3, i0_.hash AS hash_4 FROM image i0_ INNER JOIN product_variant_image p1_ ON i0_.id = p1_.image_id INNER JOIN product_variant p2_ ON p1_.variant_id = p2_.id INNER JOIN product p3_ ON p2_.product_id = p3_.id WHERE p3_.id = ? AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY i0_.id, i0_.url, i0_.path, i0_.filename, i0_.hash ORDER BY i0_.path ASC LIMIT 1
Parameters:
[ 319 12356 12357 12358 12359 12360 12361 12386 12387 12388 12389 12390 12391 12412 12413 12414 12415 12416 12417 12442 12443 12444 12445 12446 12447 12580 12581 12582 12583 12584 12585 12617 12618 12619 12620 12621 12622 12629 12630 12631 12632 12633 12634 12838 12839 12840 12841 12842 12843 12899 12900 12901 12902 12903 12904 13004 13005 13006 13007 13008 13009 13023 13024 13025 13026 13027 13028 15180 15181 15182 15183 15184 15185 15242 15243 15244 15245 15246 15247 ]
|
||||||||||||||||||||||||||||||||||
| 25 | 0.69 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
319
]
|
||||||||||||||||||||||||||||||||||
| 26 | 1.45 ms |
SELECT MIN(p0_.price) AS sclr_0, MAX(p0_.price) AS sclr_1 FROM product_variant p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p1_.id = ? AND p1_.visible = true AND p0_.visible = true AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 319 12356 12357 12358 12359 12360 12361 12386 12387 12388 12389 12390 12391 12412 12413 12414 12415 12416 12417 12442 12443 12444 12445 12446 12447 12580 12581 12582 12583 12584 12585 12617 12618 12619 12620 12621 12622 12629 12630 12631 12632 12633 12634 12838 12839 12840 12841 12842 12843 12899 12900 12901 12902 12903 12904 13004 13005 13006 13007 13008 13009 13023 13024 13025 13026 13027 13028 15180 15181 15182 15183 15184 15185 15242 15243 15244 15245 15246 15247 ]
|
||||||||||||||||||||||||||||||||||
| 27 | 0.62 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
397
]
|
||||||||||||||||||||||||||||||||||
| 28 | 2.96 ms |
SELECT i0_.id AS id_0, i0_.url AS url_1, i0_.path AS path_2, i0_.filename AS filename_3, i0_.hash AS hash_4 FROM image i0_ INNER JOIN product_variant_image p1_ ON i0_.id = p1_.image_id INNER JOIN product_variant p2_ ON p1_.variant_id = p2_.id INNER JOIN product p3_ ON p2_.product_id = p3_.id WHERE p3_.id = ? AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY i0_.id, i0_.url, i0_.path, i0_.filename, i0_.hash ORDER BY i0_.path ASC LIMIT 1
Parameters:
[ 397 14772 14773 14774 14775 14776 14777 14778 14779 14780 14781 14782 14783 14784 14785 14786 14787 14851 14852 14853 14854 14855 14856 14857 14858 14869 14870 14871 14872 14873 14874 14875 14876 14877 14878 14879 14880 14881 14882 14883 14884 14904 14905 14906 14907 14908 14909 14910 14911 14951 14952 14953 14954 14955 14956 14957 14958 ]
|
||||||||||||||||||||||||||||||||||
| 29 | 0.77 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
397
]
|
||||||||||||||||||||||||||||||||||
| 30 | 1.56 ms |
SELECT MIN(p0_.price) AS sclr_0, MAX(p0_.price) AS sclr_1 FROM product_variant p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p1_.id = ? AND p1_.visible = true AND p0_.visible = true AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 397 14772 14773 14774 14775 14776 14777 14778 14779 14780 14781 14782 14783 14784 14785 14786 14787 14851 14852 14853 14854 14855 14856 14857 14858 14869 14870 14871 14872 14873 14874 14875 14876 14877 14878 14879 14880 14881 14882 14883 14884 14904 14905 14906 14907 14908 14909 14910 14911 14951 14952 14953 14954 14955 14956 14957 14958 ]
|
||||||||||||||||||||||||||||||||||
| 31 | 0.84 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.visible AS visible_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.position AS position_5, c0_.depth AS depth_6, c0_.sort_path AS sort_path_7, c0_.parent_id AS parent_id_8 FROM category c0_ WHERE c0_.parent_id IS NULL AND c0_.visible = true ORDER BY c0_.sort_path ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||||
| 32 | 0.74 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.visible AS visible_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.position AS position_5, c0_.depth AS depth_6, c0_.sort_path AS sort_path_7, c0_.parent_id AS parent_id_8 FROM category c0_ WHERE c0_.parent_id IS NULL AND c0_.visible = true ORDER BY c0_.sort_path ASC
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Category | 15 |
| App\Entity\Product | 6 |
| App\Entity\Image | 6 |
| App\Entity\Source | 1 |
| App\Entity\Manufacturer | 1 |
| App\Entity\RemoteCategory | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Category | No errors. |
| App\Entity\RemoteCategory | No errors. |
| App\Entity\Attribute | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\ProductVariant | No errors. |
| App\Entity\Source | No errors. |
| App\Entity\Manufacturer | No errors. |
| App\Entity\ProductAttachmentImage | No errors. |
| App\Entity\ProductAttributeValue | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\ProductVariantImage | No errors. |