Избранное / uress / Пользователи / Русскоязычное сообщество MODX

uress 03 января 2018, 22:02

0.0000141: xPDO query object created
0.0002689: innerJoined byAdPosition as byAdPosition
0.0000031: Grouped by byAd.id
0.0000780: Added selection of byAd: SQL_CALC_FOUND_ROWS `id`, `name`, `url`, `image`, `source`, `active`, `description`, `start`, `end`
0.0000401: Added selection of byAdPosition: `id` as `adposition`, `ad`
0.0000780: Added where condition: 0=(byAd.start IS NULL OR byAd.start <= '2018-01-03 22:01:31') AND (byAd.end IS NULL OR byAd.end >= '2018-01-03 22:01:31'), byAd.active=1, byAdPosition.position=partners
0.0000961: Sorted by RAND(), ASC
0.0000031: Limited to 5, offset 0
0.0001740: SQL prepared "SELECT SQL_CALC_FOUND_ROWS `byAd`.`id`, `byAd`.`name`, `byAd`.`url`, `byAd`.`image`, `byAd`.`source`, `byAd`.`active`, `byAd`.`description`, `byAd`.`start`, `byAd`.`end`, `byAdPosition`.`id` as `adposition`, `byAdPosition`.`ad` FROM `modx_bannery_ads` AS `byAd` JOIN `modx_bannery_ads_positions` `byAdPosition` ON byAd.id = byAdPosition.ad WHERE  ( (byAd.start IS NULL OR byAd.start <= '2018-01-03 22:01:31') AND (byAd.end IS NULL OR byAd.end >= '2018-01-03 22:01:31') AND `byAd`.`active` = 1 AND `byAdPosition`.`position` = 'partners' )  GROUP BY byAd.id ORDER BY RAND() ASC LIMIT 5 "
0.0003989: SQL executed
0.0000541: Total rows: 0
0.0000072: Rows fetched
0.0000079: Returning raw data
0.0041630: Total time
4 194 304: Memory usage

Вопросы BannerY не работает позиция 13