EXPLAIN не можливий для запиту: UPDATE `sowc4_extensions`
SET `params` = '{\"mediaversion\":\"43fc9d06c195a824feca52314db585ff\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Витрачений час на запит: 0.38 ms Після останнього запиту: 161.38 msЗапит пам'яті: 0.022 MB пам'ять до запиту: 7.987 MBПовернуто рядків: 3
SELECT a.filename as filename, a.type as type, a.menulink as menulink FROMsowc4_phocagallery_stylesAS a WHERE a.published = 1 ORDERBY a.type, a.ordering ASC
Витрачений час на запит: 1161.37 ms Після останнього запиту: 5.50 msЗапит пам'яті: 0.094 MB пам'ять до запиту: 8.423 MBПовернуто рядків: 47
SELECT cc.*, a.catid, COUNT(a.id) AS numlinks, u.username AS username, r.count AS ratingcount, r.average AS ratingaverage, uc.avatar AS avatar, uc.approved AS avatarapproved, uc.published AS avatarpublished, a.filename, a.exts, a.extm, a.extw, a.exth, CASEWHENCHAR_LENGTH(cc.alias) THENCONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as slug FROMsowc4_phocagallery_categoriesAS cc LEFTJOINsowc4_phocagalleryAS a ON a.catid = cc.id and a.published = 1 LEFTJOINsowc4_phocagallery_userAS uc ON uc.userid = cc.owner_id LEFTJOINsowc4_usersAS u ON u.id = cc.owner_id LEFTJOINsowc4_phocagallery_votes_statisticsAS r ON r.catid = cc.id WHERE cc.published = 1 AND cc.approved = 1 GROUPBY cc.id ORDERBY cc.ordering DESC
7 типи запитів: зареєстрований, відсортований за знайденим
Вибірка таблиць:
1 × SELECT `session_id` FROM `sowc4_session`
1 × SELECT id, rules FROM `sowc4_viewlevels
1 × SELECT b.id FROMsowc4_usergroupsAS a LEFTJOINsowc4_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT a.filename as filename, a.type as type, a.menulink as menulink FROMsowc4_phocagallery_stylesAS a
1 × SELECT cc.*, a.catid, COUNT(a.id) AS numlinks, u.username AS username, r.count AS ratingcount, r.average AS ratingaverage, uc.avatar AS avatar, uc.approved AS avatarapproved, uc.published AS avatarpublished, a.filename, a.exts, a.extm, a.extw, a.exth, CASEWHENCHAR_LENGTH(cc.alias) THENCONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as slug FROMsowc4_phocagallery_categoriesAS cc LEFTJOINsowc4_phocagalleryAS a ON a.catid = cc.id and a.published = 1 LEFTJOINsowc4_phocagallery_userAS uc ON uc.userid = cc.owner_id LEFTJOINsowc4_usersAS u ON u.id = cc.owner_id LEFTJOINsowc4_phocagallery_votes_statisticsAS r ON r.catid = cc.id