Query Metrics
10
Database Queries
7
Different statements
4.64 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1.27 ms (27.33%) |
4 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.long_description AS long_description_5, t0.is_active AS is_active_6, t0.type AS type_7 FROM page t0 WHERE t0.is_active = ? AND t0.type = ? ORDER BY t0.id ASC
Parameters:
[ 1 1 ]
|
||||||||||||||||||||
1.09 ms (23.61%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.contract_number AS contract_number_4, t0.title_tag AS title_tag_5, t0.keywords AS keywords_6, t0.meta_description AS meta_description_7, t0.newsletter_title AS newsletter_title_8, t0.newsletter_description AS newsletter_description_9, t0.available_from AS available_from_10, t0.available_to AS available_to_11, t0.usable_until AS usable_until_12, t0.reset_countdown_days AS reset_countdown_days_13, t0.public_coupon_display AS public_coupon_display_14, t0.gender AS gender_15, t0.expire_date_visible AS expire_date_visible_16, t0.require_check_availability AS require_check_availability_17, t0.description AS description_18, t0.text AS text_19, t0.image AS image_20, t0.active AS active_21, t0.super_price AS super_price_22, t0.exclusive AS exclusive_23, t0.kupime_id AS kupime_id_24, t0.sub_title AS sub_title_25, t0.full_price AS full_price_26, t0.discounted_price AS discounted_price_27, t0.discount_percentage AS discount_percentage_28, t0.saving_price AS saving_price_29, t0.offer_includes AS offer_includes_30, t0.offer_usage AS offer_usage_31, t0.offer_note AS offer_note_32, t0.offer_location AS offer_location_33, t0.ad_guid AS ad_guid_34, t0.user_id AS user_id_35, t0.company_id AS company_id_36, t0.single_partner_id AS single_partner_id_37 FROM offer t0 WHERE t0.url = ? AND t0.id = ? LIMIT 1
Parameters:
[ "mezoterapija-lica" "627" ]
|
||||||||||||||||||||
1.06 ms (22.82%) |
1 |
SELECT t0.id AS id_1, t0.path AS path_2, t0.created AS created_3, t0.old_filename AS old_filename_4, t0.kupime_id AS kupime_id_5, t0.offer_id AS offer_id_6 FROM offer_image t0 WHERE t0.kupime_id = ? ORDER BY t0.id ASC LIMIT 20
Parameters:
[
102635
]
|
||||||||||||||||||||
0.42 ms (9.07%) |
1 |
SELECT t0.id AS id_1, t0.price AS price_2, t0.sequence AS sequence_3, t0.title AS title_4, t0.full_price AS full_price_5, t0.price_before_discount AS price_before_discount_6, t0.discount AS discount_7, t0.our_fee AS our_fee_8, t0.vat AS vat_9, t0.quantity AS quantity_10, t0.max_coupons_per_user AS max_coupons_per_user_11, t0.sold AS sold_12, t0.active AS active_13, t0.saving AS saving_14, t0.offer_id AS offer_id_15 FROM offer_price t0 WHERE t0.offer_id = ? ORDER BY t0.sequence ASC
Parameters:
[
627
]
|
||||||||||||||||||||
0.31 ms (6.62%) |
1 |
SELECT t0.id AS id_1, t0.price AS price_2, t0.sequence AS sequence_3, t0.title AS title_4, t0.full_price AS full_price_5, t0.price_before_discount AS price_before_discount_6, t0.discount AS discount_7, t0.our_fee AS our_fee_8, t0.vat AS vat_9, t0.quantity AS quantity_10, t0.max_coupons_per_user AS max_coupons_per_user_11, t0.sold AS sold_12, t0.active AS active_13, t0.saving AS saving_14, t0.offer_id AS offer_id_15 FROM offer_price t0 WHERE t0.offer_id = ?
Parameters:
[
627
]
|
||||||||||||||||||||
0.26 ms (5.54%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.pin AS pin_4, t0.phone AS phone_5, t0.email AS email_6, t0.created AS created_7, t0.iban AS iban_8, t0.payment_model AS payment_model_9 FROM company t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||
0.23 ms (5.01%) |
1 |
SELECT t0.id AS id_1, t0.path AS path_2, t0.created AS created_3, t0.old_filename AS old_filename_4, t0.kupime_id AS kupime_id_5, t0.offer_id AS offer_id_6 FROM offer_image t0 WHERE t0.offer_id = ?
Parameters:
[
627
]
|
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Offer\Offer | No errors. |
App\Entity\User | No errors. |
App\Entity\Company\Company | No errors. |
App\Entity\Partner\Partner | No errors. |
App\Entity\Offer\OfferImage | No errors. |
App\Entity\Offer\OfferPrice | No errors. |
App\Entity\Category\Category | No errors. |
App\Entity\Offer\OfferLocation | No errors. |
App\Entity\Offer\OfferDocument | No errors. |
App\Entity\Offer\OfferActivity | No errors. |
App\Entity\Offer\OfferItem | No errors. |
App\Entity\Offer\OfferNotice | No errors. |
App\Entity\Orders\OrderItem | No errors. |
App\Entity\Offer\OfferCoupon | No errors. |
App\Entity\Page\Page | No errors. |
App\Entity\Role | No errors. |
App\Entity\Orders\Orders | No errors. |
App\Entity\Partner\PartnerLocation | No errors. |
App\Entity\City | No errors. |
App\Entity\Offer\OfferCouponStatus | No errors. |
App\Entity\Orders\OrderTransaction | No errors. |
App\Entity\Orders\OrderStatus | No errors. |
App\Entity\Orders\PaymentType | No errors. |