Nr |
0 |
Execution time |
0,001216 |
SELECT `value` FROM `fw_var` AS `V`
INNER JOIN `fw_settings` AS `S` ON (`S`.`var_id` = `V`.id AND `V`.`key` =
"timeZone") |
framework/loader.front.php frontend_loader->getSettings() line 198 |
Nr |
1 |
Execution time |
7,8E-500 |
SELECT `L`.`id`, `V`.`value` AS `timezone` FROM `fw_country` AS `C`
LEFT JOIN `fw_var` AS `V` ON (`V`.`id` = `C`.`var_timezone_id`)
LEFT JOIN `fw_language` AS `L` ON (`L`.`id` = `C`.`language_id`)
WHERE `L`.`code` = 'nl_NL' |
framework/language.front.php language_front->setLanguage() line 49 |
Nr |
2 |
Execution time |
0,000741 |
SELECT `P`.`id`, `PC`.`title`, `PC`.`meta_tags` , `PC`.`meta_description`
FROM `cms_page` AS `P`
INNER JOIN `cms_page_country` AS `PC` ON (`P`.`id` = `PC`.`page_id` AND
`PC`.`deleted` = "n")
INNER JOIN `fw_country` AS `C` ON (`C`.`id` = `PC`.`country_id` AND
`C`.`deleted` = "n")
WHERE LOWER(`P`.`name`) = 'fotos'
AND `C`.`language_id` = 1
AND `P`.`deleted` = "n"
AND `P`.`parent_page_id`IN (SELECT `id` FROM `cms_page` WHERE LOWER(`name`) =
'10')
ORDER BY P.id DESC |
cms/frontend/modules/pagecontent.php pagecontent->__construct() line 65 |
Nr |
3 |
Execution time |
0,000209 |
SELECT `id`,`name`, `foto1`
FROM `cm_portfolio`
WHERE deleted = "n"
AND `foto1` != ""
ORDER BY `id` DESC |
cms/custom/modules/portfolio.frontend.php portfolio->showOverview() line 125 |
Nr |
4 |
Execution time |
4,900000 |
SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 18
AND `I`.`deleted` = "n"
LIMIT 0,1
|
cms/custom/modules/portfolio.frontend.php portfolio->getDefaultImages() line 29 |
Nr |
5 |
Execution time |
3,800000 |
SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 18
AND `I`.`deleted` = "n"
LIMIT 0,1
|
cms/custom/modules/portfolio.frontend.php portfolio->getDefaultImages() line 29 |
Nr |
6 |
Execution time |
3,999999 |
SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 10
AND `I`.`deleted` = "n"
LIMIT 0,1
|
cms/custom/modules/portfolio.frontend.php portfolio->getDefaultImages() line 29 |
Nr |
7 |
Execution time |
4,099999 |
SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 10
AND `I`.`deleted` = "n"
LIMIT 0,1
|
cms/custom/modules/portfolio.frontend.php portfolio->getDefaultImages() line 29 |
Nr |
8 |
Execution time |
3,699999 |
SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 9
AND `I`.`deleted` = "n"
LIMIT 0,1
|
cms/custom/modules/portfolio.frontend.php portfolio->getDefaultImages() line 29 |
Nr |
9 |
Execution time |
4,2E-500 |
SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 9
AND `I`.`deleted` = "n"
LIMIT 0,1
|
cms/custom/modules/portfolio.frontend.php portfolio->getDefaultImages() line 29 |
Nr |
10 |
Execution time |
3,699999 |
SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 8
AND `I`.`deleted` = "n"
LIMIT 0,1
|
cms/custom/modules/portfolio.frontend.php portfolio->getDefaultImages() line 29 |
Nr |
11 |
Execution time |
4,2E-500 |
SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 8
AND `I`.`deleted` = "n"
LIMIT 0,1
|
cms/custom/modules/portfolio.frontend.php portfolio->getDefaultImages() line 29 |
Nr |
12 |
Execution time |
4,099999 |
SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 6
AND `I`.`deleted` = "n"
LIMIT 0,1
|
cms/custom/modules/portfolio.frontend.php portfolio->getDefaultImages() line 29 |
Nr |
13 |
Execution time |
3,999999 |
SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 6
AND `I`.`deleted` = "n"
LIMIT 0,1
|
cms/custom/modules/portfolio.frontend.php portfolio->getDefaultImages() line 29 |
Nr |
14 |
Execution time |
4,700000 |
SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 5
AND `I`.`deleted` = "n"
LIMIT 0,1
|
cms/custom/modules/portfolio.frontend.php portfolio->getDefaultImages() line 29 |
Nr |
15 |
Execution time |
4,600000 |
SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 5
AND `I`.`deleted` = "n"
LIMIT 0,1
|
cms/custom/modules/portfolio.frontend.php portfolio->getDefaultImages() line 29 |
Nr |
16 |
Execution time |
5,100000 |
SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 4
AND `I`.`deleted` = "n"
LIMIT 0,1
|
cms/custom/modules/portfolio.frontend.php portfolio->getDefaultImages() line 29 |
Nr |
17 |
Execution time |
3,999999 |
SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 4
AND `I`.`deleted` = "n"
LIMIT 0,1
|
cms/custom/modules/portfolio.frontend.php portfolio->getDefaultImages() line 29 |
Nr |
18 |
Execution time |
4,000000 |
SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 1
AND `I`.`deleted` = "n"
LIMIT 0,1
|
cms/custom/modules/portfolio.frontend.php portfolio->getDefaultImages() line 29 |
Nr |
19 |
Execution time |
3,400000 |
SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 1
AND `I`.`deleted` = "n"
LIMIT 0,1
|
cms/custom/modules/portfolio.frontend.php portfolio->getDefaultImages() line 29 |
Nr |
20 |
Execution time |
0,003748 |
SELECT *
FROM `cm_portfolio`
WHERE deleted = "n" AND `id` = 10 |
cms/custom/modules/portfolio.frontend.php portfolio->showDetails() line 258 |
Nr |
21 |
Execution time |
8,099999 |
SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 10
AND `I`.`deleted` = "n"
LIMIT 0,1
|
cms/custom/modules/portfolio.frontend.php portfolio->getDefaultImages() line 29 |
Nr |
22 |
Execution time |
5,800000 |
SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 10
AND `I`.`deleted` = "n"
LIMIT 0,1
|
cms/custom/modules/portfolio.frontend.php portfolio->getDefaultImages() line 29 |
Nr |
23 |
Execution time |
0,001391 |
SELECT `I`.`id`, `I`.`image`
FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
WHERE `PI`.`product_id` = 10
AND `I`.`deleted` = "n"
|
cms/custom/modules/portfolio.frontend.php portfolio->getSlideshowImages() line 90 |