Query Metrics
3
Database Queries
3
Different statements
1.75 ms
Query time
0
Invalid entities
6
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.62 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.url_link AS url_link_4, t0.description AS description_5, t0.image_path AS image_path_6, t0.cover_path AS cover_path_7, t0.campaign_points_per_read AS campaign_points_per_read_8, t0.primigena_points_per_read AS primigena_points_per_read_9, t0.max_num_of_reads_per_user AS max_num_of_reads_per_user_10, t0.status AS status_11, t0.is_ean_campaign AS is_ean_campaign_12, t0.is_product_campaign AS is_product_campaign_13, t0.has_receipt AS has_receipt_14, t0.iqb_code_id AS iqb_code_id_15, t0.algorithm_id AS algorithm_id_16, t0.campaign_type_id AS campaign_type_id_17, t0.brand_id AS brand_id_18 FROM prim_campaign t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"9"
]
|
| 2 | 0.42 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.num_of_winners AS num_of_winners_3, t0.points_per_read AS points_per_read_4, t0.primigena_points_per_read AS primigena_points_per_read_5, t0.image_path AS image_path_6, t0.campaign_id AS campaign_id_7 FROM prim_campaign_prize t0 WHERE t0.campaign_id = ?
Parameters:
[
"9"
]
|
| 3 | 0.71 ms |
SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.value AS value_2, p0_.rfid AS rfid_3, p0_.json_msg AS json_msg_4, p0_.creation_date AS creation_date_5, p0_.gs1_value AS gs1_value_6, p0_.in_stock AS in_stock_7, p0_.iqb_code_id AS iqb_code_id_8, p0_.iqc_code_id AS iqc_code_id_9, p0_.box_id AS box_id_10, p0_.pallet_id AS pallet_id_11, p0_.transfer_entrance_id AS transfer_entrance_id_12, p0_.transfer_exit_id AS transfer_exit_id_13 FROM prim_iqp_code p0_ LEFT JOIN prim_campaign_ticket p1_ ON p0_.id = p1_.iqp_code_id WHERE p1_.campaign_id = ? AND p1_.prize_id IN (?, ?) ORDER BY p1_.prize_id ASC
Parameters:
[ "9" "12" "13" ] |
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\Campaign\Prize | 2 |
| App\Entity\Campaign\Campaign | 1 |
| App\Entity\Campaign\Algorithm | 1 |
| App\Entity\Campaign\CampaignType | 1 |
| App\Entity\Brand | 1 |