Query Metrics
7
Database Queries
7
Different statements
11.57 ms
Query time
4
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.22 ms |
SELECT t0.id AS id_1, t0.sign AS sign_2, t0.currency_separator AS currency_separator_3, t0.position_price AS position_price_4, t0.is_default AS is_default_5, t0.is_active AS is_active_6, t0.factorPln AS factorPln_7, t0.iso_code AS iso_code_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13 FROM currency t0 WHERE t0.is_default = ? AND t0.deleted_by IS NULL LIMIT 1
Parameters:
[
1
]
|
2 | 0.48 ms |
SELECT t0.id AS id_1, t0.from_url AS from_url_2, t0.to_url AS to_url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.deleted_by AS deleted_by_8 FROM url_redirect t0 WHERE t0.deleted_by IS NULL AND t0.from_url = ? LIMIT 1
Parameters:
[
"https://ckdev.centrumkrzesel.pl/zavesna-lampa-k-4815-gold/5906/p"
]
|
3 | 0.23 ms |
SELECT t0.id AS id_1, t0.token AS token_2, t0.valid_to AS valid_to_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.deleted_by AS deleted_by_8, t0.user_id AS user_id_9 FROM fos_user_token t0 WHERE t0.deleted_by IS NULL AND t0.token IS NULL LIMIT 1
Parameters:
[] |
4 | 1.34 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.domain AS domain_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.helpline AS helpline_6, t0.rounding_precision AS rounding_precision_7, t0.phone AS phone_8, t0.address AS address_9, t0.shop_name AS shop_name_10, t0.email AS email_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.youtube AS youtube_14, t0.store_url AS store_url_15, t0.password_protected AS password_protected_16, t0.store_password AS store_password_17, t0.fb_pixel AS fb_pixel_18, t0.fb_token AS fb_token_19, t0.is_comments AS is_comments_20, t0.send_comment_request_days AS send_comment_request_days_21, t0.store_email AS store_email_22, t0.admin_store_email AS admin_store_email_23, t0.complaint_email AS complaint_email_24, t0.product_return_email AS product_return_email_25, t0.getresponse_campaign_id AS getresponse_campaign_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t0.deleted_by AS deleted_by_31, t0.currency_id AS currency_id_32 FROM language t0 WHERE t0.locale = ? AND t0.deleted_by IS NULL LIMIT 1
Parameters:
[
"pl"
]
|
5 | 8.04 ms |
SELECT p0_.listingMarkersIds AS listingMarkersIds_0, p1_.promotion_icon AS promotion_icon_1, p1_.is_new AS is_new_2, p2_.image_name AS image_name_3, p3_.image_name AS image_name_4, p1_.bestseller AS bestseller_5, p4_.id AS id_6, c5_.sign AS sign_7, c5_.id AS id_8, p1_.price_description AS price_description_9, p1_.price_crossed AS price_crossed_10, p1_.omnibus_price AS omnibus_price_11, p0_.id AS id_12, p0_.symbol AS symbol_13, p0_.photo3d AS photo3d_14, p0_.is_variants AS is_variants_15, p0_.is_palette_delivery AS is_palette_delivery_16, p0_.payu AS payu_17, p0_.automatic_price AS automatic_price_18, p0_.halmar_stock_exchange AS halmar_stock_exchange_19, p0_.diablo_stock_exchange AS diablo_stock_exchange_20, p0_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_21, p0_.actona_stock_exchange AS actona_stock_exchange_22, p0_.unique_stock_exchange AS unique_stock_exchange_23, p0_.is_compare AS is_compare_24, p0_.priority_search_engine AS priority_search_engine_25, p0_.is_negotiate AS is_negotiate_26, p0_.is_rebate_code AS is_rebate_code_27, p0_.old_price AS old_price_28, p0_.film AS film_29, p0_.small_product_photo AS small_product_photo_30, p0_.max_quantity AS max_quantity_31, p0_.listingMarkersIds AS listingMarkersIds_32, p0_.temporary_unavailable AS temporary_unavailable_33, p0_.last_ranking_update AS last_ranking_update_34, p0_.height AS height_35, p0_.width AS width_36, p0_.depth AS depth_37, p0_.shipping_category AS shipping_category_38, p0_.created_at AS created_at_39, p0_.updated_at AS updated_at_40, p0_.created_by AS created_by_41, p0_.updated_by AS updated_by_42, p0_.deleted_by AS deleted_by_43, p6_.id AS id_44, p6_.name AS name_45, p6_.description AS description_46, p6_.meta_title AS meta_title_47, p6_.meta_description AS meta_description_48, p6_.meta_keywords AS meta_keywords_49, p6_.slug AS slug_50, p6_.short_description AS short_description_51, p6_.short_description_textile AS short_description_textile_52, p6_.short_description_color AS short_description_color_53, p6_.short_function_description AS short_function_description_54, p6_.search_engine AS search_engine_55, p6_.photo3d_gallery_url AS photo3d_gallery_url_56, p6_.youtube_gallery_url AS youtube_gallery_url_57, p6_.trans_film AS trans_film_58, p6_.canonical AS canonical_59, p6_.photo3d_additional AS photo3d_additional_60, p6_.locale AS locale_61, p1_.id AS id_62, p1_.visible AS visible_63, p1_.price_description AS price_description_64, p1_.promotion AS promotion_65, p1_.is_new AS is_new_66, p1_.bestseller AS bestseller_67, p1_.promote_one_homepage AS promote_one_homepage_68, p1_.ready_for_publication AS ready_for_publication_69, p1_.sale AS sale_70, p1_.rating_value AS rating_value_71, p1_.review_count AS review_count_72, p1_.price_change AS price_change_73, p1_.priority AS priority_74, p1_.price_crossed AS price_crossed_75, p1_.omnibus_price AS omnibus_price_76, p1_.promotion_icon AS promotion_icon_77, p1_.promo_price AS promo_price_78, l7_.id AS id_79, l7_.locale AS locale_80, l7_.domain AS domain_81, l7_.is_active AS is_active_82, l7_.is_default AS is_default_83, l7_.helpline AS helpline_84, l7_.rounding_precision AS rounding_precision_85, l7_.phone AS phone_86, l7_.address AS address_87, l7_.shop_name AS shop_name_88, l7_.email AS email_89, l7_.facebook AS facebook_90, l7_.instagram AS instagram_91, l7_.youtube AS youtube_92, l7_.store_url AS store_url_93, l7_.password_protected AS password_protected_94, l7_.store_password AS store_password_95, l7_.fb_pixel AS fb_pixel_96, l7_.fb_token AS fb_token_97, l7_.is_comments AS is_comments_98, l7_.send_comment_request_days AS send_comment_request_days_99, l7_.store_email AS store_email_100, l7_.admin_store_email AS admin_store_email_101, l7_.complaint_email AS complaint_email_102, l7_.product_return_email AS product_return_email_103, l7_.getresponse_campaign_id AS getresponse_campaign_id_104, l7_.created_at AS created_at_105, l7_.updated_at AS updated_at_106, l7_.created_by AS created_by_107, l7_.updated_by AS updated_by_108, l7_.deleted_by AS deleted_by_109, c5_.id AS id_110, c5_.sign AS sign_111, c5_.currency_separator AS currency_separator_112, c5_.position_price AS position_price_113, c5_.is_default AS is_default_114, c5_.is_active AS is_active_115, c5_.factorPln AS factorPln_116, c5_.iso_code AS iso_code_117, c5_.created_at AS created_at_118, c5_.updated_at AS updated_at_119, c5_.created_by AS created_by_120, c5_.updated_by AS updated_by_121, c5_.deleted_by AS deleted_by_122, a8_.id AS id_123, a8_.is_visible AS is_visible_124, a8_.is_currentyly_unavailable AS is_currentyly_unavailable_125, a8_.days AS days_126, a8_.ceneo_days AS ceneo_days_127, a8_.internal_name AS internal_name_128, a8_.created_at AS created_at_129, a8_.updated_at AS updated_at_130, a8_.created_by AS created_by_131, a8_.updated_by AS updated_by_132, a8_.deleted_by AS deleted_by_133, a9_.id AS id_134, a9_.name AS name_135, a9_.locale AS locale_136, p10_.id AS id_137, p10_.name AS name_138, p10_.responsible_entity AS responsible_entity_139, p10_.image_name AS image_name_140, p10_.created_at AS created_at_141, p10_.updated_at AS updated_at_142, p10_.created_by AS created_by_143, p10_.updated_by AS updated_by_144, p10_.deleted_by AS deleted_by_145, p3_.id AS id_146, p3_.main AS main_147, p3_.lifestyle AS lifestyle_148, p3_.hover AS hover_149, p3_.name AS name_150, p3_.image_name AS image_name_151, p3_.position AS position_152, p3_.alt AS alt_153, p3_.image_custom_name AS image_custom_name_154, l11_.id AS id_155, l11_.locale AS locale_156, l11_.domain AS domain_157, l11_.is_active AS is_active_158, l11_.is_default AS is_default_159, l11_.helpline AS helpline_160, l11_.rounding_precision AS rounding_precision_161, l11_.phone AS phone_162, l11_.address AS address_163, l11_.shop_name AS shop_name_164, l11_.email AS email_165, l11_.facebook AS facebook_166, l11_.instagram AS instagram_167, l11_.youtube AS youtube_168, l11_.store_url AS store_url_169, l11_.password_protected AS password_protected_170, l11_.store_password AS store_password_171, l11_.fb_pixel AS fb_pixel_172, l11_.fb_token AS fb_token_173, l11_.is_comments AS is_comments_174, l11_.send_comment_request_days AS send_comment_request_days_175, l11_.store_email AS store_email_176, l11_.admin_store_email AS admin_store_email_177, l11_.complaint_email AS complaint_email_178, l11_.product_return_email AS product_return_email_179, l11_.getresponse_campaign_id AS getresponse_campaign_id_180, l11_.created_at AS created_at_181, l11_.updated_at AS updated_at_182, l11_.created_by AS created_by_183, l11_.updated_by AS updated_by_184, l11_.deleted_by AS deleted_by_185, p12_.id AS id_186, p12_.price AS price_187, p12_.discount AS discount_188, p12_.old_price AS old_price_189, p12_.active AS active_190, p12_.automatic_price_comment AS automatic_price_comment_191, p12_.ean AS ean_192, p12_.automatic_price AS automatic_price_193, p12_.automatic_price_discount AS automatic_price_discount_194, p12_.created_at AS created_at_195, p12_.updated_at AS updated_at_196, p12_.created_by AS created_by_197, p12_.updated_by AS updated_by_198, p12_.deleted_by AS deleted_by_199, p13_.id AS id_200, p13_.main AS main_201, p13_.lifestyle AS lifestyle_202, p13_.hover AS hover_203, p13_.name AS name_204, p13_.image_name AS image_name_205, p13_.position AS position_206, p13_.alt AS alt_207, p13_.image_custom_name AS image_custom_name_208, p0_.product_family_id AS product_family_id_209, p0_.product_producer_id AS product_producer_id_210, p0_.availability_id AS availability_id_211, p0_.main_category_id AS main_category_id_212, p6_.translatable_id AS translatable_id_213, p1_.product_id AS product_id_214, p1_.language AS language_215, p1_.vat_id AS vat_id_216, p1_.availability_id AS availability_id_217, p1_.product_producer_id AS product_producer_id_218, l7_.currency_id AS currency_id_219, a9_.translatable_id AS translatable_id_220, p3_.product_id AS product_id_221, l11_.currency_id AS currency_id_222, p12_.product_id AS product_id_223, p12_.parent_product_price_id AS parent_product_price_id_224, p12_.currency_id AS currency_id_225, p12_.language AS language_226, p13_.product_id AS product_id_227 FROM product p0_ INNER JOIN product_translation p6_ ON p0_.id = p6_.translatable_id INNER JOIN product_lang_param p1_ ON p0_.id = p1_.product_id INNER JOIN language l7_ ON p1_.language = l7_.id INNER JOIN product_vat p4_ ON p1_.vat_id = p4_.id INNER JOIN currency c5_ ON l7_.currency_id = c5_.id INNER JOIN availability a8_ ON p1_.availability_id = a8_.id INNER JOIN availability_translation a9_ ON a8_.id = a9_.translatable_id INNER JOIN product_producer p10_ ON p1_.product_producer_id = p10_.id INNER JOIN product_photo p3_ ON p0_.id = p3_.product_id LEFT JOIN product_photo p2_ ON p0_.id = p2_.product_id AND (p2_.lifestyle = 1) INNER JOIN product_photo_language p14_ ON p3_.id = p14_.product_photo_id INNER JOIN language l11_ ON l11_.id = p14_.language_id LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id LEFT JOIN language l15_ ON p12_.language = l15_.id LEFT JOIN product_photo p13_ ON p0_.id = p13_.product_id WHERE p6_.locale = ? AND a9_.locale = ? AND l15_.locale = ? AND a8_.deleted_by IS NULL AND (p3_.main = ?) AND l11_.locale = ? AND l7_.locale = ? AND p12_.deleted_by IS NULL AND p0_.deleted_by IS NULL AND p1_.visible = ? AND p0_.id = ? GROUP BY p13_.id ORDER BY p3_.position ASC, p13_.position ASC
Parameters:
[ "pl" "pl" "pl" 1 "pl" "pl" 1 "5906" ] |
6 | 1.01 ms |
SELECT h0_.id AS id_0, h0_.day AS day_1, h0_.nb_of_the_day AS nb_of_the_day_2, h0_.created_at AS created_at_3, h0_.updated_at AS updated_at_4, h0_.created_by AS created_by_5, h0_.updated_by AS updated_by_6, h0_.deleted_by AS deleted_by_7, h1_.id AS id_8, h1_.name AS name_9, h1_.short_name AS short_name_10, h1_.locale AS locale_11, h1_.translatable_id AS translatable_id_12 FROM helpline_hours h0_ INNER JOIN helpline_hours_translation h1_ ON h0_.id = h1_.translatable_id WHERE h1_.locale = ? AND h0_.deleted_by IS NULL AND h0_.nb_of_the_day = ?
Parameters:
[ "pl" "7" ] |
7 | 0.26 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.domain AS domain_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.helpline AS helpline_6, t0.rounding_precision AS rounding_precision_7, t0.phone AS phone_8, t0.address AS address_9, t0.shop_name AS shop_name_10, t0.email AS email_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.youtube AS youtube_14, t0.store_url AS store_url_15, t0.password_protected AS password_protected_16, t0.store_password AS store_password_17, t0.fb_pixel AS fb_pixel_18, t0.fb_token AS fb_token_19, t0.is_comments AS is_comments_20, t0.send_comment_request_days AS send_comment_request_days_21, t0.store_email AS store_email_22, t0.admin_store_email AS admin_store_email_23, t0.complaint_email AS complaint_email_24, t0.product_return_email AS product_return_email_25, t0.getresponse_campaign_id AS getresponse_campaign_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t0.deleted_by AS deleted_by_31, t0.currency_id AS currency_id_32 FROM language t0 WHERE t0.deleted_by IS NULL AND t0.locale = ? LIMIT 1
Parameters:
[
"pl"
]
|
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\PaymentMethod | No errors. |
App\Entity\DeliveryMethod | No errors. |
App\Entity\DeliveryCountry | No errors. |
App\Entity\Cart | No errors. |
App\Entity\Language | No errors. |
App\Entity\Product |
|
App\Entity\Category | No errors. |
App\Entity\ProductPrice | No errors. |
App\Entity\ProductPriceVariants | No errors. |
App\Entity\Currency | No errors. |
App\Entity\CurrencyTranslation | No errors. |
App\Entity\UrlRedirect | No errors. |
App\Entity\UserToken | No errors. |
FOS\UserBundle\Model\User | No errors. |
App\Entity\User | No errors. |
App\Entity\HelplineHours | No errors. |
App\Entity\ProductParameterValue | No errors. |
App\Entity\ProductComment |
|
App\Entity\LanguageTranslation | No errors. |
App\Entity\ProductTranslation | No errors. |
App\Entity\ProductLangParam | No errors. |
App\Entity\ProductVat | No errors. |
App\Entity\Availability | No errors. |
App\Entity\AvailabilityTranslation | No errors. |
App\Entity\ProductProducer | No errors. |
App\Entity\ProductPhoto | No errors. |
App\Entity\ProductFamily |
|
App\Entity\Marker | No errors. |
App\Entity\ProductColor | No errors. |
App\Entity\ListingMarker | No errors. |
App\Entity\ProductEquipment | No errors. |
App\Entity\SubProduct | No errors. |
App\Entity\ProductFilter | No errors. |
App\Entity\ProductPriceChangeLog | No errors. |
App\Entity\ProductPriceDraft | No errors. |
App\Entity\ProductXml | No errors. |
App\Entity\CompareParameterValue | No errors. |
App\Entity\ProductFurnitureType | No errors. |
App\Entity\ProductCategory | No errors. |
App\Entity\ProductRecommendation | No errors. |
App\Entity\ProductSimilarColors | No errors. |
App\Entity\ProductCrossSelling | No errors. |
App\Entity\LandingPage |
|
App\Entity\ProductProducerPriceChange | No errors. |
App\Entity\ProductPhotoTranslation | No errors. |
App\Entity\HelplineHoursTranslation | No errors. |