| 0.0002 |
SELECT GET_LOCK('bc7f188678a7fa8a6e853eeba33e0f6f672dd9ba_127.0.0.1', 300) AS ci_session_lock
|
| 0.0003 |
SELECT `data`
FROM `cms_sessions`
WHERE `id` = 'bc7f188678a7fa8a6e853eeba33e0f6f672dd9ba'
AND `ip_address` = '127.0.0.1'
|
| 0.0001 |
SELECT *
FROM `cms_lang`
WHERE `pub` = 1
ORDER BY `position`
|
| 0.0001 |
SELECT `tk2`.*, `tk1`.*, `tk3`.`id_art` as `parent_id`, `tk3`.`title` as `parent_title`, `tk4`.`url` as `user_url`
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'
WHERE `tk1`.`id` = 1
AND `tk1`.`pub` = 1
AND `tk2`.`pub` = 1
AND `tk2`.`lang` = 'pl'
|
| 0.0002 |
SELECT `tk2`.*, `tk1`.*, `tk3`.`id_art` as `parent_id`, `tk3`.`title` as `parent_title`, `tk4`.`url` as `user_url`
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'
WHERE `tk1`.`id` = '0'
AND `tk1`.`pub` = 1
AND `tk2`.`pub` = 1
AND `tk2`.`lang` = 'pl'
|
| 0.0001 |
SELECT *
FROM `cms_settings`
WHERE `lang` = 'pl'
|
| 0.0001 |
SELECT *
FROM `cms_articles`
WHERE `id` = 1
|
| 0.0001 |
SELECT `tk2`.*, `tk1`.*, `tk3`.`id_art` as `parent_id`, `tk3`.`title` as `parent_title`, `tk4`.`url` as `user_url`
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'
WHERE `tk1`.`id` = 1
AND `tk1`.`pub` = 1
AND `tk2`.`pub` = 1
AND `tk2`.`lang` = 'pl'
|
| 0.0001 |
SELECT *
FROM `cms_contact`
WHERE `id_art` = 1
AND `lang` = 'pl'
|
| 0.0001 |
SELECT *
FROM `cms_gallery`
WHERE `id_art` = 1
AND `pub` = 1
AND `lang` = 'pl'
ORDER BY `position`
|
| 0.0001 |
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.0001 |
SELECT tk1.id, tk1.id_cat, tk1.id_tree, tk2.id_art, tk2.title, tk2.short_title, tk2.url, tk2.target, tk3.url as user_url
FROM `cms_articles` as `tk1`
LEFT JOIN `cms_articles_content` as `tk2` ON `tk1`.`id` = `tk2`.`id_art`
LEFT JOIN `cms_user_url` as `tk3` ON `tk1`.`id` = `tk3`.`dest_id` AND `tk3`.`type`='articles' AND `tk3`.`lang`= 'pl'
WHERE `tk1`.`pub` = 1
AND `tk2`.`pub` = 1
AND `tk1`.`id_cat` = 1
AND `tk2`.`lang` = 'pl'
ORDER BY `tk1`.`id_cat`, `tk1`.`id_tree`, `tk1`.`position`, `tk1`.`id`
|
| 0.0001 |
SELECT *
FROM `cms_slides`
WHERE `pub` = 1
AND `lang` = 'pl'
AND `id_art` = 1
ORDER BY `position`
|
| 0.0001 |
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('2')
GROUP BY `si`.`id`
ORDER BY `si`.`id_gal`, `si`.`position`
|
| 0.0013 |
SELECT `nc`.*, `n`.*
FROM `cms_news` `n`
JOIN `cms_news_content` as `nc` ON `n`.`id` = `nc`.`id_news`
WHERE `n`.`id_art` = 2
AND `n`.`pub` = 1
AND `nc`.`pub` = 1
AND `nc`.`lang` = 'pl'
ORDER BY `nc`.`date_add` DESC
|
| 0.0002 |
SELECT `nc`.*, `n`.*, `uu`.`url` as `user_url`
FROM `cms_news` `n`
JOIN `cms_news_content` as `nc` ON `n`.`id` = `nc`.`id_news`
LEFT JOIN `cms_user_url` `uu` ON `uu`.`dest_id`=`n`.`id` AND `uu`.`type` = 'news' AND `uu`.`lang` = 'pl'
WHERE `n`.`id_art` = 2
AND `n`.`pub` = 1
AND `nc`.`pub` = 1
AND `nc`.`lang` = 'pl'
ORDER BY `nc`.`date_add` DESC
LIMIT 11
|
