Общо Време за генериране на цялата страницата (От index.php до debugger.phtml (Всичко))
тип на заявка |
време (ms) |
завършена |
заявка |
CONNECT |
0.26 ms |
1 |
connect |
QUERY |
0.065 ms |
1 |
SET NAMES utf8 |
SELECT |
0.361 ms |
1 |
SELECT `sessions`.* FROM `sessions` WHERE (((`sessions`.`sUID` = 'fmm5fd1mn2uu2nauqiqnq6m47v'))) |
SELECT |
0.065 ms |
1 |
SELECT `l`.*, `ll`.`nUID` AS `nLocaleID`, `ll`.`sLocale` FROM `languages` AS `l`
INNER JOIN `language_locales` AS `ll` ON l.nUID = ll.nLanguageID AND ll.nPublished = 1 AND ll.nDeleted = 0 WHERE (l.nDefault = 1) GROUP BY `l`.`nUID` ORDER BY `ll`.`nOrder` ASC LIMIT 1 |
SELECT |
0.422 ms |
1 |
SELECT `reqc`.* FROM `request_connections` AS `reqc`
INNER JOIN `requests` AS `r` ON reqc.nRequestID = r.nUID WHERE (IFNULL(`r`.`sModuleName`, 'eshop3') = 'eshop3') AND (IFNULL(`r`.`sControllerName`, 'cart') = 'cart') AND (IFNULL(`r`.`sActionName`, 'view') = 'view') |
SELECT |
0.918 ms |
1 |
SELECT `w`.*, `w`.`nUID` AS `nWidgetID`, `wt`.`nAdmin`, `wt`.`sPhtml`, `m`.`sName` AS `sModule` FROM `widgets` AS `w`
INNER JOIN `widget_templates` AS `wt` ON w.nWidgetTemplateID = wt.nUID
INNER JOIN `modules` AS `m` ON wt.nModuleID = m.nUID WHERE (w.nDeleted = 0) AND (wt.nAdmin = 0) AND (w.nPublished = 1) AND (w.nUID IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 41, 39, 40)) ORDER BY `sPosition` ASC, `nOrder` ASC |
SELECT |
0.112 ms |
1 |
SELECT `widget_parameters`.* FROM `widget_parameters` WHERE (nWidgetID IN (41, 65, 38, 59, 60, 33, 11, 26, 3, 53, 52, 15, 25, 32, 36, 6, 24, 31, 50, 54, 56, 61, 62, 63, 39, 40, 55, 49, 22, 1, 58, 8, 21, 30, 42, 7, 20, 29, 45, 46, 47, 19, 28, 9, 64, 66, 14, 44, 27, 12, 57, 51, 18, 13, 10, 17, 5, 67, 16, 2)) |
SELECT |
0.065 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 20) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.054 ms |
1 |
SELECT `menus_menus`.* FROM `menus_menus` WHERE (((`menus_menus`.`nUID` = 16))) |
SELECT |
0.058 ms |
1 |
SELECT `i`.* FROM `menus_items` AS `i` WHERE (i.nDeleted = 0) AND (IFNULL(i.nLangID, '1') = '1') AND (i.nPublished = 1) AND (i.nMenuID = '16') ORDER BY `i`.`nParentID` ASC, `i`.`nOrder` ASC |
SELECT |
0.115 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 17) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.045 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 36) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.045 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 37) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.05 ms |
1 |
SELECT `menus_menus`.* FROM `menus_menus` WHERE (((`menus_menus`.`nUID` = 12))) |
SELECT |
0.055 ms |
1 |
SELECT `i`.* FROM `menus_items` AS `i` WHERE (i.nDeleted = 0) AND (IFNULL(i.nLangID, '1') = '1') AND (i.nPublished = 1) AND (i.nMenuID = '12') ORDER BY `i`.`nParentID` ASC, `i`.`nOrder` ASC |
SELECT |
0.043 ms |
1 |
SELECT `menus_menus`.* FROM `menus_menus` WHERE (((`menus_menus`.`nUID` = 6))) |
SELECT |
0.062 ms |
1 |
SELECT `i`.* FROM `menus_items` AS `i` WHERE (i.nDeleted = 0) AND (IFNULL(i.nLangID, '1') = '1') AND (i.nPublished = 1) AND (i.nMenuID = '6') ORDER BY `i`.`nParentID` ASC, `i`.`nOrder` ASC |
SELECT |
0.1 ms |
1 |
SELECT `menus_menus`.* FROM `menus_menus` WHERE (((`menus_menus`.`nUID` = 9))) |
SELECT |
0.042 ms |
1 |
SELECT `i`.* FROM `menus_items` AS `i` WHERE (i.nDeleted = 0) AND (IFNULL(i.nLangID, '1') = '1') AND (i.nPublished = 1) AND (i.nMenuID = '9') ORDER BY `i`.`nParentID` ASC, `i`.`nOrder` ASC |
SELECT |
0.038 ms |
1 |
SELECT `menus_menus`.* FROM `menus_menus` WHERE (((`menus_menus`.`nUID` = 2))) |
SELECT |
0.04 ms |
1 |
SELECT `i`.* FROM `menus_items` AS `i` WHERE (i.nDeleted = 0) AND (IFNULL(i.nLangID, '1') = '1') AND (i.nPublished = 1) AND (i.nMenuID = '2') ORDER BY `i`.`nParentID` ASC, `i`.`nOrder` ASC |
SELECT |
0.118 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 29) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.066 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 30) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.055 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 7) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.06 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 14) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.06 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 7) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.106 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 1) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.056 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 13) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.053 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 1) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.053 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 27) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.045 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 31) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.039 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 32) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.036 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 38) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.048 ms |
1 |
SELECT `menus_menus`.* FROM `menus_menus` WHERE (((`menus_menus`.`nUID` = 14))) |
SELECT |
0.041 ms |
1 |
SELECT `i`.* FROM `menus_items` AS `i` WHERE (i.nDeleted = 0) AND (IFNULL(i.nLangID, '1') = '1') AND (i.nPublished = 1) AND (i.nMenuID = '14') ORDER BY `i`.`nParentID` ASC, `i`.`nOrder` ASC |
SELECT |
0.053 ms |
1 |
SELECT `menus_menus`.* FROM `menus_menus` WHERE (((`menus_menus`.`nUID` = 15))) |
SELECT |
0.047 ms |
1 |
SELECT `i`.* FROM `menus_items` AS `i` WHERE (i.nDeleted = 0) AND (IFNULL(i.nLangID, '1') = '1') AND (i.nPublished = 1) AND (i.nMenuID = '15') ORDER BY `i`.`nParentID` ASC, `i`.`nOrder` ASC |
SELECT |
0.052 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 18) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.072 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 19) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.084 ms |
1 |
SELECT `em`.`nUID`, `em`.`sLogoExtension`, `emi`.`sName`, `emi`.`sDescription` FROM `eshop3_mills` AS `em`
INNER JOIN `eshop3_mills_i18n` AS `emi` ON em.nUID = emi.nMillID AND emi.nDeleted = 0 AND emi.nLangID =1 WHERE (em.nDeleted = 0) AND (em.nDeleted = 0) AND (em.nPublished = 1) ORDER BY `em`.`nOrder` DESC LIMIT 12 |
SELECT |
0.056 ms |
1 |
SELECT `menus_menus`.* FROM `menus_menus` WHERE (((`menus_menus`.`nUID` = 13))) |
SELECT |
0.053 ms |
1 |
SELECT `i`.* FROM `menus_items` AS `i` WHERE (i.nDeleted = 0) AND (IFNULL(i.nLangID, '1') = '1') AND (i.nPublished = 1) AND (i.nMenuID = '13') ORDER BY `i`.`nParentID` ASC, `i`.`nOrder` ASC |
SELECT |
0.057 ms |
1 |
SELECT `menus_menus`.* FROM `menus_menus` WHERE (((`menus_menus`.`nUID` = 10))) |
SELECT |
0.042 ms |
1 |
SELECT `i`.* FROM `menus_items` AS `i` WHERE (i.nDeleted = 0) AND (IFNULL(i.nLangID, '1') = '1') AND (i.nPublished = 1) AND (i.nMenuID = '10') ORDER BY `i`.`nParentID` ASC, `i`.`nOrder` ASC |
SELECT |
0.04 ms |
1 |
SELECT `menus_menus`.* FROM `menus_menus` WHERE (((`menus_menus`.`nUID` = 3))) |
SELECT |
0.047 ms |
1 |
SELECT `i`.* FROM `menus_items` AS `i` WHERE (i.nDeleted = 0) AND (IFNULL(i.nLangID, '1') = '1') AND (i.nPublished = 1) AND (i.nMenuID = '3') ORDER BY `i`.`nParentID` ASC, `i`.`nOrder` ASC |
SELECT |
0.04 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 35) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.035 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 3) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.039 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 12) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.027 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 3) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.037 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 21) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.031 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 2) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.027 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 11) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.027 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 2) AND (nDeleted = 0) LIMIT 1 |
SELECT |
3.003 ms |
1 |
SELECT `eo`.`nUID`, `eo`.`nAvgRate`, `eo`.`sReview`, `u`.`sName`, `u`.`sLastName`, CONCAT(u.sName, " ", u.sLastName) AS `sContactName` FROM `eshop3_orders` AS `eo`
INNER JOIN `users` AS `u` ON eo.nUserID = u.nUID WHERE (nAvgRate > 0) AND (LENGTH(eo.sReview) >= 100) AND (u.sName != '') AND (eo.nReviewHide = 0) ORDER BY rand() ASC LIMIT 12 |
SELECT |
0.23 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 24) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.179 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 25) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.071 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 10) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.045 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 4) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.04 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 4) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.043 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 39) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.045 ms |
1 |
SELECT `menus_menus`.* FROM `menus_menus` WHERE (((`menus_menus`.`nUID` = 17))) |
SELECT |
0.074 ms |
1 |
SELECT `i`.* FROM `menus_items` AS `i` WHERE (i.nDeleted = 0) AND (IFNULL(i.nLangID, '1') = '1') AND (i.nPublished = 1) AND (i.nMenuID = '17') ORDER BY `i`.`nParentID` ASC, `i`.`nOrder` ASC |
SELECT |
0.121 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 9) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.053 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 5) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.11 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 33) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.055 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 28) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.082 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 8) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.042 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 6) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.068 ms |
1 |
SELECT `menus_menus`.* FROM `menus_menus` WHERE (((`menus_menus`.`nUID` = 11))) |
SELECT |
0.059 ms |
1 |
SELECT `i`.* FROM `menus_items` AS `i` WHERE (i.nDeleted = 0) AND (IFNULL(i.nLangID, '1') = '1') AND (i.nPublished = 1) AND (i.nMenuID = '11') ORDER BY `i`.`nParentID` ASC, `i`.`nOrder` ASC |
SELECT |
0.053 ms |
1 |
SELECT `menus_menus`.* FROM `menus_menus` WHERE (((`menus_menus`.`nUID` = 5))) |
SELECT |
0.048 ms |
1 |
SELECT `i`.* FROM `menus_items` AS `i` WHERE (i.nDeleted = 0) AND (IFNULL(i.nLangID, '1') = '1') AND (i.nPublished = 1) AND (i.nMenuID = '5') ORDER BY `i`.`nParentID` ASC, `i`.`nOrder` ASC |
SELECT |
0.054 ms |
1 |
SELECT `blocks`.* FROM `content_blocks` AS `blocks` WHERE (blocks.nDeleted = 0) AND (nUID = 40) AND (nDeleted = 0) LIMIT 1 |
SELECT |
0.046 ms |
1 |
SELECT `menus_menus`.* FROM `menus_menus` WHERE (((`menus_menus`.`nUID` = 8))) |
SELECT |
0.052 ms |
1 |
SELECT `i`.* FROM `menus_items` AS `i` WHERE (i.nDeleted = 0) AND (IFNULL(i.nLangID, '1') = '1') AND (i.nPublished = 1) AND (i.nMenuID = '8') ORDER BY `i`.`nParentID` ASC, `i`.`nOrder` ASC |
SELECT |
0.055 ms |
1 |
SELECT `menus_menus`.* FROM `menus_menus` WHERE (((`menus_menus`.`nUID` = 1))) |
SELECT |
0.056 ms |
1 |
SELECT `i`.* FROM `menus_items` AS `i` WHERE (i.nDeleted = 0) AND (IFNULL(i.nLangID, '1') = '1') AND (i.nPublished = 1) AND (i.nMenuID = '1') ORDER BY `i`.`nParentID` ASC, `i`.`nOrder` ASC |
SELECT |
0.147 ms |
1 |
SELECT `ecurr`.`nUID`, `ecurr`.`sSymbol`, `ell`.`sLocale` FROM `eshop3_currencies` AS `ecurr`
INNER JOIN `eshop3_conn_currency_locales` AS `eccl` ON ecurr.nUID = eccl.nCurrencyID AND eccl.nDeleted = 0
INNER JOIN `language_locales` AS `ell` ON eccl.nLanguageLocaleID = ell.nUID AND ell.nDeleted = 0 WHERE (ecurr.nDeleted = 0) AND (eccl.nLanguageLocaleID = 1) LIMIT 1 |
SELECT |
0.083 ms |
1 |
SELECT `ecc`.*, `ec`.`sName` FROM `eshop3_courier_charges` AS `ecc`
INNER JOIN `eshop3_couriers` AS `ec` ON ec.nUID = ecc.nCourierID AND ecc.nDeleted = 0
INNER JOIN `language_locales` AS `ll` ON ec.nLocaleID = ll.nUID AND ll.nPublished = 1 AND ll.nDeleted = 0 WHERE (ecc.nDeleted = 0) AND (ll.nUID = 1) ORDER BY `ec`.`nOrder` ASC LIMIT 1 |
SELECT |
0.049 ms |
1 |
SELECT `wp`.* FROM `widget_parameters` AS `wp`
INNER JOIN `widgets` AS `w` ON wp.nWidgetID = w.nUID AND w.nPublished = 1 WHERE (w.sPosition = 'poll-bar') |
SELECT |
0.062 ms |
1 |
SELECT `ecurr`.`nUID`, `ecurr`.`sSymbol`, `ell`.`sLocale` FROM `eshop3_currencies` AS `ecurr`
INNER JOIN `eshop3_conn_currency_locales` AS `eccl` ON ecurr.nUID = eccl.nCurrencyID AND eccl.nDeleted = 0
INNER JOIN `language_locales` AS `ell` ON eccl.nLanguageLocaleID = ell.nUID AND ell.nDeleted = 0 WHERE (ecurr.nDeleted = 0) AND (eccl.nLanguageLocaleID = 1) LIMIT 1 |
QUERY |
0.607 ms |
1 |
DESCRIBE `eshop3_coupons` |
SELECT |
6.358 ms |
1 |
SELECT `ecoup`.* FROM `eshop3_coupons` AS `ecoup` WHERE (ecoup.nDeleted = 0) AND (IFNULL(ecoup.nLangID, '1') = '1') AND (ecoup.sCode = 'testdiscount') AND (ecoup.dStartPeriod <= NOW()) AND (ecoup.dEndPeriod >= NOW()) AND (ecoup.nCurrencyID = '3') AND (ecoup.nPublished = 1) |
QUERY |
0.603 ms |
1 |
DESCRIBE `eshop3_user_addresses` |
SELECT |
0.106 ms |
1 |
SELECT `seo`.* FROM `seo` WHERE (nUID = 3) OR (nParentID = 3 AND nLangID = 1) |
SELECT |
0.185 ms |
1 |
SELECT VERSION() |
Общо време |
17.601 ms |
|
|