- 3
- /shop/#page#
- product/index
- \/shop\/(?
\d+)
- product/index.html
- product/index.tpl
/* /var/www/html/plugins/debug/plugin.php [line: 124 - 129] */ function ($sql, $params){ $debugSql = $db->debugSql($sql, $params); $this->view->debug['data']['sql'][] = [$sql, $params + ['sql' => $debugSql]]; return [$sql, $params]; });
/* /var/www/html/plugins/debug/plugin.php [line: 167 - 184] */ function ($template, $tplFile, $templateEngine, $view){ $events = Event::getEvents(); array_walk_recursive($events, function (&$value, $key) { if (is_object($value)) { if ($value instanceof \Closure) { $value = $this->closureDump($value); } } }); $view = ['template' => $template, 'tplFile' => $tplFile]; $this->view->debug['data']['request'] = Routes::getUrlData(); $this->view->debug['data']['view'] = $view; $this->view->debug['data']['filters'] = $events; return [$template, $tplFile, $templateEngine, $view]; });
/* /var/www/html/plugins/minify/plugin.php [line: 369 - 381] */ function ($template, $htmlFile, $tplFile, $vTpl, $view){ $theme = $view->getTheme(); $this->initMinifier(); $this->processCss($vTpl, $template, $theme); $this->processCss($vTpl, $template, $theme, 'body > '); $this->processJs($vTpl, $template, $theme); $this->processJs($vTpl, $template, $theme, 'body > '); return [$template, $htmlFile, $tplFile, $vTpl, $view]; });
- SELECT * FROM manufacturer LEFT JOIN manufacturer_to_site p2s ON (manufacturer.manufacturer_id = p2s.manufacturer_id) WHERE p2s.site_id = :site_id LIMIT :start, :limit
- 4
- price asc
- 7
- 1
- tags
- 1
- 1
- en
- 1
- en
- 1
- 1
- USD
- SELECT * FROM manufacturer LEFT JOIN manufacturer_to_site p2s ON (manufacturer.manufacturer_id = p2s.manufacturer_id) WHERE p2s.site_id = 1 LIMIT 0, 7
- SELECT count(*) FROM ( SELECT manufacturer.manufacturer_id FROM manufacturer LEFT JOIN manufacturer_to_site p2s ON (manufacturer.manufacturer_id = p2s.manufacturer_id) WHERE p2s.site_id = :site_id ) as count
- 4
- price asc
- 7
- 1
- tags
- 1
- 1
- en
- 1
- en
- 1
- 1
- USD
- SELECT count(*) FROM ( SELECT manufacturer.manufacturer_id FROM manufacturer LEFT JOIN manufacturer_to_site p2s ON (manufacturer.manufacturer_id = p2s.manufacturer_id) WHERE p2s.site_id = 1 ) as count
- SELECT pd.*,product.*, product.product_id as array_key ,(SELECT JSON_ARRAYAGG( JSON_OBJECT('id', pi.product_image_id, 'image', pi.image) ) FROM product_image as pi WHERE pi.product_id = product.product_id GROUP BY pi.product_id) as images ,(SELECT MIN(pvmin.price) FROM product_variant pvmin WHERE pvmin.product_id = product.product_id LIMIT 1 ) AS min_price ,(SELECT MAX(pvmax.price) FROM product_variant pvmax WHERE pvmax.product_id = product.product_id LIMIT 1 ) AS max_price FROM product LEFT JOIN product_to_site p2s ON (product.product_id = p2s.product_id) LEFT JOIN product_content pd ON ( product.product_id = pd.product_id AND pd.language_id = :language_id ) WHERE 1 = 1 AND p2s.site_id = :site_id AND product.type = :type AND product.status = :status ORDER BY product.product_id DESC LIMIT :start, :limit
- 6
- true
- 3
- medium
- true
- 12
- 1
- autocomplete
- 1
- 1
- product
- 1
- 1
- en
- 1
- en
- 1
- USD
- SELECT pd.*,product.*, product.product_id as array_key ,(SELECT JSON_ARRAYAGG( JSON_OBJECT('id', pi.product_image_id, 'image', pi.image) ) FROM product_image as pi WHERE pi.product_id = product.product_id GROUP BY pi.product_id) as images ,(SELECT MIN(pvmin.price) FROM product_variant pvmin WHERE pvmin.product_id = product.product_id LIMIT 1 ) AS min_price ,(SELECT MAX(pvmax.price) FROM product_variant pvmax WHERE pvmax.product_id = product.product_id LIMIT 1 ) AS max_price FROM product LEFT JOIN product_to_site p2s ON (product.product_id = p2s.product_id) LEFT JOIN product_content pd ON ( product.product_id = pd.product_id AND pd.language_id = 1 ) WHERE 1 = 1 AND p2s.site_id = 1 AND product.type = 'product' AND product.status = 1 ORDER BY product.product_id DESC LIMIT 12, 6
- SELECT count(*) FROM ( SELECT product.product_id FROM product LEFT JOIN product_to_site p2s ON (product.product_id = p2s.product_id) LEFT JOIN product_content pd ON ( product.product_id = pd.product_id AND pd.language_id = :language_id ) WHERE 1 = 1 AND p2s.site_id = :site_id AND product.type = :type AND product.status = :status ) as count
- 6
- true
- 3
- medium
- true
- 12
- 1
- autocomplete
- 1
- 1
- product
- 1
- 1
- en
- 1
- en
- 1
- USD
- SELECT count(*) FROM ( SELECT product.product_id FROM product LEFT JOIN product_to_site p2s ON (product.product_id = p2s.product_id) LEFT JOIN product_content pd ON ( product.product_id = pd.product_id AND pd.language_id = 1 ) WHERE 1 = 1 AND p2s.site_id = 1 AND product.type = 'product' AND product.status = 1 ) as count
- SELECT menu_item.url, menu_item.sort_order, menu_item.parent_id, menu_item.type, menu_item.options, menu_item.item_id, td.*, menu_item.menu_item_id as menu_item_id, menu_item.menu_item_id as array_key FROM menu_item LEFT JOIN menu_item_content td ON (menu_item.menu_item_id = td.menu_item_id AND td.language_id = :language_id) WHERE 1 = 1 AND menu_item.menu_id = ( SELECT menu.menu_id FROM menu INNER JOIN menu_to_site ON (menu.menu_id = menu_to_site.menu_id AND menu_to_site.site_id = :site_id) WHERE slug = :slug LIMIT 1 ) ORDER BY menu_item.parent_id, menu_item.sort_order, menu_item.menu_id LIMIT :start, :limit
- main-menu
- 10000
- 1
- 1
- 1
- en
- 1
- en
- 1
- USD
- SELECT menu_item.url, menu_item.sort_order, menu_item.parent_id, menu_item.type, menu_item.options, menu_item.item_id, td.*, menu_item.menu_item_id as menu_item_id, menu_item.menu_item_id as array_key FROM menu_item LEFT JOIN menu_item_content td ON (menu_item.menu_item_id = td.menu_item_id AND td.language_id = 1) WHERE 1 = 1 AND menu_item.menu_id = ( SELECT menu.menu_id FROM menu INNER JOIN menu_to_site ON (menu.menu_id = menu_to_site.menu_id AND menu_to_site.site_id = 1) WHERE slug = 'main-menu' LIMIT 1 ) ORDER BY menu_item.parent_id, menu_item.sort_order, menu_item.menu_id LIMIT 0, 10000
- SELECT pd.*,post.*,ad.username,ad.display_name,ad.admin_id,ad.email, ad.avatar, ad.bio, ad.first_name, ad.last_name, post.post_id as array_key FROM post LEFT JOIN post_content pd ON ( post.post_id = pd.post_id AND pd.language_id = :language_id ) LEFT JOIN post_to_site ps ON (post.post_id = ps.post_id) LEFT JOIN admin ad ON (post.admin_id = ad.admin_id) WHERE 1 = 1 AND post.post_id IN (:post_id) ORDER BY post.post_id DESC
- 12
- 7
- 13
- 14
- 1
- SELECT pd.*,post.*,ad.username,ad.display_name,ad.admin_id,ad.email, ad.avatar, ad.bio, ad.first_name, ad.last_name, post.post_id as array_key FROM post LEFT JOIN post_content pd ON ( post.post_id = pd.post_id AND pd.language_id = 1 ) LEFT JOIN post_to_site ps ON (post.post_id = ps.post_id) LEFT JOIN admin ad ON (post.admin_id = ad.admin_id) WHERE 1 = 1 AND post.post_id IN (12,7,13,14) ORDER BY post.post_id DESC
- SELECT count(*) FROM ( SELECT post.post_id FROM post LEFT JOIN post_content pd ON ( post.post_id = pd.post_id AND pd.language_id = :language_id ) LEFT JOIN post_to_site ps ON (post.post_id = ps.post_id) LEFT JOIN admin ad ON (post.admin_id = ad.admin_id) WHERE 1 = 1 AND post.post_id IN (:post_id) ) as count
- 12
- 7
- 13
- 14
- 1
- SELECT count(*) FROM ( SELECT post.post_id FROM post LEFT JOIN post_content pd ON ( post.post_id = pd.post_id AND pd.language_id = 1 ) LEFT JOIN post_to_site ps ON (post.post_id = ps.post_id) LEFT JOIN admin ad ON (post.admin_id = ad.admin_id) WHERE 1 = 1 AND post.post_id IN (12,7,13,14) ) as count
- SELECT menu_item.url, menu_item.sort_order, menu_item.parent_id, menu_item.type, menu_item.options, menu_item.item_id, td.*, menu_item.menu_item_id as menu_item_id, menu_item.menu_item_id as array_key FROM menu_item LEFT JOIN menu_item_content td ON (menu_item.menu_item_id = td.menu_item_id AND td.language_id = :language_id) WHERE 1 = 1 AND menu_item.menu_id = ( SELECT menu.menu_id FROM menu INNER JOIN menu_to_site ON (menu.menu_id = menu_to_site.menu_id AND menu_to_site.site_id = :site_id) WHERE slug = :slug LIMIT 1 ) ORDER BY menu_item.parent_id, menu_item.sort_order, menu_item.menu_id LIMIT :start, :limit
- main-footer
- 10000
- 1
- 1
- 1
- en
- 1
- en
- 1
- USD
- SELECT menu_item.url, menu_item.sort_order, menu_item.parent_id, menu_item.type, menu_item.options, menu_item.item_id, td.*, menu_item.menu_item_id as menu_item_id, menu_item.menu_item_id as array_key FROM menu_item LEFT JOIN menu_item_content td ON (menu_item.menu_item_id = td.menu_item_id AND td.language_id = 1) WHERE 1 = 1 AND menu_item.menu_id = ( SELECT menu.menu_id FROM menu INNER JOIN menu_to_site ON (menu.menu_id = menu_to_site.menu_id AND menu_to_site.site_id = 1) WHERE slug = 'main-footer' LIMIT 1 ) ORDER BY menu_item.parent_id, menu_item.sort_order, menu_item.menu_id LIMIT 0, 10000
- SELECT pd.*,post.*,ad.username,ad.display_name,ad.admin_id,ad.email, ad.avatar, ad.bio, ad.first_name, ad.last_name, post.post_id as array_key FROM post LEFT JOIN post_content pd ON ( post.post_id = pd.post_id AND pd.language_id = :language_id ) LEFT JOIN post_to_site ps ON (post.post_id = ps.post_id) LEFT JOIN admin ad ON (post.admin_id = ad.admin_id) WHERE 1 = 1 AND post.post_id IN (:post_id) ORDER BY post.post_id DESC
- 7
- 8
- 9
- 12
- 11
- 14
- 15
- 1
- SELECT pd.*,post.*,ad.username,ad.display_name,ad.admin_id,ad.email, ad.avatar, ad.bio, ad.first_name, ad.last_name, post.post_id as array_key FROM post LEFT JOIN post_content pd ON ( post.post_id = pd.post_id AND pd.language_id = 1 ) LEFT JOIN post_to_site ps ON (post.post_id = ps.post_id) LEFT JOIN admin ad ON (post.admin_id = ad.admin_id) WHERE 1 = 1 AND post.post_id IN (7,8,9,12,11,14,15) ORDER BY post.post_id DESC
- SELECT count(*) FROM ( SELECT post.post_id FROM post LEFT JOIN post_content pd ON ( post.post_id = pd.post_id AND pd.language_id = :language_id ) LEFT JOIN post_to_site ps ON (post.post_id = ps.post_id) LEFT JOIN admin ad ON (post.admin_id = ad.admin_id) WHERE 1 = 1 AND post.post_id IN (:post_id) ) as count
- 7
- 8
- 9
- 12
- 11
- 14
- 15
- 1
- SELECT count(*) FROM ( SELECT post.post_id FROM post LEFT JOIN post_content pd ON ( post.post_id = pd.post_id AND pd.language_id = 1 ) LEFT JOIN post_to_site ps ON (post.post_id = ps.post_id) LEFT JOIN admin ad ON (post.admin_id = ad.admin_id) WHERE 1 = 1 AND post.post_id IN (7,8,9,12,11,14,15) ) as count
- SELECT DISTINCT categories.taxonomy_item_id, categories.*, tc.language_id, tc.name, tc.content, tc.slug, tc.content, categories.taxonomy_item_id as array_key FROM taxonomy_item AS categories INNER JOIN taxonomy_to_site t2s ON (categories.taxonomy_item_id = t2s.taxonomy_item_id AND t2s.site_id = :site_id) INNER JOIN taxonomy_item_content tc ON (categories.taxonomy_item_id = tc.taxonomy_item_id AND tc.language_id = :language_id) INNER JOIN taxonomy t ON (categories.taxonomy_id = t.taxonomy_id) WHERE tc.language_id = :language_id AND t2s.site_id = :site_id AND t.type = :type AND t.post_type = :post_type ORDER BY categories.parent_id, categories.sort_order, categories.taxonomy_item_id LIMIT :start, :limit
- categories
- 1000
- product
- 1
- 1
- price asc
- 1
- en
- 1
- en
- 1
- USD
- SELECT DISTINCT categories.taxonomy_item_id, categories.*, tc.language_id, tc.name, tc.content, tc.slug, tc.content, categories.taxonomy_item_id as array_key FROM taxonomy_item AS categories INNER JOIN taxonomy_to_site t2s ON (categories.taxonomy_item_id = t2s.taxonomy_item_id AND t2s.site_id = 1) INNER JOIN taxonomy_item_content tc ON (categories.taxonomy_item_id = tc.taxonomy_item_id AND tc.language_id = 1) INNER JOIN taxonomy t ON (categories.taxonomy_id = t.taxonomy_id) WHERE tc.language_id = 1 AND t2s.site_id = 1 AND t.type = 'categories' AND t.post_type = 'product' ORDER BY categories.parent_id, categories.sort_order, categories.taxonomy_item_id LIMIT 0, 1000
- SELECT count(*) FROM ( SELECT categories.taxonomy_item_id FROM taxonomy_item AS categories INNER JOIN taxonomy_to_site t2s ON (categories.taxonomy_item_id = t2s.taxonomy_item_id AND t2s.site_id = :site_id) INNER JOIN taxonomy_item_content tc ON (categories.taxonomy_item_id = tc.taxonomy_item_id AND tc.language_id = :language_id) INNER JOIN taxonomy t ON (categories.taxonomy_id = t.taxonomy_id) WHERE tc.language_id = :language_id AND t2s.site_id = :site_id AND t.type = :type AND t.post_type = :post_type ) as count
- categories
- 1000
- product
- 1
- 1
- price asc
- 1
- en
- 1
- en
- 1
- USD
- SELECT count(*) FROM ( SELECT categories.taxonomy_item_id FROM taxonomy_item AS categories INNER JOIN taxonomy_to_site t2s ON (categories.taxonomy_item_id = t2s.taxonomy_item_id AND t2s.site_id = 1) INNER JOIN taxonomy_item_content tc ON (categories.taxonomy_item_id = tc.taxonomy_item_id AND tc.language_id = 1) INNER JOIN taxonomy t ON (categories.taxonomy_id = t.taxonomy_id) WHERE tc.language_id = 1 AND t2s.site_id = 1 AND t.type = 'categories' AND t.post_type = 'product' ) as count
- SELECT * FROM vendor LEFT JOIN vendor_to_site p2s ON (vendor.vendor_id = p2s.vendor_id) WHERE p2s.site_id = :site_id LIMIT :start, :limit
- 4
- price asc
- 7
- 1
- tags
- 1
- 1
- en
- 1
- en
- 1
- 1
- USD
- SELECT * FROM vendor LEFT JOIN vendor_to_site p2s ON (vendor.vendor_id = p2s.vendor_id) WHERE p2s.site_id = 1 LIMIT 0, 7
- SELECT count(*) FROM ( SELECT vendor.vendor_id FROM vendor LEFT JOIN vendor_to_site p2s ON (vendor.vendor_id = p2s.vendor_id) WHERE p2s.site_id = :site_id ) as count
- 4
- price asc
- 7
- 1
- tags
- 1
- 1
- en
- 1
- en
- 1
- 1
- USD
- SELECT count(*) FROM ( SELECT vendor.vendor_id FROM vendor LEFT JOIN vendor_to_site p2s ON (vendor.vendor_id = p2s.vendor_id) WHERE p2s.site_id = 1 ) as count
