Query Times
| Lp | Query | Time[s] |
| 0 | SET NAMES utf8 | 0.000100 |
| 1 |
SELECT
dl.id,
l.symbol AS s_lang
FROM imp_domain_language AS dl
LEFT JOIN imp_language AS l
ON
l.id = dl.id_language
WHERE
l.`for` = '1' AND
dl.id_domain_group = '1' AND
dl.id_domain = '1' AND
dl.enabled = '1'
ORDER BY dl.default DESC
| 0.002839 |
| 2 |
SELECT `index`,value FROM imp_domain_config
WHERE
id_domain_group = '1' AND
id_domain = '1' AND
(id_domain_language IS NULL OR id_domain_language = '4')
| 0.001117 |
| 3 |
SELECT
dc.id,
c.symbol
FROM imp_domain_component AS dc
LEFT JOIN imp_component AS c
ON
dc.id_component = c.id
WHERE
dc.id_domain_group = '1' AND
dc.id_domain = '1' AND
c.symbol IN('c_user_accounts','c_shop','c_tags','c_forum')
| 0.094856 |
| 4 |
SELECT
w.*,
cw.sort AS sort,
cw.area AS area,
c.symbol AS c_symbol,
c.config AS c_config,
cont.symbol AS container,
cat.symbol AS cat_symbol,
cat.path AS cat_path,
cat.ssl AS cat_ssl,
cat.sharing_methods AS cat_sharing_methods,
cat.config AS cat_config,
cat.id_parent AS cat_id_parent
FROM imp_window AS w
LEFT JOIN imp_domain_component AS dc
ON
w.id_domain_component = dc.id AND
w.id_domain_group = dc.id_domain_group AND
w.id_domain = dc.id_domain
LEFT JOIN imp_component AS c
ON
c.id = dc.id_component
LEFT JOIN imp_domain_component_container AS dcc
ON
w.id_domain_group = dcc.id_domain_group AND
w.id_domain = dcc.id_domain AND
w.id_domain_component_container = dcc.id
LEFT JOIN imp_container AS cont
ON
cont.id = dcc.id_container
LEFT JOIN imp_catalog_window AS cw
ON
w.id_domain_language = cw.id_domain_language AND
w.id_domain_group = cw.id_domain_group AND
w.id_domain = cw.id_domain AND
w.id = cw.id_window AND
cw.id_catalog = '3' AND
cw.type = '1'
LEFT JOIN imp_catalog AS cat
ON
w.id_domain_language = cat.id_domain_language AND
w.id_domain_group = cat.id_domain_group AND
w.id_domain = cat.id_domain AND
w.id_catalog = cat.id
WHERE
w.id_domain_group = '1' AND
w.id_domain = '1' AND
w.id_domain_language = '4'
AND cw.area IN(1,69,11,12,100,4,3,2,5,35,31,32)
ORDER BY cw.sort
| 0.116174 |
| 5 |
SELECT
dl.id,
l.name,
l.symbol,
d.domain,
d.domain_dev,
d.domain_local,
d.ssl,
d.www,
do.domain AS do_domain,
do.domain_dev AS do_domain_dev,
do.domain_local AS do_domain_local,
do.ssl AS do_ssl,
do.www AS do_www
FROM imp_domain_language AS dl
LEFT JOIN imp_language AS l
ON
dl.id_language = l.id
LEFT JOIN imp_domain AS d
ON
dl.id = d.alias_id_domain_language
LEFT JOIN imp_domain AS do
ON
dl.id_domain = do.id
WHERE
id_domain = '1' AND
`for` = '1'
| 0.003043 |
| 6 |
SELECT
*,
(SELECT name FROM c_news_image WHERE id_element = n.id ORDER BY is_main DESC LIMIT 1) AS picture
FROM c_news AS n
WHERE
n.publication_date <= CURRENT_DATE AND
(n.unpublication_date IS NULL OR n.unpublication_date > CURRENT_DATE) AND
n.public = '1'
AND ('1970-01-01 01:00:00' <= publication_date)
AND n.id_domain_group = '1'
AND n.id_domain = '1'
AND n.id_domain_language = '4'
AND n.id_catalog = '3'
ORDER BY n.publication_date DESC, id DESC
LIMIT 15 OFFSET 15
| 0.002442 |
| 7 |
SELECT
*
FROM imp_catalog
WHERE
id_domain_group = '1' AND
id_domain = '1' AND
id_domain_language = '4' AND
id_window = '5' AND
public > '0' AND
level <= '5'
ORDER BY
sort ASC
| 0.000327 |
| 8 |
SELECT
*
FROM w_descriptive_window
WHERE
id_domain_group = '1' AND
id_domain = '1' AND
id_domain_language = '4' AND
id_window = '974' AND
public = '1'
ORDER BY sort ASC, id ASC
| 0.000338 |
| 9 |
SELECT
*
FROM w_descriptive_window_image
WHERE
id_element = '26'
AND id_domain_group = '1'
AND id_domain = '1'
AND id_domain_language = '4'
AND id_window = '974'
ORDER BY sort, id
| 0.000191 |
| 10 |
SELECT
*
FROM w_descriptive_window_file
WHERE
id_element = '26'
AND id_domain_group = '1'
AND id_domain = '1'
AND id_domain_language = '4'
AND id_window = '974'
ORDER BY sort, id
| 0.000197 |
| 11 |
SELECT
*
FROM imp_catalog
WHERE
id_domain_group = '1' AND
id_domain = '1' AND
id_domain_language = '4' AND
id_window = '13' AND
public > '0' AND
(
#węzły główne
id_parent IS NULL
OR (parent_symbol = 'aktualnosci' AND level = '2'))
ORDER BY
sort ASC
| 0.000426 |
| 12 |
SELECT
*
FROM imp_catalog
WHERE
id_domain_group = '1' AND
id_domain = '1' AND
id_domain_language = '4' AND
id_window = '957' AND
public > '0' AND
(
#węzły główne
id_parent IS NULL
OR (parent_symbol = 'aktualnosci' AND level = '2'))
ORDER BY
sort ASC
| 0.000404 |
| 13 |
SELECT
*
FROM imp_catalog
WHERE
id_domain_group = '1' AND
id_domain = '1' AND
id_domain_language = '4' AND
id_window = '958' AND
public > '0' AND
(
#węzły główne
id_parent IS NULL
OR (parent_symbol = 'aktualnosci' AND level = '2'))
ORDER BY
sort ASC
| 0.000516 |
| 14 |
SELECT
*
FROM imp_catalog
WHERE
id_domain_group = '1' AND
id_domain = '1' AND
id_domain_language = '4' AND
id_window = '959' AND
public > '0' AND
(
#węzły główne
id_parent IS NULL
OR (parent_symbol = 'aktualnosci' AND level = '2'))
ORDER BY
sort ASC
| 0.000371 |
| SUMA ZAPYTAŃ | 15 |
| SUMA CZASÓW | 0.223341 |
Query Row Times
| Lp | Query | Time[s] |
| 0 |
SELECT
d.*
FROM imp_domain AS d
WHERE
d.domain_dev = 'korpussolidarnosci.gov.pl.dev.agendo.pl' AND
d.enabled = '1'
| 0.000369 |
| 1 |
SELECT
t.*,
dt.id AS dt_id
FROM imp_domain_template dt
LEFT JOIN imp_template AS t
ON
dt.id_template = t.id
WHERE
dt.id_domain_group = '1' AND
dt.id_domain = '1' AND
t.symbol = 'default_modern' AND
t.`for` = '1' AND
dt.enabled = '1'
| 0.001322 |
| 2 |
SELECT
cat.*,
c.symbol AS c_symbol,
c.name AS c_name
FROM imp_catalog AS cat
LEFT JOIN imp_domain_component AS dc
ON
cat.id_domain_component = dc.id AND
cat.id_domain_group = dc.id_domain_group AND
cat.id_domain = dc.id_domain
LEFT JOIN imp_component AS c
ON
c.id = dc.id_component
WHERE
c.symbol = 'c_user_accounts'
AND cat.id_domain_group = '1'
AND cat.id_domain = '1'
AND cat.id_domain_language = '4'
LIMIT 1 OFFSET 0
| 0.003834 |
| 3 |
SELECT
c.*,
comp.symbol AS c_symbol,
comp.config AS c_config,
cont.symbol AS container
FROM imp_catalog AS c
LEFT JOIN imp_domain_component AS dc
ON
c.id_domain_group = dc.id_domain_group AND
c.id_domain = dc.id_domain AND
c.id_domain_component = dc.id
LEFT JOIN imp_component AS comp
ON
comp.id = dc.id_component
LEFT JOIN imp_domain_component_container AS dcc
ON
c.id_domain_group = dcc.id_domain_group AND
c.id_domain = dcc.id_domain AND
c.id_domain_component_container = dcc.id
LEFT JOIN imp_container AS cont
ON
cont.id = dcc.id_container
WHERE
c.id_domain_group = '1' AND
c.id_domain = '1' AND
c.id_domain_language = '4' AND
c.symbol = 'aktualnosci' AND
c.level = '1'
AND c.public != '0'
| 0.099469 |
| 4 |
SELECT
*
FROM imp_catalog
WHERE
id = '4768'
AND id_domain_group = '1'
AND id_domain = '1'
AND id_domain_language = '4'
| 0.000218 |
| 5 |
SELECT
*
FROM imp_catalog
WHERE
id = '4782'
AND id_domain_group = '1'
AND id_domain = '1'
AND id_domain_language = '4'
| 0.000251 |
| 6 |
SELECT
*
FROM imp_catalog
WHERE
id = '42'
AND id_domain_group = '1'
AND id_domain = '1'
AND id_domain_language = '4'
| 0.000230 |
| SUMA ZAPYTAŃ | 7 |
| SUMA CZASÓW | 0.105693 |
Query One Times
| Lp | Query | Time[s] |
| 0 |
SELECT
set_time
FROM imp_sessions
WHERE
id_domain_group = '1' AND
id = '9dno7cucio9jrbun05lsl54bpv'
LIMIT 1 OFFSET 0
| 0.000178 |
| 1 |
SELECT value FROM imp_domain_config
WHERE
id_domain_group = '1' AND
id_domain = '1' AND
id_domain_language IS NULL AND
`index` = 'check_redirections'
| 0.000560 |
| 2 |
SELECT
ap.id
FROM imp_domain_admin_pages AS dap
LEFT JOIN imp_admin_pages AS ap
ON
dap.id_admin_page = ap.id
WHERE
dap.id_domain_group = '1' AND
dap.id_domain = '1' AND
ap.enabled = '1' AND
dap.enabled = '1' AND
ap.symbol_module = 'm_http_status'
| 0.038797 |
| 3 |
SELECT value FROM imp_domain_config
WHERE
id_domain_group = '1' AND
id_domain = '1' AND
id_domain_language IS NULL AND
`index` = 'defaultLangClientApi'
| 0.001173 |
| 4 | CALL getTypeLayoutConfig(3, '/aktualnosci/page2.html', FALSE); | 0.001881 |
| 5 |
SELECT
layout
FROM imp_catalog_layouts
WHERE
id_catalog = '3' AND
request_uri IS NULL AND
type = '1'
AND id_domain_group = '1'
AND id_domain = '1'
AND id_domain_language = '4'
| 0.000554 |
| 6 | CALL getTypeCatalogWindowsConfig(3, '/aktualnosci/page2.html', FALSE); | 0.001467 |
| 7 |
SELECT
id
FROM imp_catalog_window
WHERE
id_domain_group = '1' AND
id_domain = '1' AND
id_domain_language = '4' AND
type = '1' AND
id_catalog = '3'
LIMIT 1 OFFSET 0
| 0.000430 |
| 8 |
SELECT
COUNT(*)
FROM c_news
WHERE
publication_date <= CURRENT_DATE AND
(unpublication_date IS NULL OR unpublication_date > CURRENT_DATE) AND
public = '1'
AND id_domain_group = '1'
AND id_domain = '1'
AND id_domain_language = '4'
AND id_catalog = '3'
AND ('1970-01-01 01:00:00' <= publication_date)
| 0.087676 |
| SUMA ZAPYTAŃ | 9 |
| SUMA CZASÓW | 0.132716 |