Query Metrics
11
Database Queries
10
Different statements
1827.77 ms
Query time
7
Invalid entities
32
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1640.80 ms (89.77%) |
2 |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.caracteristiques AS caracteristiques_4, t0.price AS price_5, t0.url AS url_6, t0.compatibility AS compatibility_7, t0.miniature AS miniature_8, t0.openai AS openai_9, t0.file AS file_10, t0.removed AS removed_11, t0.id AS id_12, t0.active AS active_13, t0.date_created AS date_created_14, t0.date_updated AS date_updated_15, t0.manufacturer_id AS manufacturer_id_16, t0.main_category_id AS main_category_id_17, t0.user_id AS user_id_18 FROM modules t0 WHERE t0.slug = ? AND t0.active = ? LIMIT 1
Parameters:
[ "websource-indexnow-module-dindexation-sur-les-moteurs-de-recheche" 1 ] |
|
113.80 ms (6.23%) |
1 |
SELECT t0.type AS type_1, t0.value AS value_2, t0.position AS position_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.module_id AS module_id_8 FROM medias t0 WHERE t0.module_id = ? ORDER BY t0.position ASC
Parameters:
[
4185
]
|
|
22.00 ms (1.20%) |
1 |
SELECT t0.name AS name_1, t0.commentaire AS commentaire_2, t0.note AS note_3, t0.firstname AS firstname_4, t0.company AS company_5, t0.image AS image_6, t0.lastname AS lastname_7, t0.email AS email_8, t0.id AS id_9, t0.active AS active_10, t0.date_created AS date_created_11, t0.date_updated AS date_updated_12, t0.module_id AS module_id_13, t0.theme_id AS theme_id_14 FROM reviews t0 WHERE t0.module_id = ?
Parameters:
[
4185
]
|
|
15.38 ms (0.84%) |
1 |
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 WHERE t0.id = ?
Parameters:
[
98
]
|
|
11.20 ms (0.61%) |
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
]
|
|
7.02 ms (0.38%) |
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.id = ?
Parameters:
[
118
]
|
|
6.55 ms (0.36%) |
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_module"
]
|
|
5.59 ms (0.31%) |
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 ] |
|
4.22 ms (0.23%) |
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
]
|
|
1.20 ms (0.07%) |
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 ] |
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\Categories | 13 |
| App\Entity\ThemesCategories | 9 |
| App\Entity\Medias | 4 |
| App\Entity\WebhostingsOffers | 3 |
| App\Entity\Modules | 1 |
| App\Entity\Manufacturer | 1 |
| App\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Modules |
|
| App\Entity\Manufacturer | No errors. |
| App\Entity\Categories | No errors. |
| App\Entity\User |
|
| App\Entity\Medias | No errors. |
| App\Entity\Caracteristics | No errors. |
| App\Entity\Reviews |
|
| App\Entity\CartDetails | No errors. |
| App\Entity\Downloads | No errors. |
| App\Entity\ThemesCategories |
|
| App\Entity\WebhostingsOffers | No errors. |
| App\Entity\Faq | No errors. |
| App\Entity\Themes |
|
| App\Entity\Cart | No errors. |
| App\Entity\Customers |
|
| App\Entity\Guest | No errors. |
| App\Entity\Webhostings |
|