Symfony Profiler

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)

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

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

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783621170THENitem_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='/e-boutique/seiko/presage-c375259'AND (`type`='path'OR`type`='auto_create')) OR
                (source='/e-boutique/seiko/presage-c375259'AND`type`='path_query') OR
                (source='https://boutiqueapi.local.szerver.store/e-boutique/seiko/presage-c375259'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>1783621170THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('system_route_redirect');

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

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783621170THENitem_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'/e-boutique/seiko/'AND`key`=BINARY'presage-c375259';

SELECTidFROMdocuments_pageWHEREprettyUrl=?

SELECTidFROMdocuments_pageWHEREprettyUrl='/e-boutique/seiko/presage-c375259';

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

SELECTidFROMdocumentsWHERE`path`=BINARY'/e-boutique/'AND`key`=BINARY'seiko';

SELECTidFROMdocuments_pageWHEREprettyUrl=?

SELECTidFROMdocuments_pageWHEREprettyUrl='/e-boutique/seiko';

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

SELECTidFROMdocumentsWHERE`path`=BINARY'/'AND`key`=BINARY'e-boutique';

SELECTidFROMdocuments_pageWHEREprettyUrl=?

SELECTidFROMdocuments_pageWHEREprettyUrl='/e-boutique';

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>1783621170THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_1');

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

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783621170THENitem_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>1783621170THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_properties_1');

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

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783621170THENitem_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>1783621170THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('sites_path_mapping');

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

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

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783621170THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375259');

SELECTnameFROMclassesWHEREid=?

SELECTnameFROMclassesWHEREid='cs_category';

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

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783621170THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375259tags','class_cs_categorytags','asset_25765tags');

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=2;

SELECTnameFROMclassesWHEREid=?

SELECTnameFROMclassesWHEREid='cs_product';

SELECTCOUNT(*)
FROMobject_localized_cs_product_hu_HUWHERE
  (
    (`categories`LIKE?)
    ANDobject_localized_cs_product_hu_HU.typeIN ('object','variant','folder')
  )
  ANDobject_localized_cs_product_hu_HU.published=1

SELECTCOUNT(*) FROMobject_localized_cs_product_hu_HUWHERE ((`categories`LIKE'%,object|375259,%')  ANDobject_localized_cs_product_hu_HU.typeIN ('object','variant','folder')) ANDobject_localized_cs_product_hu_HU.published=1;

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783621170THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375232');

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

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783621170THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375232tags','class_cs_categorytags','asset_16791tags');

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;

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783621170THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375163');

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)

SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783621170THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375163tags');

SELECTobject_localized_cs_category_hu_HU.idasid,object_localized_cs_category_hu_HU.typeas`type`FROMobject_localized_cs_category_hu_HUWHERE
  (
    `workingName`='SEIKO'ANDobject_localized_cs_category_hu_HU.typeIN ('variant','object')
  )
  ANDobject_localized_cs_category_hu_HU.published=1LIMIT1

SELECTobject_localized_cs_category_hu_HU.idasid,object_localized_cs_category_hu_HU.typeas`type`FROMobject_localized_cs_category_hu_HUWHERE (`workingName`='SEIKO'ANDobject_localized_cs_category_hu_HU.typeIN ('variant','object')) ANDobject_localized_cs_category_hu_HU.published=1LIMIT1;

SELECTwholesalePriceFROMobject_localized_cs_product_hu_HUWHERE
  (
    object_localized_cs_product_hu_HU.typeIN ('object','folder')
  )
  AND (
    object_localized_cs_product_hu_HU.published=1
  )
  AND (
    object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%'
  )
ORDER BYwholesalePriceASCLIMIT1

SELECTwholesalePriceFROMobject_localized_cs_product_hu_HUWHERE (object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%') ORDER BYwholesalePriceASCLIMIT1;

SELECTwholesalePriceFROMobject_localized_cs_product_hu_HUWHERE
  (
    object_localized_cs_product_hu_HU.typeIN ('object','folder')
  )
  AND (
    object_localized_cs_product_hu_HU.published=1
  )
  AND (
    object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%'
  )
ORDER BYwholesalePriceDESCLIMIT1

SELECTwholesalePriceFROMobject_localized_cs_product_hu_HUWHERE (object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%') ORDER BYwholesalePriceDESCLIMIT1;

SELECTDISTINCTNULLIF(outlet,0)
FROMobject_localized_cs_product_hu_HUWHERE
  (
    (
      object_localized_cs_product_hu_HU.typeIN ('object','folder')
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
    AND (
      object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%'
    )
  )
  AND (
    NULLIF(outlet,0) ISNOTNULL
  )
ORDER BYwholesalePriceDESCLIMIT1

SELECTDISTINCTNULLIF(outlet,0) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%')) AND (NULLIF(outlet,0) ISNOTNULL) ORDER BYwholesalePriceDESCLIMIT1;

SELECTDISTINCTtrim(`typeofwatch`)
FROMobject_localized_cs_product_hu_HUWHERE
  (
    (
      object_localized_cs_product_hu_HU.typeIN ('object','folder')
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
    AND (
      object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%'
    )
    AND (
      trim(`typeofwatch`) ISNOTNULLANDtrim(`typeofwatch`) !=''
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
  )
ORDER BYtrim(`typeofwatch`) ASC

SELECTDISTINCTtrim(`typeofwatch`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%') AND (trim(`typeofwatch`) ISNOTNULLANDtrim(`typeofwatch`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`typeofwatch`) ASC;

SELECTDISTINCTobject_localized_cs_category_hu_HU.id,object_localized_cs_product_hu_HU.collectionFROMobject_localized_cs_category_hu_HULEFT JOINobject_localized_cs_product_hu_HUobject_localized_cs_product_hu_HUONobject_localized_cs_category_hu_HU.workingName=object_localized_cs_product_hu_HU.collectionWHERE
  (
    (
      object_localized_cs_product_hu_HU.typeIN ('object','folder')
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
    AND (
      object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%'
    )
    AND (
      object_localized_cs_product_hu_HU.collectionISNOTNULL
    )
  )

SELECTDISTINCTobject_localized_cs_category_hu_HU.id,object_localized_cs_product_hu_HU.collectionFROMobject_localized_cs_category_hu_HULEFT JOINobject_localized_cs_product_hu_HUobject_localized_cs_product_hu_HUONobject_localized_cs_category_hu_HU.workingName=object_localized_cs_product_hu_HU.collectionWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%') AND (object_localized_cs_product_hu_HU.collectionISNOTNULL));

SELECTDISTINCTtrim(`availability`)
FROMobject_localized_cs_product_hu_HUWHERE
  (
    (
      object_localized_cs_product_hu_HU.typeIN ('object','folder')
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
    AND (
      object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%'
    )
    AND (
      trim(`availability`) ISNOTNULLANDtrim(`availability`) !=''
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
  )
ORDER BYtrim(`availability`) ASC

SELECTDISTINCTtrim(`availability`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%') AND (trim(`availability`) ISNOTNULLANDtrim(`availability`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`availability`) ASC;

SELECTDISTINCTtrim(`movementtypefilter`)
FROMobject_localized_cs_product_hu_HUWHERE
  (
    (
      object_localized_cs_product_hu_HU.typeIN ('object','folder')
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
    AND (
      object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%'
    )
    AND (
      trim(`movementtypefilter`) ISNOTNULLANDtrim(`movementtypefilter`) !=''
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
  )
ORDER BYtrim(`movementtypefilter`) ASC

SELECTDISTINCTtrim(`movementtypefilter`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%') AND (trim(`movementtypefilter`) ISNOTNULLANDtrim(`movementtypefilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`movementtypefilter`) ASC;

SELECTDISTINCTtrim(`casefilter`)
FROMobject_localized_cs_product_hu_HUWHERE
  (
    (
      object_localized_cs_product_hu_HU.typeIN ('object','folder')
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
    AND (
      object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%'
    )
    AND (
      trim(`casefilter`) ISNOTNULLANDtrim(`casefilter`) !=''
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
  )
ORDER BYtrim(`casefilter`) ASC

SELECTDISTINCTtrim(`casefilter`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%') AND (trim(`casefilter`) ISNOTNULLANDtrim(`casefilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`casefilter`) ASC;

SELECTDISTINCTtrim(`glassfilter`)
FROMobject_localized_cs_product_hu_HUWHERE
  (
    (
      object_localized_cs_product_hu_HU.typeIN ('object','folder')
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
    AND (
      object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%'
    )
    AND (
      trim(`glassfilter`) ISNOTNULLANDtrim(`glassfilter`) !=''
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
  )
ORDER BYtrim(`glassfilter`) ASC

SELECTDISTINCTtrim(`glassfilter`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%') AND (trim(`glassfilter`) ISNOTNULLANDtrim(`glassfilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`glassfilter`) ASC;

SELECTDISTINCTtrim(`formofcase`)
FROMobject_localized_cs_product_hu_HUWHERE
  (
    (
      object_localized_cs_product_hu_HU.typeIN ('object','folder')
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
    AND (
      object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%'
    )
    AND (
      trim(`formofcase`) ISNOTNULLANDtrim(`formofcase`) !=''
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
  )
ORDER BYtrim(`formofcase`) ASC

SELECTDISTINCTtrim(`formofcase`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%') AND (trim(`formofcase`) ISNOTNULLANDtrim(`formofcase`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`formofcase`) ASC;

SELECTDISTINCTtrim(`style`)
FROMobject_localized_cs_product_hu_HUWHERE
  (
    (
      object_localized_cs_product_hu_HU.typeIN ('object','folder')
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
    AND (
      object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%'
    )
    AND (
      trim(`style`) ISNOTNULLANDtrim(`style`) !=''
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
  )
ORDER BYtrim(`style`) ASC

SELECTDISTINCTtrim(`style`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%') AND (trim(`style`) ISNOTNULLANDtrim(`style`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`style`) ASC;

SELECTDISTINCTtrim(`bandfilter`)
FROMobject_localized_cs_product_hu_HUWHERE
  (
    (
      object_localized_cs_product_hu_HU.typeIN ('object','folder')
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
    AND (
      object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%'
    )
    AND (
      trim(`bandfilter`) ISNOTNULLANDtrim(`bandfilter`) !=''
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
  )
ORDER BYtrim(`bandfilter`) ASC

SELECTDISTINCTtrim(`bandfilter`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%') AND (trim(`bandfilter`) ISNOTNULLANDtrim(`bandfilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`bandfilter`) ASC;

SELECTDISTINCTtrim(`buckle`)
FROMobject_localized_cs_product_hu_HUWHERE
  (
    (
      object_localized_cs_product_hu_HU.typeIN ('object','folder')
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
    AND (
      object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%'
    )
    AND (
      trim(`buckle`) ISNOTNULLANDtrim(`buckle`) !=''
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
  )
ORDER BYtrim(`buckle`) ASC

SELECTDISTINCTtrim(`buckle`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%') AND (trim(`buckle`) ISNOTNULLANDtrim(`buckle`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`buckle`) ASC;

SELECTDISTINCTtrim(`bezel`)
FROMobject_localized_cs_product_hu_HUWHERE
  (
    (
      object_localized_cs_product_hu_HU.typeIN ('object','folder')
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
    AND (
      object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%'
    )
    AND (
      trim(`bezel`) ISNOTNULLANDtrim(`bezel`) !=''
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
  )
ORDER BYtrim(`bezel`) ASC

SELECTDISTINCTtrim(`bezel`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%') AND (trim(`bezel`) ISNOTNULLANDtrim(`bezel`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`bezel`) ASC;

SELECTDISTINCTtrim(`backcase`)
FROMobject_localized_cs_product_hu_HUWHERE
  (
    (
      object_localized_cs_product_hu_HU.typeIN ('object','folder')
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
    AND (
      object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%'
    )
    AND (
      trim(`backcase`) ISNOTNULLANDtrim(`backcase`) !=''
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
  )
ORDER BYtrim(`backcase`) ASC

SELECTDISTINCTtrim(`backcase`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%') AND (trim(`backcase`) ISNOTNULLANDtrim(`backcase`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`backcase`) ASC;

SELECTDISTINCTtrim(`colorofdial`)
FROMobject_localized_cs_product_hu_HUWHERE
  (
    (
      object_localized_cs_product_hu_HU.typeIN ('object','folder')
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
    AND (
      object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%'
    )
    AND (
      trim(`colorofdial`) ISNOTNULLANDtrim(`colorofdial`) !=''
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
  )
ORDER BYtrim(`colorofdial`) ASC

SELECTDISTINCTtrim(`colorofdial`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%') AND (trim(`colorofdial`) ISNOTNULLANDtrim(`colorofdial`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`colorofdial`) ASC;

SELECTDISTINCTtrim(`waterresistance`)
FROMobject_localized_cs_product_hu_HUWHERE
  (
    (
      object_localized_cs_product_hu_HU.typeIN ('object','folder')
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
    AND (
      object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%'
    )
    AND (
      trim(`waterresistance`) ISNOTNULLANDtrim(`waterresistance`) !=''
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
  )
ORDER BYtrim(`waterresistance`) ASC

SELECTDISTINCTtrim(`waterresistance`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%') AND (trim(`waterresistance`) ISNOTNULLANDtrim(`waterresistance`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`waterresistance`) ASC;

SELECTDISTINCTtrim(`crownandbutton`)
FROMobject_localized_cs_product_hu_HUWHERE
  (
    (
      object_localized_cs_product_hu_HU.typeIN ('object','folder')
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
    AND (
      object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%'
    )
    AND (
      trim(`crownandbutton`) ISNOTNULLANDtrim(`crownandbutton`) !=''
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
  )
ORDER BYtrim(`crownandbutton`) ASC

SELECTDISTINCTtrim(`crownandbutton`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%') AND (trim(`crownandbutton`) ISNOTNULLANDtrim(`crownandbutton`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`crownandbutton`) ASC;

SELECTDISTINCTtrim(`dial`)
FROMobject_localized_cs_product_hu_HUWHERE
  (
    (
      object_localized_cs_product_hu_HU.typeIN ('object','folder')
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
    AND (
      object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%'
    )
    AND (
      trim(`dial`) ISNOTNULLANDtrim(`dial`) !=''
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
  )
ORDER BYtrim(`dial`) ASC

SELECTDISTINCTtrim(`dial`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%') AND (trim(`dial`) ISNOTNULLANDtrim(`dial`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`dial`) ASC;

SELECTDISTINCTtrim(`diamondsfilter`)
FROMobject_localized_cs_product_hu_HUWHERE
  (
    (
      object_localized_cs_product_hu_HU.typeIN ('object','folder')
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
    AND (
      object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%'
    )
    AND (
      trim(`diamondsfilter`) ISNOTNULLANDtrim(`diamondsfilter`) !=''
    )
    AND (
      object_localized_cs_product_hu_HU.published=1
    )
  )
ORDER BYtrim(`diamondsfilter`) ASC

SELECTDISTINCTtrim(`diamondsfilter`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375259,%') AND (trim(`diamondsfilter`) ISNOTNULLANDtrim(`diamondsfilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`diamondsfilter`) ASC;

SELECTt0.classASclass_1,t0.nameASname_2,t0.workerASworker_3,t0.configurationASconfiguration_4,t0.indexLastVersionASindexLastVersion_5,t0.creationDateAScreationDate_6,t0.modificationDateASmodificationDate_7,t0.idASid_8FROMcoreshop_indext0WHEREt0.id=?

SELECTt0.classASclass_1,t0.nameASname_2,t0.workerASworker_3,t0.configurationASconfiguration_4,t0.indexLastVersionASindexLastVersion_5,t0.creationDateAScreationDate_6,t0.modificationDateASmodificationDate_7,t0.idASid_8FROMcoreshop_indext0WHEREt0.id=2;

SELECTt0.typeAStype_1,t0.labelASlabel_2,t0.quantityUnitASquantityUnit_3,t0.configurationASconfiguration_4,t0.sortASsort_5,t0.creationDateAScreationDate_6,t0.modificationDateASmodificationDate_7,t0.idASid_8FROMcoreshop_filter_conditiont0INNER JOINcoreshop_filter_condition_conditionsONt0.id=coreshop_filter_condition_conditions.conditionIdWHEREcoreshop_filter_condition_conditions.filterId=?ORDER BYt0.sortASC