Query Metrics
77
Database Queries
10
Different statements
1649.94 ms
Query time
7
Invalid entities
177
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1260.25 ms (76.38%) |
2 |
SELECT m0_.name AS name_0, m0_.slug AS slug_1, m0_.description AS description_2, m0_.caracteristiques AS caracteristiques_3, m0_.price AS price_4, m0_.url AS url_5, m0_.compatibility AS compatibility_6, m0_.miniature AS miniature_7, m0_.openai AS openai_8, m0_.file AS file_9, m0_.removed AS removed_10, m0_.id AS id_11, m0_.active AS active_12, m0_.date_created AS date_created_13, m0_.date_updated AS date_updated_14, AVG(r1_.note) AS sclr_15, m0_.manufacturer_id AS manufacturer_id_16, m0_.main_category_id AS main_category_id_17, m0_.user_id AS user_id_18 FROM modules m0_ LEFT JOIN reviews r1_ ON m0_.id = r1_.module_id LEFT JOIN categories_modules c3_ ON m0_.id = c3_.modules_id LEFT JOIN categories c2_ ON c2_.id = c3_.categories_id WHERE m0_.price >= ? AND m0_.price <= ? AND m0_.active = ? AND c2_.slug IN (?) GROUP BY m0_.id HAVING sclr_15 IS NULL OR sclr_15 <= ?
Parameters:
[ 0.0 99999.0 1 "support-chat-online" 5 ] |
|
280.20 ms (16.98%) |
66 |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description_short AS description_short_3, t0.id AS id_4, t0.active AS active_5, t0.date_created AS date_created_6, t0.date_updated AS date_updated_7, t0.parent_id AS parent_id_8 FROM categories t0 WHERE t0.parent_id = ?
Parameters:
[
119
]
|
|
26.13 ms (1.58%) |
1 |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description_short AS description_short_3, t0.id AS id_4, t0.active AS active_5, t0.date_created AS date_created_6, t0.date_updated AS date_updated_7, t0.parent_id AS parent_id_8 FROM categories t0 WHERE t0.slug = ? AND t0.active = ? LIMIT 1
Parameters:
[ "support-chat-online" 1 ] |
|
22.18 ms (1.34%) |
1 |
SELECT t0.name AS name_1, t0.io AS io_2, t0.ram AS ram_3, t0.storage AS storage_4, t0.price AS price_5, t0.strike_price AS strike_price_6, t0.market_price AS market_price_7, t0.headline AS headline_8, t0.stars AS stars_9, t0.id AS id_10, t0.active AS active_11 FROM webhostings_offers t0 WHERE t0.active = ? ORDER BY t0.id ASC
Parameters:
[
1
]
|
|
21.65 ms (1.31%) |
1 |
SELECT m0_.name AS name_0, m0_.slug AS slug_1, m0_.image AS image_2, m0_.description AS description_3, m0_.country AS country_4, m0_.support_languages AS support_languages_5, m0_.id AS id_6, m0_.active AS active_7, m0_.date_created AS date_created_8, m0_.date_updated AS date_updated_9 FROM manufacturer m0_ WHERE m0_.active = ? AND m0_.name <> ? ORDER BY m0_.name ASC
Parameters:
[
1
""
]
|
|
15.45 ms (0.94%) |
1 |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.color AS color_3, t0.id AS id_4, t0.date_created AS date_created_5, t0.date_updated AS date_updated_6, t0.active AS active_7, t0.parent_id AS parent_id_8 FROM themes_categories t0 WHERE t0.active = ? AND t0.parent_id = ?
Parameters:
[ 1 2 ] |
|
9.11 ms (0.55%) |
2 |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.image AS image_3, t0.description AS description_4, t0.country AS country_5, t0.support_languages AS support_languages_6, t0.id AS id_7, t0.active AS active_8, t0.date_created AS date_created_9, t0.date_updated AS date_updated_10 FROM manufacturer t0
Parameters:
[] |
|
8.17 ms (0.50%) |
1 |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description_short AS description_short_3, t0.id AS id_4, t0.active AS active_5, t0.date_created AS date_created_6, t0.date_updated AS date_updated_7, t0.parent_id AS parent_id_8 FROM categories t0 WHERE t0.active = ? AND t0.parent_id = ?
Parameters:
[ 1 118 ] |
|
6.48 ms (0.39%) |
1 |
SELECT t0.question AS question_1, t0.answer AS answer_2, t0.routename AS routename_3, t0.id AS id_4, t0.date_created AS date_created_5, t0.date_updated AS date_updated_6 FROM faq t0 WHERE t0.routename = ?
Parameters:
[
"prestashop_addons"
]
|
|
0.34 ms (0.02%) |
1 |
SELECT t0.install AS install_1, t0.config AS config_2, t0.express AS express_3, t0.status AS status_4, t0.id AS id_5, t0.date_created AS date_created_6, t0.date_updated AS date_updated_7, t0.customer_id AS customer_id_8, t0.user_id AS user_id_9, t0.guest_id AS guest_id_10 FROM cart t0 WHERE t0.guest_id = ? LIMIT 1
Parameters:
[
null
]
|
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\Manufacturer | 98 |
| App\Entity\Categories | 67 |
| App\Entity\ThemesCategories | 9 |
| App\Entity\WebhostingsOffers | 3 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Modules |
|
| App\Entity\Categories | No errors. |
| App\Entity\Manufacturer | No errors. |
| App\Entity\Themes |
|
| App\Entity\Reviews |
|
| App\Entity\User |
|
| App\Entity\ThemesCategories |
|
| App\Entity\WebhostingsOffers | No errors. |
| App\Entity\Faq | No errors. |
| App\Entity\Cart | No errors. |
| App\Entity\Customers |
|
| App\Entity\Guest | No errors. |
| App\Entity\Webhostings |
|