Query Times
| Lp | Query | Time[s] |
| 0 | SET NAMES utf8 | 0.000065 |
| 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.000147 |
| 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.000660 |
| 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.000157 |
| 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.000347 |
| 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.000137 |
| 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.000664 |
| 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.000584 |
| 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.000438 |
| 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.000141 |
| 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.000109 |
| 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.000276 |
| 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.000266 |
| 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.000174 |
| 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.000230 |
| SUMA ZAPYTAŃ | 15 |
| SUMA CZASÓW | 0.004395 |
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.000246 |
| 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.000131 |
| 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.000244 |
| 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.000293 |
| 4 |
SELECT
*
FROM imp_catalog
WHERE
id = '4768'
AND id_domain_group = '1'
AND id_domain = '1'
AND id_domain_language = '4'
| 0.000140 |
| 5 |
SELECT
*
FROM imp_catalog
WHERE
id = '4782'
AND id_domain_group = '1'
AND id_domain = '1'
AND id_domain_language = '4'
| 0.000200 |
| 6 |
SELECT
*
FROM imp_catalog
WHERE
id = '42'
AND id_domain_group = '1'
AND id_domain = '1'
AND id_domain_language = '4'
| 0.000202 |
| SUMA ZAPYTAŃ | 7 |
| SUMA CZASÓW | 0.001456 |
Query One Times
| Lp | Query | Time[s] |
| 0 |
SELECT
set_time
FROM imp_sessions
WHERE
id_domain_group = '1' AND
id = '0aieldg61q0p5lf8mujphi92d6'
LIMIT 1 OFFSET 0
| 0.000086 |
| 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.000363 |
| 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.000197 |
| 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.000306 |
| 4 | CALL getTypeLayoutConfig(3, '/aktualnosci/page2.html', FALSE); | 0.000265 |
| 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.000086 |
| 6 | CALL getTypeCatalogWindowsConfig(3, '/aktualnosci/page2.html', FALSE); | 0.000324 |
| 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.000105 |
| 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.000169 |
| SUMA ZAPYTAŃ | 9 |
| SUMA CZASÓW | 0.001901 |