| 0.0001 |
SELECT GET_LOCK('c9353f8701b0e03dfc0391b6d5ff7c03', 300) AS ci_session_lock
|
| 0.0005 |
SELECT `data`
FROM `cms_sessions`
WHERE `id` = 'b6c93f791d84d8c00fe3bc2240772f5c7c6dc834'
AND `ip_address` = '216.73.217.151'
|
| 0.0001 |
SELECT *
FROM `cms_lang`
WHERE `pub` = 1
ORDER BY `position`
|
| 0.0001 |
SELECT *
FROM `cms_currencies`
WHERE `pub` = 1
ORDER BY `main` DESC
|
| 0.0003 |
SELECT `tk2`.*, `tk1`.*, `tk3`.`id_art` as `parent_id`, `tk3`.`title` as `parent_title`, `tk4`.`url` as `user_url`, `tk5`.`method`, `tk5`.`view`
FROM `cms_articles` as `tk1`
JOIN `cms_articles_content` as `tk2` ON `tk1`.`id` = `tk2`.`id_art`
LEFT JOIN `cms_articles_content` as `tk3` ON `tk1`.`id_tree` = `tk3`.`id_art` and `tk2`.`lang` = `tk3`.`lang`
LEFT JOIN `cms_user_url` `tk4` ON `tk4`.`dest_id`=`tk1`.`id` AND `tk4`.`type`='articles' AND `tk4`.`lang`= 'pl'
LEFT JOIN `cms_template` `tk5` ON `tk1`.`id_template` = `tk5`.`id`
WHERE `tk1`.`id` = 1
AND `tk1`.`pub` = 1
AND `tk2`.`pub` = 1
AND `tk2`.`lang` = 'pl'
|
| 0.0004 |
SELECT *
FROM `cms_settings`
WHERE (
`lang` = 'pl'
OR lang IS NULL
)
AND `pub` = 1
|
| 0.0001 |
SELECT *
FROM `cms_articles`
WHERE `id` = 1
|
| 0.0002 |
SELECT `tk2`.*, `tk1`.*, `tk3`.`id_art` as `parent_id`, `tk3`.`title` as `parent_title`, `tk4`.`url` as `user_url`, `tk5`.`method`, `tk5`.`view`
FROM `cms_articles` as `tk1`
JOIN `cms_articles_content` as `tk2` ON `tk1`.`id` = `tk2`.`id_art`
LEFT JOIN `cms_articles_content` as `tk3` ON `tk1`.`id_tree` = `tk3`.`id_art` and `tk2`.`lang` = `tk3`.`lang`
LEFT JOIN `cms_user_url` `tk4` ON `tk4`.`dest_id`=`tk1`.`id` AND `tk4`.`type`='articles' AND `tk4`.`lang`= 'pl'
LEFT JOIN `cms_template` `tk5` ON `tk1`.`id_template` = `tk5`.`id`
WHERE `tk1`.`id` = 1
AND `tk1`.`pub` = 1
AND `tk2`.`pub` = 1
AND `tk2`.`lang` = 'pl'
|
| 0.0005 |
SELECT `s`.`id_art`, `s`.`name`, `sv`.`value`
FROM `cms_articles_settings` as `s`
LEFT JOIN `cms_articles_settings_values` `sv` ON `s`.`id` = `sv`.`id_articles_settings`
WHERE (sv.lang = 'pl' OR sv.lang = '')
AND `s`.`id_art` IN('1')
|
| 0.0002 |
SELECT *
FROM `cms_gallery`
WHERE `id_art` = 1
AND `pub` = 1
AND `lang` = 'pl'
|
| 0.0003 |
SELECT `nc`.*, `n`.*
FROM `cms_news` `n`
JOIN `cms_news_content` as `nc` ON `n`.`id` = `nc`.`id_news`
WHERE `n`.`id_art` = 1
AND `n`.`pub` = 1
AND `nc`.`pub` = 1
AND `nc`.`lang` = 'pl'
ORDER BY `nc`.`date_add` DESC
|
| 0.0002 |
SELECT *
FROM `cms_our_shops`
WHERE `pub` = 1
ORDER BY `position` ASC
|
| 0.0006 |
SELECT `tk2`.*, `tk1`.*, `tk3`.`url` as `user_url`
FROM `cms_shop_products_category` as `tk1`
JOIN `cms_shop_products_category_content` as `tk2` ON `tk1`.`id` = `tk2`.`id_cat`
LEFT JOIN `cms_user_url` `tk3` ON `tk3`.`dest_id`=`tk1`.`id` AND `tk3`.`type` = 'shop_products_category' AND `tk3`.`lang` = 'pl'
WHERE `tk1`.`pub` = 1
AND `tk2`.`pub` = 1
AND `tk2`.`lang` = 'pl'
GROUP BY `tk1`.`id`
ORDER BY `tk1`.`position`
|
| 0.0043 |
SELECT `tk2`.*, `tk1`.*, `tk3`.`url` as `user_url`
FROM `cms_shop_products` as `tk1`
JOIN `cms_shop_products_content` as `tk2` ON `tk1`.`id` = `tk2`.`id_pr`
LEFT JOIN `cms_user_url` `tk3` ON `tk3`.`dest_id`=`tk1`.`id` AND `tk3`.`type` = 'shop_products' AND `tk3`.`lang` = 'pl'
WHERE `tk1`.`pub` = 1
AND `tk2`.`pub` = 1
AND `tk2`.`lang` = 'pl'
GROUP BY `tk1`.`id`
ORDER BY `tk1`.`position`
|
| 0.0010 |
SELECT `pi`.*, `p`.`dir`
FROM `cms_shop_products_content_img` as `pi`
JOIN `cms_shop_products` as `p` ON `pi`.`id_pr` = `p`.`id`
WHERE `pi`.`id_pr` IN('167', '250', '103', '113', '139', '141', '142', '143', '144', '145', '146', '147', '148', '149', '150', '151', '152', '154', '181', '194', '220', '225', '253', '254', '256', '257', '258', '129', '132', '135', '104', '124', '126', '127', '128', '130', '131', '133', '134', '136', '137', '138', '155', '169', '182', '195', '221', '238', '251', '37', '46', '48', '50', '72', '74', '76', '78', '80', '82', '84', '86', '88', '105', '123', '156', '170', '183', '198', '222', '239', '255', '38', '47', '51', '54', '199', '73', '75', '77', '79', '81', '83', '85', '87', '89', '122', '157', '171', '184', '223', '240', '121', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '158', '172', '185', '197', '224', '241', '107', '108', '109', '110', '111', '112', '114', '115', '119', '120', '159', '173', '186', '196', '242', '62', '99', '100', '101', '140', '160', '174', '187', '200', '226', '227', '228', '229', '232', '233', '236', '237', '243', '63', '116', '117', '118', '161', '175', '188', '201', '230', '244', '162', '176', '189', '202', '231', '234', '235', '245', '163', '177', '190', '203', '246', '164', '178', '191', '204', '247', '165', '179', '192', '205', '248', '166', '180', '193', '206', '249', '207', '208', '209', '210', '211', '212', '213', '214', '215', '216', '217', '218', '219')
GROUP BY `pi`.`id`
ORDER BY `pi`.`id_pr`, `pi`.`position`
|
| 0.0005 |
SELECT `tk2`.*, `tk1`.*, `tk3`.`url` as `user_url`
FROM `cms_shop_products` as `tk1`
JOIN `cms_shop_products_content` as `tk2` ON `tk1`.`id` = `tk2`.`id_pr`
LEFT JOIN `cms_user_url` `tk3` ON `tk3`.`dest_id`=`tk1`.`id` AND `tk3`.`type` = 'shop_products' AND `tk3`.`lang` = 'pl'
WHERE `tk1`.`pub` = 1
AND `tk2`.`pub` = 1
AND `tk2`.`lang` = 'pl'
AND `tk1`.`main_product` = 1
GROUP BY `tk1`.`id`
ORDER BY `tk1`.`position`
|
| 0.0002 |
SELECT `pi`.*, `p`.`dir`
FROM `cms_shop_products_content_img` as `pi`
JOIN `cms_shop_products` as `p` ON `pi`.`id_pr` = `p`.`id`
WHERE `pi`.`id_pr` IN('139', '93')
GROUP BY `pi`.`id`
ORDER BY `pi`.`id_pr`, `pi`.`position`
|
| 0.0001 |
SELECT *
FROM `cms_slides`
WHERE `pub` = 1
AND `lang` = 'pl'
AND `id_art` = '1'
ORDER BY `position`
|
| 0.0002 |
SELECT `si`.*, `s`.`dir`
FROM `cms_slides_img` as `si`
JOIN `cms_slides` as `s` ON `si`.`id_gal` = `s`.`id`
WHERE `si`.`id_gal` IN('1')
GROUP BY `si`.`id`
ORDER BY `si`.`id_gal`, `si`.`position`
|
| 0.0002 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN(0)
AND `a`.`id_cat` = 1
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0002 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN(0)
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0002 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('47')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0001 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('48')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0001 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('49')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0001 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('50')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0001 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('51')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0001 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('53')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0001 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('61')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0001 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('62')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0002 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('12')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0001 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('59')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0002 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('8')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0001 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('13')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0001 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('29')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0001 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('52')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0002 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('31')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0001 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('32')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0001 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('34')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0002 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('23')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0001 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('46')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0001 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('55')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0001 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('56')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0001 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('60')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0001 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('63')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0001 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('24')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0001 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('25')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0001 |
SELECT `a`.`id`, `a`.`id_cat`, `a`.`id_tree`, `ac`.`id_art`, `ac`.`title`, `ac`.`short_title`, `ac`.`url`, `ac`.`target`, `tk3`.`url` as `user_url`
FROM `cms_articles` as `a`
LEFT JOIN `cms_articles_content` as `ac` ON `a`.`id` = `ac`.`id_art` AND `ac`.`lang` = 'pl'
LEFT JOIN `cms_user_url` as `tk3` ON `a`.`id` = `tk3`.`dest_id` AND `tk3`.`type` = 'articles' AND `tk3`.`lang` = 'pl'
WHERE `a`.`pub` = 1
AND `ac`.`pub` = 1
AND `a`.`id_tree` IN('26')
AND `a`.`id_cat` = 2
ORDER BY `a`.`id_cat`, `a`.`id_tree`, `a`.`position`, `a`.`id`
|
| 0.0001 |
SELECT *
FROM `cms_slides`
WHERE `pub` = 1
AND `lang` = 'pl'
AND `id_art` = 1
ORDER BY `position`
|
| 0.0002 |
SELECT `si`.*, `s`.`dir`
FROM `cms_slides_img` as `si`
JOIN `cms_slides` as `s` ON `si`.`id_gal` = `s`.`id`
WHERE `si`.`id_gal` IN('1')
GROUP BY `si`.`id`
ORDER BY `si`.`id_gal`, `si`.`position`
|
