Query Metrics
11
Database Queries
11
Different statements
15.73 ms
Query time
7
Invalid entities
28
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
10.38 ms (66.01%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.69 ms (4.42%) |
1 |
SELECT t0.title AS title_1, t0.content AS content_2, t0.url AS url_3, t0.slug AS slug_4, t0.date_publication AS date_publication_5, t0.image AS image_6, t0.count AS count_7, t0.meta_description AS meta_description_8, t0.id AS id_9, t0.date_created AS date_created_10, t0.date_updated AS date_updated_11, t0.active AS active_12, t0.user_id AS user_id_13, t0.category_id AS category_id_14 FROM blog_posts t0 WHERE t0.slug = ? AND t0.active = ? LIMIT 1
Parameters:
[ "shopify-comment-ca-fonctionne-et-a-quoi-ca-sert-pour-votre-e-commerce" 1 ] |
|
0.63 ms (3.99%) |
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 ] |
|
0.62 ms (3.97%) |
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
]
|
|
0.56 ms (3.55%) |
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 blog_categories t0 WHERE t0.id = ?
Parameters:
[
7
]
|
|
0.55 ms (3.52%) |
1 |
UPDATE blog_posts SET count = ? WHERE id = ?
Parameters:
[ 38 5434 ] |
|
0.54 ms (3.45%) |
1 |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.id AS id_3, t0.date_created AS date_created_4, t0.date_updated AS date_updated_5, t0.active AS active_6, t0.definition_id AS definition_id_7 FROM tags t0 INNER JOIN blog_posts_tags ON t0.id = blog_posts_tags.tags_id WHERE blog_posts_tags.blog_posts_id = ?
Parameters:
[
5434
]
|
|
0.52 ms (3.29%) |
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 ] |
|
0.48 ms (3.06%) |
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:
[
"blog_post"
]
|
|
0.42 ms (2.68%) |
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
]
|
|
0.32 ms (2.06%) |
1 |
"START TRANSACTION"
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\Categories | 13 |
| App\Entity\ThemesCategories | 9 |
| App\Entity\WebhostingsOffers | 3 |
| App\Entity\BlogCategories | 2 |
| App\Entity\BlogPosts | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\BlogPosts |
|
| App\Entity\User |
|
| App\Entity\BlogCategories | No errors. |
| App\Entity\Tags | No errors. |
| App\Entity\Categories | No errors. |
| App\Entity\ThemesCategories |
|
| App\Entity\WebhostingsOffers | No errors. |
| App\Entity\Faq | No errors. |
| App\Entity\Modules |
|
| App\Entity\Themes |
|
| App\Entity\Cart | No errors. |
| App\Entity\Customers |
|
| App\Entity\Guest | No errors. |
| App\Entity\Webhostings |
|
| App\Entity\Definitions | No errors. |