Code:
[36] => Array
(
[query] => SELECT tl_iso_product_category.*, j1.id AS pid__id, j1.pid AS pid__pid, j1.gid AS pid__gid, j1.tstamp AS pid__tstamp, j1.language AS pid__language, j1.dateAdded AS pid__dateAdded, j1.type AS pid__type, j1.orderPages AS pid__orderPages, j1.inherit AS pid__inherit, j1.alias AS pid__alias, j1.sku AS pid__sku, j1.name AS pid__name, j1.teaser AS pid__teaser, j1.description AS pid__description, j1.meta_title AS pid__meta_title, j1.meta_description AS pid__meta_description, j1.meta_keywords AS pid__meta_keywords, j1.baseprice AS pid__baseprice, j1.shipping_weight AS pid__shipping_weight, j1.shipping_exempt AS pid__shipping_exempt, j1.images AS pid__images, j1.protected AS pid__protected, j1.groups AS pid__groups, j1.guests AS pid__guests, j1.cssID AS pid__cssID, j1.published AS pid__published, j1.start AS pid__start, j1.stop AS pid__stop, j1.shipping_time AS pid__shipping_time, j1.stock_status AS pid__stock_status, j1.doc_files AS pid__doc_files, j1.doc_files_order AS pid__doc_files_order, j1.delivery_quanity AS pid__delivery_quanity, j1.press123 AS pid__press123, j1.noise AS pid__noise, j1.ves123 AS pid__ves123, j2.id AS page_id__id, j2.pid AS page_id__pid, j2.sorting AS page_id__sorting, j2.tstamp AS page_id__tstamp, j2.title AS page_id__title, j2.alias AS page_id__alias, j2.type AS page_id__type, j2.pageTitle AS page_id__pageTitle, j2.language AS page_id__language, j2.robots AS page_id__robots, j2.description AS page_id__description, j2.redirect AS page_id__redirect, j2.jumpTo AS page_id__jumpTo, j2.url AS page_id__url, j2.target AS page_id__target, j2.dns AS page_id__dns, j2.staticFiles AS page_id__staticFiles, j2.staticPlugins AS page_id__staticPlugins, j2.fallback AS page_id__fallback, j2.adminEmail AS page_id__adminEmail, j2.dateFormat AS page_id__dateFormat, j2.timeFormat AS page_id__timeFormat, j2.datimFormat AS page_id__datimFormat, j2.createSitemap AS page_id__createSitemap, j2.sitemapName AS page_id__sitemapName, j2.useSSL AS page_id__useSSL, j2.autoforward AS page_id__autoforward, j2.protected AS page_id__protected, j2.groups AS page_id__groups, j2.includeLayout AS page_id__includeLayout, j2.layout AS page_id__layout, j2.mobileLayout AS page_id__mobileLayout, j2.includeCache AS page_id__includeCache, j2.cache AS page_id__cache, j2.includeChmod AS page_id__includeChmod, j2.cuser AS page_id__cuser, j2.cgroup AS page_id__cgroup, j2.chmod AS page_id__chmod, j2.noSearch AS page_id__noSearch, j2.cssClass AS page_id__cssClass, j2.sitemap AS page_id__sitemap, j2.hide AS page_id__hide, j2.guests AS page_id__guests, j2.tabindex AS page_id__tabindex, j2.accesskey AS page_id__accesskey, j2.published AS page_id__published, j2.start AS page_id__start, j2.stop AS page_id__stop, j2.iso_config AS page_id__iso_config, j2.iso_store_id AS page_id__iso_store_id, j2.iso_setReaderJumpTo AS page_id__iso_setReaderJumpTo, j2.iso_readerJumpTo AS page_id__iso_readerJumpTo FROM tl_iso_product_category LEFT JOIN tl_iso_product j1 ON tl_iso_product_category.pid=j1.id LEFT JOIN tl_page j2 ON tl_iso_product_category.page_id=j2.id WHERE tl_iso_product_category.pid='18' HAVING page_id__type!='error_403' AND page_id__type!='error_404' AND (page_id__start='' OR page_id__start<'1467280800') AND (page_id__stop='' OR page_id__stop>'1467280860') AND page_id__published='1'
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_iso_product_category
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
[duration] => 0,252 ms
)
Lesezeichen