Витрачений час на запит: 0.59 ms Після останнього запиту: 9.91 msЗапит пам'яті: 0.006 MB пам'ять до запиту: 3.054 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
Витрачений час на запит: 9.21 ms Після останнього запиту: 4.64 msЗапит пам'яті: 0.007 MB пам'ять до запиту: 3.141 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