Symfony Profiler

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783779978THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('site_domain_e34509b687d7a81c32054a0c1279e2cf');

SELECTobject_localized_cs_product_hu_HU.idasid,object_localized_cs_product_hu_HU.typeas`type`FROMobject_localized_cs_product_hu_HUWHERE
  (
    idNOTIN (?)
    ANDseries=?ANDobject_localized_cs_product_hu_HU.typeIN ('object','variant','folder')
  )
  ANDobject_localized_cs_product_hu_HU.published=1ORDER BY`creationDate`DESCLIMIT5

SELECTobject_localized_cs_product_hu_HU.idasid,object_localized_cs_product_hu_HU.typeas`type`FROMobject_localized_cs_product_hu_HUWHERE (idNOTIN (3871) ANDseries='Seiko 2017 Vol. 1 - Presage 12'ANDobject_localized_cs_product_hu_HU.typeIN ('object','variant','folder')) ANDobject_localized_cs_product_hu_HU.published=1ORDER BY`creationDate`DESCLIMIT5;

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783779978THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','sitetags');

SELECTDISTINCTc0_.isoCodeASisoCode_0,c0_.nameASname_1,c0_.numericIsoCodeASnumericIsoCode_2,c0_.symbolASsymbol_3,c0_.creationDateAScreationDate_4,c0_.modificationDateASmodificationDate_5,c0_.idASid_6FROMcoreshop_currencyc0_LEFT JOINcoreshop_countryc1_ONc0_.id=c1_.currencyIdINNER JOINcoreshop_store_countriesc3_ONc1_.id=c3_.country_idINNER JOINcoreshop_storec2_ONc2_.id=c3_.store_idWHEREc1_.active=1ANDc2_.id=?

SELECTDISTINCTc0_.isoCodeASisoCode_0,c0_.nameASname_1,c0_.numericIsoCodeASnumericIsoCode_2,c0_.symbolASsymbol_3,c0_.creationDateAScreationDate_4,c0_.modificationDateASmodificationDate_5,c0_.idASid_6FROMcoreshop_currencyc0_LEFT JOINcoreshop_countryc1_ONc0_.id=c1_.currencyIdINNER JOINcoreshop_store_countriesc3_ONc1_.id=c3_.country_idINNER JOINcoreshop_storec2_ONc2_.id=c3_.store_idWHEREc1_.active=1ANDc2_.id=1;

SELECT*FROMobject_relations_cs_productWHEREsrc_id=?

SELECT*FROMobject_relations_cs_productWHEREsrc_id=3871;

SELECT*FROMredirectsWHERE
  (
    (
      source=?AND (
        `type`=?OR`type`=?
      )
    )
    OR (
      source=?AND`type`=?
    )
    OR (
      source=?AND`type`=?
    )
  )
  ANDactive=1AND (
    regexISNULLORregex=0
  )
  AND (
    expiry>UNIX_TIMESTAMP()
    ORexpiryISNULL
  )
  ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC

SELECT*FROMredirectsWHERE
            (
                (source='/ora/SRPB46J1'AND (`type`='path'OR`type`='auto_create')) OR
                (source='/ora/SRPB46J1'AND`type`='path_query') OR
                (source='https://www.project.local.szerver.online/ora/SRPB46J1'AND`type`='entire_uri')
            ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC;

SELECTobject_localized_cs_product_hu_HU.idasid,object_localized_cs_product_hu_HU.typeas`type`FROMobject_localized_cs_product_hu_HUWHERE
  (
    idNOTIN (?,?,?,?)
    ANDsubcollection=?ANDobject_localized_cs_product_hu_HU.typeIN ('object','variant','folder')
  )
  ANDobject_localized_cs_product_hu_HU.published=1ORDER BY`creationDate`DESCLIMIT2

SELECTobject_localized_cs_product_hu_HU.idasid,object_localized_cs_product_hu_HU.typeas`type`FROMobject_localized_cs_product_hu_HUWHERE (idNOTIN (3871,4204,3892,2630) ANDsubcollection='Cocktail'ANDobject_localized_cs_product_hu_HU.typeIN ('object','variant','folder')) ANDobject_localized_cs_product_hu_HU.published=1ORDER BY`creationDate`DESCLIMIT2;

SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?

SELECTidFROMdocumentsWHERE`path`=BINARY'/ora/'AND`key`=BINARY'SRPB46J1';

SELECTnameFROMclassesWHEREid=?

SELECTnameFROMclassesWHEREid='cs_order';

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783779978THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','redirecttags','routetags');

SELECT*FROMsettings_storeWHEREid=?ANDscope=?

SELECT*FROMsettings_storeWHEREid='BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle'ANDscope='pimcore';

SELECTobject_localized_cs_product_hu_HU.idasid,object_localized_cs_product_hu_HU.typeas`type`FROMobject_localized_cs_product_hu_HUWHERE`sku`='SRPB46J1'ANDobject_localized_cs_product_hu_HU.typeIN ('variant','object')

SELECTobject_localized_cs_product_hu_HU.idasid,object_localized_cs_product_hu_HU.typeas`type`FROMobject_localized_cs_product_hu_HUWHERE`sku`='SRPB46J1'ANDobject_localized_cs_product_hu_HU.typeIN ('variant','object');

SELECTt0.nameASname_1,t0.resultsPerPageASresultsPerPage_2,t0.orderDirectionASorderDirection_3,t0.orderKeyASorderKey_4,t0.creationDateAScreationDate_5,t0.modificationDateASmodificationDate_6,t0.idASid_7,t0.indexIdASindexId_8FROMcoreshop_filtert0WHEREt0.id=?

SELECTt0.nameASname_1,t0.resultsPerPageASresultsPerPage_2,t0.orderDirectionASorderDirection_3,t0.orderKeyASorderKey_4,t0.creationDateAScreationDate_5,t0.modificationDateASmodificationDate_6,t0.idASid_7,t0.indexIdASindexId_8FROMcoreshop_filtert0WHEREt0.id=1;

SELECTc0_.fieldNameASfieldName_0,c0_.productASproduct_1,c0_.priceASprice_2,c0_.idASid_3,c0_.taxRuleIdAStaxRuleId_4,c0_.storeASstore_5FROMcoreshop_product_store_valuesc0_WHEREc0_.product=?ANDc0_.fieldName=?

SELECTc0_.fieldNameASfieldName_0,c0_.productASproduct_1,c0_.priceASprice_2,c0_.idASid_3,c0_.taxRuleIdAStaxRuleId_4,c0_.storeASstore_5FROMcoreshop_product_store_valuesc0_WHEREc0_.product=3871ANDc0_.fieldName='storeValues';

SELECTt0.configKeyASconfigKey_1,t0.dataASdata_2,t0.creationDateAScreationDate_3,t0.modificationDateASmodificationDate_4,t0.idASid_5,t0.store_idASstore_id_6FROMcoreshop_configurationt0WHEREt0.store_idIN (?)

SELECTt0.configKeyASconfigKey_1,t0.dataASdata_2,t0.creationDateAScreationDate_3,t0.modificationDateASmodificationDate_4,t0.idASid_5,t0.store_idASstore_id_6FROMcoreshop_configurationt0WHEREt0.store_idIN (1);

SELECTc0_.nameASname_0,c0_.priorityASpriority_1,c0_.activeASactive_2,c0_.inheritASinherit_3,c0_.productASproduct_4,c0_.stopPropagationASstopPropagation_5,c0_.creationDateAScreationDate_6,c0_.modificationDateASmodificationDate_7,c0_.idASid_8FROMcoreshop_product_specific_price_rulec0_WHEREc0_.product=?ORDER BYc0_.priorityASC

SELECTc0_.nameASname_0,c0_.priorityASpriority_1,c0_.activeASactive_2,c0_.inheritASinherit_3,c0_.productASproduct_4,c0_.stopPropagationASstopPropagation_5,c0_.creationDateAScreationDate_6,c0_.modificationDateASmodificationDate_7,c0_.idASid_8FROMcoreshop_product_specific_price_rulec0_WHEREc0_.product=3871ORDER BYc0_.priorityASC;

SELECTidFROMdocuments_pageWHEREprettyUrl=?

SELECTidFROMdocuments_pageWHEREprettyUrl='/ora/SRPB46J1';

SELECTt0.isoCodeASisoCode_1,t0.nameASname_2,t0.numericIsoCodeASnumericIsoCode_3,t0.symbolASsymbol_4,t0.creationDateAScreationDate_5,t0.modificationDateASmodificationDate_6,t0.idASid_7FROMcoreshop_currencyt0WHEREt0.id=?

SELECTt0.isoCodeASisoCode_1,t0.nameASname_2,t0.numericIsoCodeASnumericIsoCode_3,t0.symbolASsymbol_4,t0.creationDateAScreationDate_5,t0.modificationDateASmodificationDate_6,t0.idASid_7FROMcoreshop_currencyt0WHEREt0.id=65;

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (
    ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
  )

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783779978THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_1tags','asset_23886tags','asset_15451tags','asset_34564tags','asset_15452tags','asset_34567tags','asset_15462tags','asset_34566tags','asset_15463tags','asset_34568tags','asset_15464tags','asset_34565tags','asset_15544tags','asset_23694tags','asset_33697tags','asset_33703tags','asset_33705tags','asset_33706tags','asset_33707tags','asset_33708tags','asset_33821tags','asset_35094tags');

SELECTc0_.nameASname_0,c0_.descriptionASdescription_1,c0_.priorityASpriority_2,c0_.activeASactive_3,c0_.stopPropagationASstopPropagation_4,c0_.creationDateAScreationDate_5,c0_.modificationDateASmodificationDate_6,c0_.idASid_7FROMcoreshop_product_price_rulec0_WHEREc0_.active=1ORDER BYc0_.priorityASC

SELECTc0_.nameASname_0,c0_.descriptionASdescription_1,c0_.priorityASpriority_2,c0_.activeASactive_3,c0_.stopPropagationASstopPropagation_4,c0_.creationDateAScreationDate_5,c0_.modificationDateASmodificationDate_6,c0_.idASid_7FROMcoreshop_product_price_rulec0_WHEREc0_.active=1ORDER BYc0_.priorityASC;

SELECTt0.nameASname_1,t0.templateAStemplate_2,t0.isDefaultASisDefault_3,t0.siteIdASsiteId_4,t0.creationDateAScreationDate_5,t0.modificationDateASmodificationDate_6,t0.idASid_7,t0.useGrossPriceASuseGrossPrice_8,t0.currencyIdAScurrencyId_9,t0.baseCountryIdASbaseCountryId_10,t11.isoCodeASisoCode_12,t11.activeASactive_13,t11.addressFormatASaddressFormat_14,t11.salutationsASsalutations_15,t11.creationDateAScreationDate_16,t11.modificationDateASmodificationDate_17,t11.idASid_18,t11.zoneIdASzoneId_19,t11.currencyIdAScurrencyId_20FROMcoreshop_storet0LEFT JOINcoreshop_countryt11ONt0.baseCountryId=t11.idWHEREt0.id=?

SELECTt0.nameASname_1,t0.templateAStemplate_2,t0.isDefaultASisDefault_3,t0.siteIdASsiteId_4,t0.creationDateAScreationDate_5,t0.modificationDateASmodificationDate_6,t0.idASid_7,t0.useGrossPriceASuseGrossPrice_8,t0.currencyIdAScurrencyId_9,t0.baseCountryIdASbaseCountryId_10,t11.isoCodeASisoCode_12,t11.activeASactive_13,t11.addressFormatASaddressFormat_14,t11.salutationsASsalutations_15,t11.creationDateAScreationDate_16,t11.modificationDateASmodificationDate_17,t11.idASid_18,t11.zoneIdASzoneId_19,t11.currencyIdAScurrencyId_20FROMcoreshop_storet0LEFT JOINcoreshop_countryt11ONt0.baseCountryId=t11.idWHEREt0.id=1;

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?)

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783779978THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('website_configtags','systemtags','configtags','outputtags','asset_15304tags');

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783779978THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_76tags','asset_16823tags','asset_16821tags','asset_16825tags','asset_16824tags','asset_16820tags','asset_20642tags','asset_21858tags','asset_20603tags','asset_20600tags','asset_20602tags','asset_20601tags','asset_20599tags','asset_16826tags','asset_20648tags');

SELECT*FROMtmp_storeWHEREid=?

SELECT*FROMtmp_storeWHEREid='maintenance_mode';

SELECTcustomSettingsFROMassetsWHEREid=?

SELECTcustomSettingsFROMassetsWHEREid=33165;