Query Metrics
4
Database Queries
3
Different statements
2.42 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.88 ms (77.92%) |
2 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.subdomain AS subdomain_3, t0.ref AS ref_4, t0.app_name AS app_name_5, t0.logo_name AS logo_name_6, t0.logo_size AS logo_size_7, t0.background_connexion_name AS background_connexion_name_8, t0.background_connexion_size AS background_connexion_size_9, t0.logo AS logo_10, t0.image_background_connexion AS image_background_connexion_11, t0.first_color AS first_color_12, t0.second_color AS second_color_13, t0.status AS status_14, t0.config AS config_15, t0.tjm_average AS tjm_average_16, t0.thm_average AS thm_average_17, t0.deleted_at AS deleted_at_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20 FROM advertiser t0 WHERE t0.subdomain = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
"stacianimation"
]
|
0.31 ms (12.82%) |
1 |
SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.description AS description_2, o0_.kit_operation AS kit_operation_3, o0_.price_type AS price_type_4, o0_.price AS price_5, o0_.main_illus_name AS main_illus_name_6, o0_.main_illus_size AS main_illus_size_7, o0_.begin_order_date AS begin_order_date_8, o0_.end_order_date AS end_order_date_9, o0_.begin_action_date AS begin_action_date_10, o0_.end_action_date AS end_action_date_11, o0_.step AS step_12, o0_.status AS status_13, o0_.auto_publish_date_start AS auto_publish_date_start_14, o0_.auto_publish_date_end AS auto_publish_date_end_15, o0_.hour_action_min_start AS hour_action_min_start_16, o0_.hour_action_max_start AS hour_action_max_start_17, o0_.hour_action_min_end AS hour_action_min_end_18, o0_.hour_action_max_end AS hour_action_max_end_19, o0_.halfday_duration AS halfday_duration_20, o0_.duration AS duration_21, o0_.duration_min AS duration_min_22, o0_.duration_type AS duration_type_23, o0_.delivery_delay AS delivery_delay_24, o0_.quota_type AS quota_type_25, o0_.config AS config_26, o0_.nb_min_action_hour_per_day AS nb_min_action_hour_per_day_27, o0_.nb_max_action_hour_per_day AS nb_max_action_hour_per_day_28, o0_.duration_consecutive AS duration_consecutive_29, o0_.duration_free AS duration_free_30, o0_.deleted_at AS deleted_at_31, o0_.created_at AS created_at_32, o0_.updated_at AS updated_at_33, o1_.is_extendable AS is_extendable_34, o1_.is_recoverable AS is_recoverable_35, o1_.is_ordeable AS is_ordeable_36, o1_.qte_product_max_per_shop AS qte_product_max_per_shop_37, o1_.is_globale AS is_globale_38, o0_.type AS type_39, o0_.quota_id AS quota_id_40, o0_.operation_type_id AS operation_type_id_41, o0_.advertiser_id AS advertiser_id_42 FROM operation_furniture o1_ INNER JOIN operation o0_ ON o1_.id = o0_.id AND (o0_.deleted_at IS NULL) WHERE o0_.status = ? AND o1_.is_globale = ? AND o0_.advertiser_id = ? ORDER BY o0_.created_at DESC LIMIT 1
Parameters:
[ 1 1 13 ] |
0.22 ms (9.26%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.headline AS headline_3, t0.header_img_name AS header_img_name_4, t0.header_img_size AS header_img_size_5, t0.header_text AS header_text_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.advertiser_id AS advertiser_id_10 FROM homepage t0 WHERE t0.advertiser_id = ? LIMIT 1
Parameters:
[
13
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
0
Hits
0
Misses
0
Puts
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Advertiser | No errors. |
App\Entity\User | No errors. |
App\Entity\QuotaItem | No errors. |
App\Entity\Agency | No errors. |
App\Entity\Attachment | No errors. |
App\Entity\ActionType | No errors. |
App\Entity\Brand | No errors. |
App\Entity\BusinessUnit | No errors. |
App\Entity\Category | No errors. |
App\Entity\Dashboard | No errors. |
App\Entity\Homepage | No errors. |
App\Entity\Deficiency | No errors. |
App\Entity\OperationFamily | No errors. |
App\Entity\Operation | No errors. |
App\Entity\OperationType | No errors. |
App\Entity\RefrigeratorBin | No errors. |
App\Entity\Page | No errors. |
App\Entity\News | No errors. |
App\Entity\PublicHoliday | No errors. |
App\Entity\Region | No errors. |
App\Entity\Role | No errors. |
App\Entity\Season | No errors. |
App\Entity\ShopClass | No errors. |
App\Entity\Shop | No errors. |
App\Entity\ShopSign | No errors. |
App\Entity\ShopType | No errors. |
App\Entity\Speaker | No errors. |
App\Entity\UserAdvertiserRole | No errors. |
App\Entity\AdvertiserRight | No errors. |
App\Entity\PolymorphicOperation\OperationFurniture | No errors. |
App\Entity\Quota | No errors. |