Query Metrics
44
Database Queries
25
Different statements
33.13 ms
Query time
0
Invalid entities
23
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.86 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:
[
"3"
]
|
||||||||||||||||||||||||||||||||||
| 2 | 1.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.34 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
null
]
|
||||||||||||||||||||||||||||||||||
| 4 | 2.18 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:
[
3
]
|
||||||||||||||||||||||||||||||||||
| 5 | 1.32 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 18
Parameters:
[
3
]
|
||||||||||||||||||||||||||||||||||
| 6 | 0.77 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:
[ 3 80 67 83 201 63 90 258 35 45 ]
|
||||||||||||||||||||||||||||||||||
| 7 | 0.28 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
35
]
|
||||||||||||||||||||||||||||||||||
| 8 | 2.22 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:
[ 35 2354 2355 2356 2357 2358 2359 2360 2361 2362 2363 2364 2365 2366 2367 2368 2369 2370 2371 2372 2373 2374 2375 2376 2377 2378 2379 2380 2381 2382 2383 2384 2385 2386 2387 2388 2389 2390 2391 2392 2393 2394 2395 2396 2397 2398 2399 2400 2401 2402 2403 2404 2405 2406 2407 2408 2409 2410 2411 2412 2413 ]
|
||||||||||||||||||||||||||||||||||
| 9 | 0.23 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
35
]
|
||||||||||||||||||||||||||||||||||
| 10 | 0.58 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:
[ 35 2354 2355 2356 2357 2358 2359 2360 2361 2362 2363 2364 2365 2366 2367 2368 2369 2370 2371 2372 2373 2374 2375 2376 2377 2378 2379 2380 2381 2382 2383 2384 2385 2386 2387 2388 2389 2390 2391 2392 2393 2394 2395 2396 2397 2398 2399 2400 2401 2402 2403 2404 2405 2406 2407 2408 2409 2410 2411 2412 2413 ]
|
||||||||||||||||||||||||||||||||||
| 11 | 0.15 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
45
]
|
||||||||||||||||||||||||||||||||||
| 12 | 9.29 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:
[ 45 2955 2956 2957 2958 2959 2960 2961 2962 2963 2964 2965 2966 2967 2968 2969 2970 2971 2972 2973 2974 2975 2976 2977 2978 2979 2980 2981 2982 2983 2984 2985 2986 2987 2988 2989 2990 2991 2992 2993 2994 2995 2996 2997 2998 2999 3000 3001 3002 3003 3004 3005 3006 3007 3008 3009 3010 3011 3012 3013 3014 3015 3016 3017 3018 3019 3020 3021 3022 3023 3024 3025 3026 16920 16921 16922 16923 16924 16925 17033 17034 17035 17036 17037 17038 18164 18165 18166 18167 18168 18169 18269 18270 18271 18272 18273 18274 18393 18394 18395 18396 18397 18398 ]
|
||||||||||||||||||||||||||||||||||
| 13 | 0.19 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
45
]
|
||||||||||||||||||||||||||||||||||
| 14 | 0.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:
[ 45 2955 2956 2957 2958 2959 2960 2961 2962 2963 2964 2965 2966 2967 2968 2969 2970 2971 2972 2973 2974 2975 2976 2977 2978 2979 2980 2981 2982 2983 2984 2985 2986 2987 2988 2989 2990 2991 2992 2993 2994 2995 2996 2997 2998 2999 3000 3001 3002 3003 3004 3005 3006 3007 3008 3009 3010 3011 3012 3013 3014 3015 3016 3017 3018 3019 3020 3021 3022 3023 3024 3025 3026 16920 16921 16922 16923 16924 16925 17033 17034 17035 17036 17037 17038 18164 18165 18166 18167 18168 18169 18269 18270 18271 18272 18273 18274 18393 18394 18395 18396 18397 18398 ]
|
||||||||||||||||||||||||||||||||||
| 15 | 0.13 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
63
]
|
||||||||||||||||||||||||||||||||||
| 16 | 2.54 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:
[ 63 4905 4906 4907 4908 4909 4910 4911 4912 4913 4914 4915 4916 4917 4918 4919 4920 4921 4922 4923 4924 4925 13956 13957 13958 13959 13960 13961 13962 ]
|
||||||||||||||||||||||||||||||||||
| 17 | 0.15 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
63
]
|
||||||||||||||||||||||||||||||||||
| 18 | 0.30 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:
[ 63 4905 4906 4907 4908 4909 4910 4911 4912 4913 4914 4915 4916 4917 4918 4919 4920 4921 4922 4923 4924 4925 13956 13957 13958 13959 13960 13961 13962 ]
|
||||||||||||||||||||||||||||||||||
| 19 | 0.12 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
67
]
|
||||||||||||||||||||||||||||||||||
| 20 | 0.66 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:
[ 67 5134 5135 5136 5137 5138 5139 5140 5141 5142 5143 5144 5145 5146 5147 5148 13839 13840 13841 13842 13843 ]
|
||||||||||||||||||||||||||||||||||
| 21 | 0.15 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
67
]
|
||||||||||||||||||||||||||||||||||
| 22 | 0.28 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:
[ 67 5134 5135 5136 5137 5138 5139 5140 5141 5142 5143 5144 5145 5146 5147 5148 13839 13840 13841 13842 13843 ]
|
||||||||||||||||||||||||||||||||||
| 23 | 0.11 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
80
]
|
||||||||||||||||||||||||||||||||||
| 24 | 0.64 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:
[ 80 5651 5652 5653 5654 5655 5656 5657 5658 5659 5660 5661 5662 5663 5664 5665 5666 5667 5668 5669 5670 5671 ]
|
||||||||||||||||||||||||||||||||||
| 25 | 0.14 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
80
]
|
||||||||||||||||||||||||||||||||||
| 26 | 0.26 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:
[ 80 5651 5652 5653 5654 5655 5656 5657 5658 5659 5660 5661 5662 5663 5664 5665 5666 5667 5668 5669 5670 5671 ]
|
||||||||||||||||||||||||||||||||||
| 27 | 0.13 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
83
]
|
||||||||||||||||||||||||||||||||||
| 28 | 2.47 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:
[ 83 5757 5758 5759 5760 5761 5762 5763 5764 5765 5766 5767 5768 5769 5770 5771 5772 5773 5774 5775 5776 5777 5778 5779 5780 5781 5782 5783 5784 5785 5786 5787 5788 5789 5790 5791 5792 5793 5794 5795 5796 5797 5798 5799 5800 5801 5802 5803 5804 5805 5806 5807 5808 5809 5810 5811 5812 5813 5814 5815 5816 5817 5818 5819 5820 5821 5822 5823 5824 5825 5826 5827 5828 5829 5830 5831 5832 5833 5834 5835 5836 14882 14883 14884 14885 14886 14887 ]
|
||||||||||||||||||||||||||||||||||
| 29 | 0.17 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
83
]
|
||||||||||||||||||||||||||||||||||
| 30 | 0.49 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:
[ 83 5757 5758 5759 5760 5761 5762 5763 5764 5765 5766 5767 5768 5769 5770 5771 5772 5773 5774 5775 5776 5777 5778 5779 5780 5781 5782 5783 5784 5785 5786 5787 5788 5789 5790 5791 5792 5793 5794 5795 5796 5797 5798 5799 5800 5801 5802 5803 5804 5805 5806 5807 5808 5809 5810 5811 5812 5813 5814 5815 5816 5817 5818 5819 5820 5821 5822 5823 5824 5825 5826 5827 5828 5829 5830 5831 5832 5833 5834 5835 5836 14882 14883 14884 14885 14886 14887 ]
|
||||||||||||||||||||||||||||||||||
| 31 | 0.12 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
90
]
|
||||||||||||||||||||||||||||||||||
| 32 | 0.63 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:
[ 90 6215 6216 6217 6218 6219 6220 6221 6222 6223 6224 6225 6226 ]
|
||||||||||||||||||||||||||||||||||
| 33 | 0.13 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
90
]
|
||||||||||||||||||||||||||||||||||
| 34 | 0.26 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:
[ 90 6215 6216 6217 6218 6219 6220 6221 6222 6223 6224 6225 6226 ]
|
||||||||||||||||||||||||||||||||||
| 35 | 0.11 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
201
]
|
||||||||||||||||||||||||||||||||||
| 36 | 0.55 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:
[ 201 9892 9893 9894 9895 9896 ]
|
||||||||||||||||||||||||||||||||||
| 37 | 0.13 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
201
]
|
||||||||||||||||||||||||||||||||||
| 38 | 0.22 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:
[ 201 9892 9893 9894 9895 9896 ]
|
||||||||||||||||||||||||||||||||||
| 39 | 0.12 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
258
]
|
||||||||||||||||||||||||||||||||||
| 40 | 1.14 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:
[ 258 10895 10896 10897 10898 10899 10900 10901 10902 10903 10904 10905 10906 10907 10908 10909 10910 10911 10912 10913 10914 10915 10916 10917 10918 10919 10920 10921 10922 10923 10924 10925 10926 10927 10928 10929 10930 10931 10932 10933 10934 10935 10936 10937 10938 10939 10940 10941 10942 ]
|
||||||||||||||||||||||||||||||||||
| 41 | 0.14 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
258
]
|
||||||||||||||||||||||||||||||||||
| 42 | 0.43 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:
[ 258 10895 10896 10897 10898 10899 10900 10901 10902 10903 10904 10905 10906 10907 10908 10909 10910 10911 10912 10913 10914 10915 10916 10917 10918 10919 10920 10921 10922 10923 10924 10925 10926 10927 10928 10929 10930 10931 10932 10933 10934 10935 10936 10937 10938 10939 10940 10941 10942 ]
|
||||||||||||||||||||||||||||||||||
| 43 | 0.17 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:
[] |
||||||||||||||||||||||||||||||||||
| 44 | 0.15 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\Product | 9 |
| App\Entity\Image | 9 |
| App\Entity\Category | 2 |
| 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. |