uress

Banner with extra params (available as placeholders in banner URL):

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

Array
(
    [position] => 1
    [id] => 2
    [name] => parners2
    [url] => [[~46]]
    [image] => /assets/components/industrix-theme/images/car/image008.png
    [source] => 1
    [active] => 1
    [description] => Ремонт грузовой техники Fuso
    [start] => 2018-01-02 20:01:00
    [end] => 2018-01-31 20:01:00
    [adposition] => 7
    [ad] => 2
    [idx] => 1
)
Array
(
    [position] => 1
    [id] => 3
    [name] => hyundai
    [url] => [[~44]]
    [image] => /assets/components/industrix-theme/images/car/image003.png
    [source] => 1
    [active] => 1
    [description] => Ремонт малотоннажной техники hyundai
    [start] => 2018-01-01 20:05:00
    [end] => 2018-01-31 20:05:00
    [adposition] => 8
    [ad] => 3
    [idx] => 2
)
Array
(
    [position] => 1
    [id] => 1
    [name] => partenrs
    [url] => [[~46]]
    [image] => /assets/components/industrix-theme/images/logotype/hino-200.png
    [source] => 1
    [active] => 1
    [description] => Ремонт фургонов и грузовиков Хино
    [start] => 2018-01-02 20:01:00
    [end] => 2018-01-31 02:15:00
    [adposition] => 6
    [ad] => 1
    [idx] => 3
)