Query Metrics
6
Database Queries
6
Different statements
12.70 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.72 ms |
SELECT a0_.`id` AS id_0, b1_.`amount` AS amount_1, b2_.`name` AS name_2, b2_.`status` AS status_3, b2_.`bank_transfer_requested` AS bank_transfer_requested_4 FROM `buy_order` b2_ LEFT JOIN `buy_order_article` b1_ ON b2_.id = b1_.buy_order_id LEFT JOIN `article` a0_ ON b1_.article_id = a0_.id WHERE b2_.`status` IN (1, 2, 3) AND a0_.`id` <> '' AND b2_.`token` = ? AND b2_.`status` <> 12 AND a0_.collection = ? ORDER BY b1_.`amount` DESC
Parameters:
[ "63e071214979e12cbafecdb31469e1b65338958d17d0ee507396a4a3d31a9363" 3249332 ] |
| 2 | 0.15 ms |
SELECT a.id FROM article a LEFT JOIN list_type lt ON a.type = lt.id LEFT JOIN list_delivery ld ON a.delivery = ld.id LEFT JOIN list_measure lms ON a.measure = lms.id LEFT JOIN list_material lmt ON a.material = lmt.id LEFT JOIN list_surface lsf ON a.surface = lsf.id LEFT JOIN article_price_discount apd ON a.id = apd.article AND apd.price_usd > 0 LEFT JOIN article_color ac ON a.id = ac.article_id LEFT JOIN article_factory_color afc ON a.id = afc.article_id LEFT JOIN list_factory_color lfc ON lfc.id = afc.factory_color_id LEFT JOIN article_texture at ON a.id = at.article_id LEFT JOIN list_texture ltx ON ltx.id = at.texture_id LEFT JOIN list_style ls ON a.style = ls.id LEFT JOIN list_color lc ON lc.id = ac.color_id LEFT JOIN collection acl ON acl.id = a.collection LEFT JOIN factory acf ON acf.id = acl.factory LEFT JOIN list_country lcnt ON lcnt.id = acf.country LEFT JOIN article_motiv alm ON a.id = alm.article_id LEFT JOIN list_motiv llm ON llm.id = alm.motiv_id LEFT JOIN list_shape lsh ON lsh.id = a.shape LEFT JOIN article_detail ad ON ad.article_id = a.id WHERE a.collection IS NOT NULL AND (a.price_euro > 0 OR ld.id = 6) AND ld.id <> 6 AND ad.file IS NOT NULL AND a.collection = '3249332' GROUP BY a.id ORDER BY lfc.name ASC, lt.sort DESC, a.size_x DESC, a.size_y DESC, apd.price_euro DESC, apd.amount DESC, a.scheme ASC, lc.id, lms.id, a.thick, a.id DESC LIMIT 20 OFFSET 0
Parameters:
[] |
| 3 | 8.28 ms |
SELECT a.id, a.code, a.name, a.not_sample, a.alternate_name, REPLACE(a.file, "~q~", "'") AS FILE, a.express_sample, a.variant_image, a.size_x, a.size_y, a.size_z, a.file_size2_x, a.file_size2_y, a.file_size3_x, a.file_size3_y, a.file_size8_x, a.file_size8_y, a.type_constraint, a.packaging_count, a.packaging_count_ft, a.packaging_count_pc, a.price_prx, a.pallet, a.pallet_ft, a.min_order, a.m2one_ps, a.multiple_pallet, a.urla, a.background_white, a.border_grey, a.image_setting, a.file_w, a.file_h, a.file_w4000, a.file_h4000, a.scheme, a.rotate, a.file_rotation, a.file_edit, a.comment_scheme_image, a.description_en, ad.id AS ad_id, ad.file AS ad_file, ad.picture_in_title AS ad_picture_in_title, ad.gtin AS ad_gtin, ad.file_size1_x AS ad_file_size1_x, ad.file_size1_y AS ad_file_size1_y, ad.file_size2_x AS ad_file_size2_x, ad.file_size2_y AS ad_file_size2_y, ad.file_size3_x AS ad_file_size3_x, ad.file_size3_y AS ad_file_size3_y, ad.file_size8_x AS ad_file_size8_x, ad.file_size8_y AS ad_file_size8_y, ad.file_size500_x AS ad_file_size500_x, ad.file_size500_y AS ad_file_size500_y, ad.file_size740_x AS ad_file_size740_x, ad.file_size740_y AS ad_file_size740_y, ad.file_size1_x AS ad_file_size1_x, ad.file_size1_y AS ad_file_size1_y, ad.description_en AS ad_description_en, ad.comment AS ad_comment, ad.file_edit AS ad_file_edit, ad.image_setting AS ad_image_setting, ad.file_w AS ad_file_w, ad.file_h AS ad_file_h, ad.file_w4000 AS ad_file_w4000, ad.file_h4000 AS ad_file_h4000, ad.comment_scheme_image AS ad_comment_scheme_image, ad.variant_image AS ad_variant_image, ad.file_rotation AS ad_file_rotation, ad.rotate AS ad_rotate, ad.type_painting AS ad_type_painting, ad.big_size_scheme AS ad_big_size_scheme, ld.id AS ld_id, lt.id AS lt_id, lt.alias AS lt_alias, lt.name AS lt_name, lms.id AS lms_id, lms.alias AS lms_alias, lms.name AS lms_name, lmt.id AS lmt_id, lmt.alias AS lmt_alias, lmt.name AS lmt_name, lsf.id AS lsf_id, lsf.alias AS lsf_alias, lsf.name AS lsf_name, lfc.id AS lfc_id, ltx.id AS ltx_id, ltx.alias AS ltx_alias, ltx.name AS ltx_name, ls.id AS ls_id, ls.alias AS ls_alias, ls.name AS ls_name, lsh.id AS lsh_id, lsh.alias AS lsh_alias, lsh.name AS lsh_name, llm.id AS llm_id, llm.alias AS llm_alias, llm.name AS llm_name, lmss.id AS lmss_id, lmss.alias AS lmss_alias, apd.id AS apd_id, apd.amount AS apd_amount, apd.amount_ft AS apd_amount_ft, apd.fold AS apd_fold, acl.id AS acl_id, acl.url AS acl_url, acl.name AS acl_name, acl.alternate_name AS acl_aname, acl.status AS acl_status, acl.process AS acl_process, acl.settings AS acl_settings, acf.id AS acf_id, acf.url AS acf_url, acf.name AS acf_name, acf.alternate_name AS acf_aname, acf.status AS acf_status, acf.suspended AS acf_suspended, acf.stated_at AS acf_stated_at, a.price_dkk AS a_price_dkk, a.price_mq_dkk AS a_price_mq_dkk, a.price_dke AS a_price_dke, a.price_mq_dke AS a_price_mq_dke, apd.price_dkk AS apd_price_dkk, apd.price_dke AS apd_price_dke, acl.pr_min_dkk AS acl_pr_min_dkk, acl.pr_min_dke AS acl_pr_min_dke, lcnt.id AS lcnt_id, lcnt.code AS lcnt_code, lcnt.alias AS lcnt_alias, lc.id AS lc_id, lc.name AS lc_name, lc.alias AS lc_alias FROM article a LEFT JOIN list_type lt ON a.type = lt.id LEFT JOIN list_delivery ld ON a.delivery = ld.id LEFT JOIN list_measure lms ON a.measure = lms.id LEFT JOIN list_material lmt ON a.material = lmt.id LEFT JOIN list_surface lsf ON a.surface = lsf.id LEFT JOIN article_price_discount apd ON a.id = apd.article AND apd.price_usd > 0 LEFT JOIN article_color ac ON a.id = ac.article_id LEFT JOIN list_color lc ON lc.id = ac.color_id LEFT JOIN article_factory_color afc ON a.id = afc.article_id LEFT JOIN list_factory_color lfc ON lfc.id = afc.factory_color_id LEFT JOIN article_texture at ON a.id = at.article_id LEFT JOIN list_texture ltx ON ltx.id = at.texture_id LEFT JOIN list_style ls ON a.style = ls.id LEFT JOIN collection acl ON acl.id = a.collection LEFT JOIN factory acf ON acf.id = acl.factory LEFT JOIN list_country lcnt ON lcnt.id = acf.country LEFT JOIN article_motiv alm ON a.id = alm.article_id LEFT JOIN list_motiv llm ON llm.id = alm.motiv_id LEFT JOIN list_shape lsh ON lsh.id = a.shape LEFT JOIN list_measure_size lmss ON a.measurement_size = lmss.id LEFT JOIN article_detail ad ON ad.article_id = a.id WHERE a.collection IS NOT NULL AND (a.price_euro > 0 OR a.delivery = 6) AND ld.id <> 6 AND ad.file IS NOT NULL AND a.collection = '3249332' AND a.id IN ('504275517','504275717','504275893','504275723','504275451','504275649','504275780','504275539','504275529','504275829','504275411','504275754','504275832','504275759','504275881','504275874','504275796','504275790','504275618','504275607') ORDER BY lfc.name ASC, lt.sort DESC, a.size_x DESC, a.size_y DESC, apd.price_euro DESC, apd.amount DESC, a.scheme ASC, lc.id, lms.id, a.thick, a.id DESC
Parameters:
[] |
| 4 | 0.19 ms |
SELECT t0.`id` AS id_1, t0.`currency` AS currency_2, t0.`val` AS val_3 FROM `currency_rate` t0 WHERE t0.`currency` = ? LIMIT 1
Parameters:
[
"DKK"
]
|
| 5 | 0.17 ms |
SELECT a.id FROM article a LEFT JOIN list_type lt ON a.type = lt.id LEFT JOIN list_delivery ld ON a.delivery = ld.id LEFT JOIN list_measure lms ON a.measure = lms.id LEFT JOIN list_material lmt ON a.material = lmt.id LEFT JOIN list_surface lsf ON a.surface = lsf.id LEFT JOIN article_price_discount apd ON a.id = apd.article AND apd.price_usd > 0 LEFT JOIN article_color ac ON a.id = ac.article_id LEFT JOIN article_factory_color afc ON a.id = afc.article_id LEFT JOIN list_factory_color lfc ON lfc.id = afc.factory_color_id LEFT JOIN article_texture at ON a.id = at.article_id LEFT JOIN list_texture ltx ON ltx.id = at.texture_id LEFT JOIN list_style ls ON a.style = ls.id LEFT JOIN list_color lc ON lc.id = ac.color_id LEFT JOIN collection acl ON acl.id = a.collection LEFT JOIN factory acf ON acf.id = acl.factory LEFT JOIN list_country lcnt ON lcnt.id = acf.country LEFT JOIN article_motiv alm ON a.id = alm.article_id LEFT JOIN list_motiv llm ON llm.id = alm.motiv_id LEFT JOIN list_shape lsh ON lsh.id = a.shape LEFT JOIN article_detail ad ON ad.article_id = a.id WHERE a.collection IS NOT NULL AND (a.price_euro > 0 OR ld.id = 6) AND ld.id <> 6 AND ad.file IS NOT NULL AND a.collection = '3249332' GROUP BY a.id ORDER BY lfc.name ASC, lt.sort DESC, a.size_x DESC, a.size_y DESC, apd.price_euro DESC, apd.amount DESC, a.scheme ASC, lc.id, lms.id, a.thick, a.id DESC LIMIT 1 OFFSET 0
Parameters:
[] |
| 6 | 2.19 ms |
SELECT a.id, a.code, a.name, a.not_sample, a.alternate_name, REPLACE(a.file, "~q~", "'") AS FILE, a.express_sample, a.variant_image, a.size_x, a.size_y, a.size_z, a.file_size2_x, a.file_size2_y, a.file_size3_x, a.file_size3_y, a.file_size8_x, a.file_size8_y, a.type_constraint, a.packaging_count, a.packaging_count_ft, a.packaging_count_pc, a.price_prx, a.pallet, a.pallet_ft, a.min_order, a.m2one_ps, a.multiple_pallet, a.urla, a.background_white, a.border_grey, a.image_setting, a.file_w, a.file_h, a.file_w4000, a.file_h4000, a.scheme, a.rotate, a.file_rotation, a.file_edit, a.comment_scheme_image, a.description_en, ad.id AS ad_id, ad.file AS ad_file, ad.picture_in_title AS ad_picture_in_title, ad.gtin AS ad_gtin, ad.file_size1_x AS ad_file_size1_x, ad.file_size1_y AS ad_file_size1_y, ad.file_size2_x AS ad_file_size2_x, ad.file_size2_y AS ad_file_size2_y, ad.file_size3_x AS ad_file_size3_x, ad.file_size3_y AS ad_file_size3_y, ad.file_size8_x AS ad_file_size8_x, ad.file_size8_y AS ad_file_size8_y, ad.file_size500_x AS ad_file_size500_x, ad.file_size500_y AS ad_file_size500_y, ad.file_size740_x AS ad_file_size740_x, ad.file_size740_y AS ad_file_size740_y, ad.file_size1_x AS ad_file_size1_x, ad.file_size1_y AS ad_file_size1_y, ad.description_en AS ad_description_en, ad.comment AS ad_comment, ad.file_edit AS ad_file_edit, ad.image_setting AS ad_image_setting, ad.file_w AS ad_file_w, ad.file_h AS ad_file_h, ad.file_w4000 AS ad_file_w4000, ad.file_h4000 AS ad_file_h4000, ad.comment_scheme_image AS ad_comment_scheme_image, ad.variant_image AS ad_variant_image, ad.file_rotation AS ad_file_rotation, ad.rotate AS ad_rotate, ad.type_painting AS ad_type_painting, ad.big_size_scheme AS ad_big_size_scheme, ld.id AS ld_id, lt.id AS lt_id, lt.alias AS lt_alias, lt.name AS lt_name, lms.id AS lms_id, lms.alias AS lms_alias, lms.name AS lms_name, lmt.id AS lmt_id, lmt.alias AS lmt_alias, lmt.name AS lmt_name, lsf.id AS lsf_id, lsf.alias AS lsf_alias, lsf.name AS lsf_name, lfc.id AS lfc_id, ltx.id AS ltx_id, ltx.alias AS ltx_alias, ltx.name AS ltx_name, ls.id AS ls_id, ls.alias AS ls_alias, ls.name AS ls_name, lsh.id AS lsh_id, lsh.alias AS lsh_alias, lsh.name AS lsh_name, llm.id AS llm_id, llm.alias AS llm_alias, llm.name AS llm_name, lmss.id AS lmss_id, lmss.alias AS lmss_alias, apd.id AS apd_id, apd.amount AS apd_amount, apd.amount_ft AS apd_amount_ft, apd.fold AS apd_fold, acl.id AS acl_id, acl.url AS acl_url, acl.name AS acl_name, acl.alternate_name AS acl_aname, acl.status AS acl_status, acl.process AS acl_process, acl.settings AS acl_settings, acf.id AS acf_id, acf.url AS acf_url, acf.name AS acf_name, acf.alternate_name AS acf_aname, acf.status AS acf_status, acf.suspended AS acf_suspended, acf.stated_at AS acf_stated_at, a.price_dkk AS a_price_dkk, a.price_mq_dkk AS a_price_mq_dkk, a.price_dke AS a_price_dke, a.price_mq_dke AS a_price_mq_dke, apd.price_dkk AS apd_price_dkk, apd.price_dke AS apd_price_dke, acl.pr_min_dkk AS acl_pr_min_dkk, acl.pr_min_dke AS acl_pr_min_dke, lcnt.id AS lcnt_id, lcnt.code AS lcnt_code, lcnt.alias AS lcnt_alias, lc.id AS lc_id, lc.name AS lc_name, lc.alias AS lc_alias FROM article a LEFT JOIN list_type lt ON a.type = lt.id LEFT JOIN list_delivery ld ON a.delivery = ld.id LEFT JOIN list_measure lms ON a.measure = lms.id LEFT JOIN list_material lmt ON a.material = lmt.id LEFT JOIN list_surface lsf ON a.surface = lsf.id LEFT JOIN article_price_discount apd ON a.id = apd.article AND apd.price_usd > 0 LEFT JOIN article_color ac ON a.id = ac.article_id LEFT JOIN list_color lc ON lc.id = ac.color_id LEFT JOIN article_factory_color afc ON a.id = afc.article_id LEFT JOIN list_factory_color lfc ON lfc.id = afc.factory_color_id LEFT JOIN article_texture at ON a.id = at.article_id LEFT JOIN list_texture ltx ON ltx.id = at.texture_id LEFT JOIN list_style ls ON a.style = ls.id LEFT JOIN collection acl ON acl.id = a.collection LEFT JOIN factory acf ON acf.id = acl.factory LEFT JOIN list_country lcnt ON lcnt.id = acf.country LEFT JOIN article_motiv alm ON a.id = alm.article_id LEFT JOIN list_motiv llm ON llm.id = alm.motiv_id LEFT JOIN list_shape lsh ON lsh.id = a.shape LEFT JOIN list_measure_size lmss ON a.measurement_size = lmss.id LEFT JOIN article_detail ad ON ad.article_id = a.id WHERE a.collection IS NOT NULL AND (a.price_euro > 0 OR a.delivery = 6) AND ld.id <> 6 AND ad.file IS NOT NULL AND a.collection = '3249332' AND a.id IN ('504275517') ORDER BY lfc.name ASC, lt.sort DESC, a.size_x DESC, a.size_y DESC, apd.price_euro DESC, apd.amount DESC, a.scheme ASC, lc.id, lms.id, a.thick, a.id DESC
Parameters:
[] |
oneC connection
No database queries were performed.
logs connection
No database queries were performed.
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| oneC | doctrine.dbal.oneC_connection |
| logs | doctrine.dbal.logs_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| oneC | doctrine.orm.oneC_entity_manager |
| logs | doctrine.orm.logs_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| WebBundle\Entity\User | No errors. |
| WebBundle\Entity\Article | No errors. |
| WebBundle\Entity\BuyOrder | No errors. |
| WebBundle\Entity\FilterEntity | No errors. |
| WebBundle\Entity\Idea | No errors. |
| WebBundle\Entity\Interior | No errors. |
| WebBundle\Entity\Publication | No errors. |
| WebBundle\Entity\Visit | No errors. |
| WebBundle\Entity\LastUrlEntity | No errors. |
| WebBundle\Entity\Collection | No errors. |
| WebBundle\Entity\ProductReviewsCache | No errors. |
| WebBundle\Entity\ReviewsCache | No errors. |
| WebBundle\Entity\ListCountry | No errors. |
| WebBundle\Entity\Factory | No errors. |
| WebBundle\Entity\CollectionAlsoViewed | No errors. |
| WebBundle\Entity\InteriorHistory | No errors. |
| FlexApp\Entity\ChatB | No errors. |
| FlexApp\Entity\ChatBMessage | No errors. |
| FlexApp\Entity\BoolDBSetting | No errors. |
| FlexApp\Entity\Widget | No errors. |
| FlexApp\Entity\CountryAndLangSpecificDataEntity | No errors. |
| FlexApp\Entity\ConsultantEntity | No errors. |
| WebBundle\Entity\ArticleDetail | No errors. |
| WebBundle\Entity\ListDelivery | No errors. |
| WebBundle\Entity\ListMeasure | No errors. |
| WebBundle\Entity\ListMaterial | No errors. |
| WebBundle\Entity\ArticlePriceDiscount | No errors. |
| WebBundle\Entity\ListFactoryColor | No errors. |
| WebBundle\Entity\ListTexture | No errors. |
| WebBundle\Entity\ListStyle | No errors. |
| WebBundle\Entity\ListSurface | No errors. |
| WebBundle\Entity\ListType | No errors. |
| WebBundle\Entity\ListMotiv | No errors. |
| WebBundle\Entity\ListShape | No errors. |
| WebBundle\Entity\ListMeasureSize | No errors. |
| WebBundle\Entity\ListColor | No errors. |
| WebBundle\Entity\CurrencyRate | No errors. |
| FlexApp\Entity\GeoCountryEntity | No errors. |
oneC entity manager
No loaded entities.
logs entity manager
No loaded entities.