Query Metrics
44
Database Queries
25
Different statements
68.44 ms
Query time
0
Invalid entities
36
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.01 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:
[
"1"
]
|
||||||||||||||||||||||||||||||||||
| 2 | 2.49 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.99 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
null
]
|
||||||||||||||||||||||||||||||||||
| 4 | 5.03 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:
[
1
]
|
||||||||||||||||||||||||||||||||||
| 5 | 2.93 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 72
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||
| 6 | 1.98 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:
[ 1 57 19 217 259 25 409 218 30 21 ]
|
||||||||||||||||||||||||||||||||||
| 7 | 0.65 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
19
]
|
||||||||||||||||||||||||||||||||||
| 8 | 5.02 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:
[ 19 1314 1315 1316 1317 1318 1319 1320 1321 1322 1323 1324 1325 1326 1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 1375 1376 1377 1378 1379 1380 1381 1382 1383 1384 1385 1386 1387 1388 1389 1390 1391 1392 1393 1394 1395 1396 1397 1398 1399 1400 1401 1402 1403 1404 1405 1406 1407 1408 1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419 1420 1421 1422 1423 1424 1425 1426 1427 1428 1429 1430 1431 1432 1433 1434 1435 1436 1437 1438 1439 14324 14325 14326 14327 14328 14329 14411 14412 14413 14414 14415 14416 14452 14453 14454 14455 14456 14457 14458 14459 14460 14461 14462 14463 14638 14639 14640 14641 14642 14643 ]
|
||||||||||||||||||||||||||||||||||
| 9 | 0.66 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
19
]
|
||||||||||||||||||||||||||||||||||
| 10 | 2.00 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:
[ 19 1314 1315 1316 1317 1318 1319 1320 1321 1322 1323 1324 1325 1326 1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 1375 1376 1377 1378 1379 1380 1381 1382 1383 1384 1385 1386 1387 1388 1389 1390 1391 1392 1393 1394 1395 1396 1397 1398 1399 1400 1401 1402 1403 1404 1405 1406 1407 1408 1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419 1420 1421 1422 1423 1424 1425 1426 1427 1428 1429 1430 1431 1432 1433 1434 1435 1436 1437 1438 1439 14324 14325 14326 14327 14328 14329 14411 14412 14413 14414 14415 14416 14452 14453 14454 14455 14456 14457 14458 14459 14460 14461 14462 14463 14638 14639 14640 14641 14642 14643 ]
|
||||||||||||||||||||||||||||||||||
| 11 | 0.58 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
21
]
|
||||||||||||||||||||||||||||||||||
| 12 | 4.67 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:
[ 21 1548 1549 1550 1551 1552 1553 1554 1555 1556 1557 1558 1559 1560 1561 1562 1563 1564 1565 1566 1567 1568 1569 1570 1571 1572 1573 1574 1575 1576 1577 1578 1579 1580 1581 1582 1583 1584 1585 1586 1587 1588 1589 1590 1591 1592 1593 1594 1595 1596 1597 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607 1608 1609 1610 1611 1612 1613 1614 1615 1616 1617 1618 1619 1620 1621 1622 1623 1624 1625 1626 1627 1628 1629 1630 1631 1632 1633 1634 1635 1636 1637 1638 1639 1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657 1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668 1669 1670 1671 1672 1673 1674 1675 1676 1677 1678 1679 1680 1681 1682 1683 1684 1685 1686 1687 1688 1689 1690 1691 1692 1693 1694 1695 1696 1697 1698 1699 1700 1701 1702 1703 1704 1705 1706 1707 1708 1709 1710 1711 1712 1713 1714 1715 1716 1717 1718 1719 1720 1721 1722 1723 1724 1725 1726 1727 1728 1729 1730 1731 1732 1733 1734 1735 1736 1737 1738 1739 1740 1741 1742 1743 1744 1745 1746 1747 1748 1749 1750 1751 1752 1753 1754 1755 1756 1757 1758 1759 1760 1761 1762 1763 1764 9789 9790 9791 9792 9793 9794 9972 9973 9974 9975 9976 9977 12418 12419 12420 12421 12422 12423 12653 12654 12655 12656 12657 12658 12950 12951 12952 12953 12954 12955 14766 14767 14768 14769 14770 14771 14811 14812 14813 14814 14815 14816 15753 15754 15755 15756 15757 15758 16008 16009 16010 16011 16012 16013 ]
|
||||||||||||||||||||||||||||||||||
| 13 | 0.61 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
21
]
|
||||||||||||||||||||||||||||||||||
| 14 | 2.15 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:
[ 21 1548 1549 1550 1551 1552 1553 1554 1555 1556 1557 1558 1559 1560 1561 1562 1563 1564 1565 1566 1567 1568 1569 1570 1571 1572 1573 1574 1575 1576 1577 1578 1579 1580 1581 1582 1583 1584 1585 1586 1587 1588 1589 1590 1591 1592 1593 1594 1595 1596 1597 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607 1608 1609 1610 1611 1612 1613 1614 1615 1616 1617 1618 1619 1620 1621 1622 1623 1624 1625 1626 1627 1628 1629 1630 1631 1632 1633 1634 1635 1636 1637 1638 1639 1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657 1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668 1669 1670 1671 1672 1673 1674 1675 1676 1677 1678 1679 1680 1681 1682 1683 1684 1685 1686 1687 1688 1689 1690 1691 1692 1693 1694 1695 1696 1697 1698 1699 1700 1701 1702 1703 1704 1705 1706 1707 1708 1709 1710 1711 1712 1713 1714 1715 1716 1717 1718 1719 1720 1721 1722 1723 1724 1725 1726 1727 1728 1729 1730 1731 1732 1733 1734 1735 1736 1737 1738 1739 1740 1741 1742 1743 1744 1745 1746 1747 1748 1749 1750 1751 1752 1753 1754 1755 1756 1757 1758 1759 1760 1761 1762 1763 1764 9789 9790 9791 9792 9793 9794 9972 9973 9974 9975 9976 9977 12418 12419 12420 12421 12422 12423 12653 12654 12655 12656 12657 12658 12950 12951 12952 12953 12954 12955 14766 14767 14768 14769 14770 14771 14811 14812 14813 14814 14815 14816 15753 15754 15755 15756 15757 15758 16008 16009 16010 16011 16012 16013 ]
|
||||||||||||||||||||||||||||||||||
| 15 | 0.62 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
25
]
|
||||||||||||||||||||||||||||||||||
| 16 | 3.77 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:
[ 25 2168 2169 2170 2171 2172 2173 2174 2175 2176 2177 2178 2179 2180 2181 2182 2183 2184 2185 2186 2187 2188 2189 2190 2191 2192 2193 2194 2195 2196 2197 2198 2199 2200 2201 2202 2203 2204 2205 2206 2207 2208 2209 2210 2211 2212 2213 2214 2215 2216 2217 2218 2219 2220 2221 2222 2223 2224 2225 2226 2227 2228 2229 2230 2231 2232 2233 2234 2235 2236 2237 2238 2239 2240 2241 2242 2243 2244 2245 2246 2247 2248 2249 2250 2251 2252 2253 2254 2255 2256 2257 2258 2259 2260 2261 2262 2263 2264 2265 2266 2267 2268 2269 2270 2271 2272 2273 2274 2275 2276 2277 2278 2279 2280 2281 2282 2283 2284 2285 2286 2287 2288 2289 2290 2291 2292 9795 9796 9797 9798 9799 9985 9986 9987 9988 9989 12726 12727 12728 12729 12730 12737 12738 12739 12740 12741 14885 14886 14887 14888 14889 14931 14932 14933 14934 14935 15773 15774 15775 15776 15777 15923 15924 15925 15926 15927 ]
|
||||||||||||||||||||||||||||||||||
| 17 | 0.63 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
25
]
|
||||||||||||||||||||||||||||||||||
| 18 | 1.84 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:
[ 25 2168 2169 2170 2171 2172 2173 2174 2175 2176 2177 2178 2179 2180 2181 2182 2183 2184 2185 2186 2187 2188 2189 2190 2191 2192 2193 2194 2195 2196 2197 2198 2199 2200 2201 2202 2203 2204 2205 2206 2207 2208 2209 2210 2211 2212 2213 2214 2215 2216 2217 2218 2219 2220 2221 2222 2223 2224 2225 2226 2227 2228 2229 2230 2231 2232 2233 2234 2235 2236 2237 2238 2239 2240 2241 2242 2243 2244 2245 2246 2247 2248 2249 2250 2251 2252 2253 2254 2255 2256 2257 2258 2259 2260 2261 2262 2263 2264 2265 2266 2267 2268 2269 2270 2271 2272 2273 2274 2275 2276 2277 2278 2279 2280 2281 2282 2283 2284 2285 2286 2287 2288 2289 2290 2291 2292 9795 9796 9797 9798 9799 9985 9986 9987 9988 9989 12726 12727 12728 12729 12730 12737 12738 12739 12740 12741 14885 14886 14887 14888 14889 14931 14932 14933 14934 14935 15773 15774 15775 15776 15777 15923 15924 15925 15926 15927 ]
|
||||||||||||||||||||||||||||||||||
| 19 | 0.53 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
30
]
|
||||||||||||||||||||||||||||||||||
| 20 | 2.37 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:
[ 30 2560 2561 2562 2563 2564 2565 2566 2567 2568 2569 2570 2571 2572 2573 2574 2575 2576 2577 2578 2579 2580 2581 2582 2583 2584 2585 2586 2587 2588 2589 2590 2591 2592 2593 2594 2595 2596 2597 2598 2599 2600 2601 2602 2603 2604 2605 2606 2607 2608 2609 2610 2611 2612 2613 2614 2615 2616 2617 2618 2619 2620 2621 2622 2623 2624 2625 2626 2627 2628 2629 2630 2631 2632 2633 2634 2635 2636 2637 2638 2639 2640 ]
|
||||||||||||||||||||||||||||||||||
| 21 | 0.64 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
30
]
|
||||||||||||||||||||||||||||||||||
| 22 | 1.37 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:
[ 30 2560 2561 2562 2563 2564 2565 2566 2567 2568 2569 2570 2571 2572 2573 2574 2575 2576 2577 2578 2579 2580 2581 2582 2583 2584 2585 2586 2587 2588 2589 2590 2591 2592 2593 2594 2595 2596 2597 2598 2599 2600 2601 2602 2603 2604 2605 2606 2607 2608 2609 2610 2611 2612 2613 2614 2615 2616 2617 2618 2619 2620 2621 2622 2623 2624 2625 2626 2627 2628 2629 2630 2631 2632 2633 2634 2635 2636 2637 2638 2639 2640 ]
|
||||||||||||||||||||||||||||||||||
| 23 | 0.58 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
57
]
|
||||||||||||||||||||||||||||||||||
| 24 | 2.34 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:
[ 57 3891 3892 3893 3894 3895 3896 3897 3898 3899 3900 3901 3902 3903 3904 3905 3906 3907 3908 3909 3910 3911 3912 3913 3914 3915 3916 3917 3918 3919 3920 3921 3922 3923 3924 3925 3926 3927 3928 3929 3930 3931 3932 3933 3934 3935 3936 3937 3938 3939 3940 3941 3942 3943 3944 3945 3946 3947 3948 3949 3950 ]
|
||||||||||||||||||||||||||||||||||
| 25 | 0.60 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
57
]
|
||||||||||||||||||||||||||||||||||
| 26 | 1.07 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:
[ 57 3891 3892 3893 3894 3895 3896 3897 3898 3899 3900 3901 3902 3903 3904 3905 3906 3907 3908 3909 3910 3911 3912 3913 3914 3915 3916 3917 3918 3919 3920 3921 3922 3923 3924 3925 3926 3927 3928 3929 3930 3931 3932 3933 3934 3935 3936 3937 3938 3939 3940 3941 3942 3943 3944 3945 3946 3947 3948 3949 3950 ]
|
||||||||||||||||||||||||||||||||||
| 27 | 0.49 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
217
]
|
||||||||||||||||||||||||||||||||||
| 28 | 3.03 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:
[ 217 8169 8170 8171 8172 8173 8174 8175 8176 8177 8178 8179 8180 8181 8182 8183 8184 8185 8186 8187 8188 8189 8190 8191 8192 8193 8194 8195 8196 8197 8198 8199 8200 8201 8202 8203 8204 8205 8206 8207 8208 8209 8210 8211 8212 8213 8214 8215 8216 8217 8218 8219 8220 8221 8222 8223 8224 8225 8226 8227 8228 8229 8230 8231 8232 8233 8234 8235 8236 8237 8238 8239 8240 8241 8242 8243 8244 8245 8246 8247 8248 8249 8250 8251 8252 8253 8254 8255 8256 8257 8258 8259 8260 8261 8262 8263 8264 8265 8266 8267 8268 8269 8270 8271 8272 8273 8274 8275 8276 ]
|
||||||||||||||||||||||||||||||||||
| 29 | 0.64 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
217
]
|
||||||||||||||||||||||||||||||||||
| 30 | 1.77 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:
[ 217 8169 8170 8171 8172 8173 8174 8175 8176 8177 8178 8179 8180 8181 8182 8183 8184 8185 8186 8187 8188 8189 8190 8191 8192 8193 8194 8195 8196 8197 8198 8199 8200 8201 8202 8203 8204 8205 8206 8207 8208 8209 8210 8211 8212 8213 8214 8215 8216 8217 8218 8219 8220 8221 8222 8223 8224 8225 8226 8227 8228 8229 8230 8231 8232 8233 8234 8235 8236 8237 8238 8239 8240 8241 8242 8243 8244 8245 8246 8247 8248 8249 8250 8251 8252 8253 8254 8255 8256 8257 8258 8259 8260 8261 8262 8263 8264 8265 8266 8267 8268 8269 8270 8271 8272 8273 8274 8275 8276 ]
|
||||||||||||||||||||||||||||||||||
| 31 | 0.59 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
218
]
|
||||||||||||||||||||||||||||||||||
| 32 | 1.99 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:
[ 218 8277 8278 8279 8280 8281 8282 8283 8284 8285 8286 8287 8288 8289 8290 8291 8292 8293 8294 8295 8296 8297 8298 8299 8300 8301 8302 8303 8304 8305 8306 8307 8308 8309 8310 8311 8312 8313 8314 8315 8316 8317 8318 ]
|
||||||||||||||||||||||||||||||||||
| 33 | 0.61 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
218
]
|
||||||||||||||||||||||||||||||||||
| 34 | 1.13 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:
[ 218 8277 8278 8279 8280 8281 8282 8283 8284 8285 8286 8287 8288 8289 8290 8291 8292 8293 8294 8295 8296 8297 8298 8299 8300 8301 8302 8303 8304 8305 8306 8307 8308 8309 8310 8311 8312 8313 8314 8315 8316 8317 8318 ]
|
||||||||||||||||||||||||||||||||||
| 35 | 0.56 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
259
]
|
||||||||||||||||||||||||||||||||||
| 36 | 1.62 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:
[ 259 10357 10358 10359 10360 10361 10362 ]
|
||||||||||||||||||||||||||||||||||
| 37 | 0.62 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
259
]
|
||||||||||||||||||||||||||||||||||
| 38 | 0.81 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:
[ 259 10357 10358 10359 10360 10361 10362 ]
|
||||||||||||||||||||||||||||||||||
| 39 | 0.55 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
409
]
|
||||||||||||||||||||||||||||||||||
| 40 | 2.41 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:
[ 409 16770 16771 16772 16773 16774 16775 16776 16791 16792 16793 16794 16795 16802 16803 16804 16805 16806 16817 16818 16819 16820 16821 16822 16823 16824 16825 16826 16836 16837 16838 16839 16840 16841 16842 16843 16844 16845 16846 16847 16848 16849 16850 16851 16867 16868 16869 16870 16871 16872 16873 16874 16875 16882 16883 16884 16885 16886 16898 16899 16900 16901 16902 16903 16908 16909 16910 16911 16912 16913 ]
|
||||||||||||||||||||||||||||||||||
| 41 | 0.61 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
409
]
|
||||||||||||||||||||||||||||||||||
| 42 | 1.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:
[ 409 16770 16771 16772 16773 16774 16775 16776 16791 16792 16793 16794 16795 16802 16803 16804 16805 16806 16817 16818 16819 16820 16821 16822 16823 16824 16825 16826 16836 16837 16838 16839 16840 16841 16842 16843 16844 16845 16846 16847 16848 16849 16850 16851 16867 16868 16869 16870 16871 16872 16873 16874 16875 16882 16883 16884 16885 16886 16898 16899 16900 16901 16902 16903 16908 16909 16910 16911 16912 16913 ]
|
||||||||||||||||||||||||||||||||||
| 43 | 0.86 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.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 | 9 |
| App\Entity\Image | 9 |
| 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. |