Symfony Profiler

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783529619THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('site_domain_11c5d8b0b5631c7a2566bb0d34acd7d3');

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

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

SELECT*FROMsettings_storeWHEREid=?ANDscope=?

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

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='/Products/19157/image-thumb__19157__seiko_productDetailsSmall/SBGW299G_6.32b1a91c.png'AND (`type`='path'OR`type`='auto_create')) OR
                (source='/Products/19157/image-thumb__19157__seiko_productDetailsSmall/SBGW299G_6.32b1a91c.png'AND`type`='path_query') OR
                (source='https://boutiqueapi.local.szerver.store/Products/19157/image-thumb__19157__seiko_productDetailsSmall/SBGW299G_6.32b1a91c.png'AND`type`='entire_uri')
            ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC;

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783529619THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('system_route_redirect');

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

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

SELECT*FROMtmp_storeWHEREid=?

SELECT*FROMtmp_storeWHEREid='maintenance_mode';

SELECT*FROMsettings_storeWHEREid=?ANDscope=?

SELECT*FROMsettings_storeWHEREid='reports'ANDscope='pimcore';

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

SELECTidFROMdocumentsWHERE`path`=BINARY'/Products/19157/image-thumb__19157__seiko_productDetailsSmall/'AND`key`=BINARY'SBGW299G_6.32b1a91c.png';

SELECTidFROMdocuments_pageWHEREprettyUrl=?

SELECTidFROMdocuments_pageWHEREprettyUrl='/Products/19157/image-thumb__19157__seiko_productDetailsSmall/SBGW299G_6.32b1a91c.png';

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

SELECTidFROMdocumentsWHERE`path`=BINARY'/Products/19157/'AND`key`=BINARY'image-thumb__19157__seiko_productDetailsSmall';

SELECTidFROMdocuments_pageWHEREprettyUrl=?

SELECTidFROMdocuments_pageWHEREprettyUrl='/Products/19157/image-thumb__19157__seiko_productDetailsSmall';

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

SELECTidFROMdocumentsWHERE`path`=BINARY'/Products/'AND`key`=BINARY'19157';

SELECTidFROMdocuments_pageWHEREprettyUrl=?

SELECTidFROMdocuments_pageWHEREprettyUrl='/Products/19157';

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

SELECTidFROMdocumentsWHERE`path`=BINARY'/'AND`key`=BINARY'Products';

SELECTidFROMdocuments_pageWHEREprettyUrl=?

SELECTidFROMdocuments_pageWHEREprettyUrl='/Products';

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

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

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783529619THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_1');

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

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783529619THENitem_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');

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783529619THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_properties_1');

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

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783529619THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_propertiestags','document_1tags');

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';

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);

SELECTnameFROMclassesWHEREid=?

SELECTnameFROMclassesWHEREid='cs_order';

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783529619THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('asset_19157');

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783529619THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('asset_19157tags');

SELECTcustomSettingsFROMassetsWHEREid=?

SELECTcustomSettingsFROMassetsWHEREid=19157;

INSERTINTOlock_keys (
  key_id,key_token,key_expiration
)
VALUES
  (
    ?,?,UNIX_TIMESTAMP(
      NOW(6)
    ) +300
  )

INSERTINTOlock_keys (key_id,key_token,key_expiration) VALUES ('86b2d24c7d20163fb87537be58a023abc1309a6c3ffa2a65c9938c503956debc','7VPpUcwEWrzqS8fHzNIe3/Ezc2GvdZ3dq28QNiBzc04=',UNIX_TIMESTAMP(NOW(6)) +300);

UPDATElock_keysSETkey_expiration=UNIX_TIMESTAMP(
    NOW(6)
  ) +?,key_token=?WHEREkey_id=?AND (
    key_token=?ORkey_expiration<=UNIX_TIMESTAMP(
      NOW(6)
    )
  )

UPDATElock_keysSETkey_expiration=UNIX_TIMESTAMP(NOW(6)) +300,key_token='7VPpUcwEWrzqS8fHzNIe3/Ezc2GvdZ3dq28QNiBzc04='WHEREkey_id='86b2d24c7d20163fb87537be58a023abc1309a6c3ffa2a65c9938c503956debc'AND (key_token='7VPpUcwEWrzqS8fHzNIe3/Ezc2GvdZ3dq28QNiBzc04='ORkey_expiration<=UNIX_TIMESTAMP(NOW(6)));

SELECT1FROMlock_keysWHEREkey_id=?ANDkey_token=?ANDkey_expiration>UNIX_TIMESTAMP(
    NOW(6)
  )

SELECT1FROMlock_keysWHEREkey_id='86b2d24c7d20163fb87537be58a023abc1309a6c3ffa2a65c9938c503956debc'ANDkey_token='7VPpUcwEWrzqS8fHzNIe3/Ezc2GvdZ3dq28QNiBzc04='ANDkey_expiration>UNIX_TIMESTAMP(NOW(6));

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783529619THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('system_resource_columns_assets_image_thumbnail_cache');

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

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783529619THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','resourcetags');

INSERTINTOassets_image_thumbnail_cache (
  `cid`,`name`,`filename`,`modificationDate`,`filesize`,`width`,`height`
)
VALUES
  (?,?,?,?,?,?,?)

INSERTINTOassets_image_thumbnail_cache (`cid`,`name`,`filename`,`modificationDate`,`filesize`,`width`,`height`) VALUES (19157,'seiko_productDetailsSmall','SBGW299G_6.32b1a91c.png',1783529619,14520,116,116);

UPDATEassets_image_thumbnail_cacheSET`cid`=?,`name`=?,`filename`=?,`modificationDate`=?,`filesize`=?,`width`=?,`height`=?WHERE`cid`=?AND`name`=?AND`filename`=?

UPDATEassets_image_thumbnail_cacheSET`cid`=19157,`name`='seiko_productDetailsSmall',`filename`='SBGW299G_6.32b1a91c.png',`modificationDate`=1783529619,`filesize`=14520,`width`=116,`height`=116WHERE`cid`=19157AND`name`='seiko_productDetailsSmall'AND`filename`='SBGW299G_6.32b1a91c.png';

DELETE FROMlock_keysWHEREkey_id=?ANDkey_token=?

DELETE FROMlock_keysWHEREkey_id='86b2d24c7d20163fb87537be58a023abc1309a6c3ffa2a65c9938c503956debc'ANDkey_token='7VPpUcwEWrzqS8fHzNIe3/Ezc2GvdZ3dq28QNiBzc04=';

SELECT1FROMlock_keysWHEREkey_id=?ANDkey_token=?ANDkey_expiration>UNIX_TIMESTAMP(
    NOW(6)
  )

SELECT1FROMlock_keysWHEREkey_id='86b2d24c7d20163fb87537be58a023abc1309a6c3ffa2a65c9938c503956debc'ANDkey_token='7VPpUcwEWrzqS8fHzNIe3/Ezc2GvdZ3dq28QNiBzc04='ANDkey_expiration>UNIX_TIMESTAMP(NOW(6));

SELECT*FROMassets_image_thumbnail_cacheWHEREcid=?

SELECT*FROMassets_image_thumbnail_cacheWHEREcid=19157;

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;

SELECTnameFROMclassesWHEREid=?

SELECTnameFROMclassesWHEREid='cs_wishlist';