Query Metrics
47
Database Queries
9
Different statements
26.83 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.38 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_name AS image_name_4, t0.parent_id AS parent_id_5 FROM part_categories t0 WHERE t0.id = ?
Parameters:
[
895
]
|
||||||||||||||||||||||||||||||
| 2 | 5.69 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_name AS image_name_4, t0.parent_id AS parent_id_5 FROM part_categories t0 ORDER BY t0.name ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 3 | 0.70 ms |
SELECT p0_.part_category_id AS sclr_0, COUNT(p0_.id) AS sclr_1 FROM part_listings p0_ LEFT JOIN part_categories p1_ ON p0_.part_category_id = p1_.id LEFT JOIN makes m2_ ON p0_.make_id = m2_.id LEFT JOIN models m3_ ON p0_.model_id = m3_.id LEFT JOIN vehicle_ranges v4_ ON p0_.vehicle_range_id = v4_.id INNER JOIN users u5_ ON p0_.owner_id = u5_.id INNER JOIN company_profiles c6_ ON u5_.id = c6_.user_id WHERE p0_.status = ? AND c6_.status = ? AND p0_.quantity > 0 AND p0_.part_category_id IS NOT NULL GROUP BY p0_.part_category_id
Parameters:
[ "active" "active" ]
|
||||||||||||||||||||||||||||||
| 4 | 4.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_name AS image_name_4, t0.parent_id AS parent_id_5 FROM part_categories t0 ORDER BY t0.name ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 5 | 0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_name AS image_name_4, t0.parent_id AS parent_id_5 FROM part_categories t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 895 933 932 931 930 929 928 927 926 925 924 923 922 921 920 919 918 917 916 915 914 913 912 911 910 909 908 907 906 905 904 903 902 901 900 899 898 897 896 ]
|
||||||||||||||||||||||||||||||
| 6 | 0.40 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 895 8 ]
|
||||||||||||||||||||||||||||||
| 7 | 0.38 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 896 895 8 ]
|
||||||||||||||||||||||||||||||
| 8 | 0.38 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 897 895 8 ]
|
||||||||||||||||||||||||||||||
| 9 | 0.37 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 898 895 8 ]
|
||||||||||||||||||||||||||||||
| 10 | 0.35 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 899 895 8 ]
|
||||||||||||||||||||||||||||||
| 11 | 0.37 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 900 895 8 ]
|
||||||||||||||||||||||||||||||
| 12 | 0.32 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 901 895 8 ]
|
||||||||||||||||||||||||||||||
| 13 | 0.31 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 902 895 8 ]
|
||||||||||||||||||||||||||||||
| 14 | 0.31 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 903 895 8 ]
|
||||||||||||||||||||||||||||||
| 15 | 0.33 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 904 895 8 ]
|
||||||||||||||||||||||||||||||
| 16 | 0.30 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 905 895 8 ]
|
||||||||||||||||||||||||||||||
| 17 | 0.34 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 906 895 8 ]
|
||||||||||||||||||||||||||||||
| 18 | 0.33 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 907 895 8 ]
|
||||||||||||||||||||||||||||||
| 19 | 0.30 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 908 895 8 ]
|
||||||||||||||||||||||||||||||
| 20 | 0.33 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 909 895 8 ]
|
||||||||||||||||||||||||||||||
| 21 | 0.30 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 910 895 8 ]
|
||||||||||||||||||||||||||||||
| 22 | 0.33 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 911 895 8 ]
|
||||||||||||||||||||||||||||||
| 23 | 0.32 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 912 895 8 ]
|
||||||||||||||||||||||||||||||
| 24 | 0.33 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 913 895 8 ]
|
||||||||||||||||||||||||||||||
| 25 | 0.33 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 914 895 8 ]
|
||||||||||||||||||||||||||||||
| 26 | 0.34 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 915 895 8 ]
|
||||||||||||||||||||||||||||||
| 27 | 0.32 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 916 895 8 ]
|
||||||||||||||||||||||||||||||
| 28 | 0.30 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 917 895 8 ]
|
||||||||||||||||||||||||||||||
| 29 | 0.33 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 918 895 8 ]
|
||||||||||||||||||||||||||||||
| 30 | 0.32 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 919 895 8 ]
|
||||||||||||||||||||||||||||||
| 31 | 0.34 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 920 895 8 ]
|
||||||||||||||||||||||||||||||
| 32 | 0.32 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 921 895 8 ]
|
||||||||||||||||||||||||||||||
| 33 | 0.34 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 922 895 8 ]
|
||||||||||||||||||||||||||||||
| 34 | 0.32 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 923 895 8 ]
|
||||||||||||||||||||||||||||||
| 35 | 0.30 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 924 895 8 ]
|
||||||||||||||||||||||||||||||
| 36 | 0.33 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 925 895 8 ]
|
||||||||||||||||||||||||||||||
| 37 | 0.33 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 926 895 8 ]
|
||||||||||||||||||||||||||||||
| 38 | 0.33 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 927 895 8 ]
|
||||||||||||||||||||||||||||||
| 39 | 0.32 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 928 895 8 ]
|
||||||||||||||||||||||||||||||
| 40 | 0.33 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 929 895 8 ]
|
||||||||||||||||||||||||||||||
| 41 | 0.33 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 930 895 8 ]
|
||||||||||||||||||||||||||||||
| 42 | 0.31 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 931 895 8 ]
|
||||||||||||||||||||||||||||||
| 43 | 0.32 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 932 895 8 ]
|
||||||||||||||||||||||||||||||
| 44 | 0.32 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[ 933 895 8 ]
|
||||||||||||||||||||||||||||||
| 45 | 0.89 ms |
SELECT p0_.id AS id_0, p0_.short_description AS short_description_1, p0_.slug AS slug_2, p0_.full_description AS full_description_3, p0_.tags AS tags_4, p0_.catalog_number AS catalog_number_5, p0_.oem_number AS oem_number_6, p0_.article_number AS article_number_7, p0_.condition_type AS condition_type_8, p0_.price AS price_9, p0_.price_new AS price_new_10, p0_.quantity AS quantity_11, p0_.status AS status_12, p0_.created_at AS created_at_13, p1_.id AS id_14, p1_.image_name AS image_name_15, p1_.sort_order AS sort_order_16, p2_.id AS id_17, p2_.name AS name_18, p2_.slug AS slug_19, p2_.image_name AS image_name_20, m3_.id AS id_21, m3_.name AS name_22, m3_.slug AS slug_23, m3_.ext_source AS ext_source_24, m3_.ext_id AS ext_id_25, m4_.id AS id_26, m4_.name AS name_27, m4_.slug AS slug_28, m4_.ext_id AS ext_id_29, v5_.id AS id_30, v5_.year_from AS year_from_31, v5_.year_to AS year_to_32, v5_.generation_name AS generation_name_33, p6_.id AS id_34, p6_.value_text AS value_text_35, p6_.value_number_from AS value_number_from_36, p6_.value_number_to AS value_number_to_37, p6_.value_json AS value_json_38, c7_.id AS id_39, c7_.code AS code_40, c7_.name_en AS name_en_41, c7_.name_es AS name_es_42, c7_.type AS type_43, c7_.sort_order AS sort_order_44, p0_.owner_id AS owner_id_45, p0_.make_id AS make_id_46, p0_.model_id AS model_id_47, p0_.vehicle_range_id AS vehicle_range_id_48, p0_.part_category_id AS part_category_id_49, p0_.dismantled_vehicle_id AS dismantled_vehicle_id_50, p1_.listing_id AS listing_id_51, p2_.parent_id AS parent_id_52, m4_.make_id AS make_id_53, v5_.model_id AS model_id_54, p6_.listing_id AS listing_id_55, p6_.filter_id AS filter_id_56 FROM part_listings p0_ LEFT JOIN part_listing_images p1_ ON p0_.id = p1_.listing_id LEFT JOIN part_categories p2_ ON p0_.part_category_id = p2_.id LEFT JOIN makes m3_ ON p0_.make_id = m3_.id LEFT JOIN models m4_ ON p0_.model_id = m4_.id LEFT JOIN vehicle_ranges v5_ ON p0_.vehicle_range_id = v5_.id LEFT JOIN part_listing_custom_filter_values p6_ ON p0_.id = p6_.listing_id LEFT JOIN custom_filters c7_ ON p6_.filter_id = c7_.id INNER JOIN users u8_ ON p0_.owner_id = u8_.id INNER JOIN company_profiles c9_ ON u8_.id = c9_.user_id WHERE p0_.status = ? AND c9_.status = ? AND p0_.quantity > 0 AND p2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.created_at DESC
Parameters:
[ "active" "active" 895 933 932 931 930 929 928 927 926 925 924 923 922 921 920 919 918 917 916 915 914 913 912 911 910 909 908 907 906 905 904 903 902 901 900 899 898 897 896 ]
|
||||||||||||||||||||||||||||||
| 46 | 1.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ext_source AS ext_source_4, t0.ext_id AS ext_id_5 FROM makes t0 ORDER BY t0.name ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 47 | 0.41 ms |
SELECT c0_.id AS id_0, c0_.company_name AS company_name_1, c0_.logo_name AS logo_name_2, c0_.ein AS ein_3, c0_.status AS status_4, c0_.submitted_at AS submitted_at_5, c0_.reviewed_at AS reviewed_at_6, u1_.id AS id_7, u1_.email AS email_8, u1_.roles AS roles_9, u1_.password AS password_10, u1_.is_verified AS is_verified_11, u1_.phone AS phone_12, u1_.address_line1 AS address_line1_13, u1_.address_line2 AS address_line2_14, u1_.city AS city_15, u1_.state AS state_16, u1_.postal_code AS postal_code_17, u1_.is_company AS is_company_18, c0_.user_id AS user_id_19 FROM company_profiles c0_ INNER JOIN users u1_ ON c0_.user_id = u1_.id WHERE c0_.status = ? AND c0_.company_name IS NOT NULL AND TRIM(c0_.company_name) <> '' ORDER BY c0_.company_name ASC
Parameters:
[
"active"
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\PartCategory | No errors. |
| App\Entity\CustomFilter | No errors. |
| App\Entity\PartListing | No errors. |
| App\Entity\Make | No errors. |
| App\Entity\Model | No errors. |
| App\Entity\VehicleRange | No errors. |
| App\Entity\Users | No errors. |
| App\Entity\CompanyProfile | No errors. |
| App\Entity\CustomFilterOption | No errors. |
| App\Entity\PartListingImage | No errors. |
| App\Entity\PartListingCustomFilterValue | No errors. |
| App\Entity\DismantledVehicle | No errors. |
| App\Entity\PartListingFitment | No errors. |