Exception detected!

An exception has been thrown during the rendering of a template ("No mapping found for [title.raw] in order to sort on [reason: all shards failed]") in ::widgets/results/results-listing.html.twig at line 19.

500 Internal Server Error - Twig_Error_Runtime
1 linked Exception:
  • ResponseException »

[2/2] Twig_Error_Runtime: An exception has been thrown during the rendering of a template ("No mapping found for [title.raw] in order to sort on [reason: all shards failed]") in ::widgets/results/results-listing.html.twig at line 19.  +

[1/2] ResponseException: No mapping found for [title.raw] in order to sort on [reason: all shards failed]  +

Logs  -

2 errors
  1. INFO - Calling the AppKernel::init() method is deprecated since version 2.3 and will be removed in 3.0. Move your logic to the constructor method instead.
  2. INFO - The possibility to register the same extension twice ("blocks_job") is deprecated since version 1.23 and will be removed in Twig 2.0. Use proper PHP inheritance instead.
  3. INFO - Matched route "global_search_2".
  4. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure".
  5. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelRequest".
  6. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest".
  7. DEBUG - Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\SessionListener::onKernelRequest".
  8. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\FragmentListener::onKernelRequest".
  9. DEBUG - Notified event "kernel.request" to listener "FOS\RestBundle\EventListener\FormatListener::onKernelRequest".
  10. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest".
  11. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest".
  12. DEBUG - Notified event "kernel.request" to listener "FOS\RestBundle\EventListener\BodyListener::onKernelRequest".
  13. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelRequest".
  14. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\Security\Http\Firewall::onKernelRequest".
  15. DEBUG - Notified event "kernel.request" to listener "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest".
  16. DEBUG - Notified event "kernel.request" to listener "Nelmio\ApiDocBundle\EventListener\RequestListener::onKernelRequest".
  17. DEBUG - Notified event "kernel.request" to listener "ArcaSolutionsMultiDomainBundleEventListenerDatabaseListener_0000000044bb43cd000000004fafb8d673dfc5597730201a66d5ffc7aa497743::onKernelRequest".
  18. INFO - The Doctrine\ORM\Proxy\ProxyFactory class extends Doctrine\Common\Proxy\AbstractProxyFactory that is deprecated The Doctrine\Common\Proxy component is deprecated, please use ocramius/proxy-manager instead.
  19. INFO - The Doctrine\ORM\Proxy\Proxy interface extends Doctrine\Common\Proxy\Proxy that is deprecated The Doctrine\Common\Proxy component is deprecated, please use ocramius/proxy-manager instead.
  20. DEBUG - SELECT t0.name AS name_1, t0.value AS value_2 FROM Setting t0
  21. DEBUG - Notified event "kernel.controller" to listener "ArcaSolutions\MultiDomainBundle\EventListener\DomainListener::onKernelController".
  22. DEBUG - Notified event "kernel.controller" to listener "FOS\RestBundle\EventListener\ParamFetcherListener::onKernelController".
  23. DEBUG - Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController".
  24. DEBUG - Notified event "kernel.controller" to listener "ArcaSolutions\CoreBundle\EventListener\BeforeControllerListener::onKernelController".
  25. DEBUG - Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController".
  26. DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController".
  27. DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController".
  28. DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController".
  29. DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelController".
  30. DEBUG - Notified event "kernel.controller" to listener "ArcaSolutions\AdminBundle\EventListener\BeforeControllerListener::onKernerController".
  31. DEBUG - Notified event "kernel.controller" to listener "FOS\RestBundle\EventListener\ViewResponseListener::onKernelController".
  32. DEBUG - SELECT s0_.name AS name_0, s0_.value AS value_1 FROM Setting s0_ WHERE s0_.name IN ('custom_event_feature', 'custom_classified_feature', 'custom_article_feature', 'custom_banner_feature', 'custom_promotion_feature', 'custom_blog_feature')
  33. WARNING - Translation not found.
  34. DEBUG - Translation use fallback catalogue.
  35. INFO - Deprecated: Filters are deprecated. Use queries in filter context. See https://www.elastic.co/guide/en/elasticsearch/reference/2.0/query-dsl-filters.html
  36. INFO - Deprecated: Filters are deprecated. Use queries in filter context. See https://www.elastic.co/guide/en/elasticsearch/reference/2.0/query-dsl-filters.html
  37. INFO - Use bool() instead. Filtered query is deprecated since ES 2.0.0-beta1 and this method will be removed in further Elastica releases.
  38. INFO - Use BoolQuery instead. Filtered query is deprecated since ES 2.0.0-beta1 and this class will be removed in further Elastica releases.
  39. INFO - Deprecated: Elastica\Query\Filtered passing AbstractFilter is deprecated. Pass AbstractQuery instead.
  40. INFO - Deprecated: Elastica\Query\Filtered::setFilter passing AbstractFilter is deprecated. Pass AbstractQuery instead.
  41. DEBUG - Notified event "search.category.friendlyurl" to listener "ArcaSolutions\CoreBundle\Search\CategoryConfiguration::registerFriendlyUrl".
  42. DEBUG - Translation use fallback catalogue.
  43. DEBUG - Translation use fallback catalogue.
  44. DEBUG - Translation use fallback catalogue.
  45. WARNING - Translation not found.
  46. DEBUG - Translation use fallback catalogue.
  47. DEBUG - Translation use fallback catalogue.
  48. DEBUG - Translation use fallback catalogue.
  49. DEBUG - Translation use fallback catalogue.
  50. DEBUG - Translation use fallback catalogue.
  51. DEBUG - Translation use fallback catalogue.
  52. DEBUG - SELECT t0.id AS id_1, t0.value AS value_2 FROM RobotsFilter t0 WHERE t0.value IN (?)
  53. DEBUG - "START TRANSACTION"
  54. DEBUG - INSERT INTO Report_Statistic (search_date, module, keyword, category_id, location_1, location_2, location_3, location_4, location_5, search_where) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  55. DEBUG - "COMMIT"
  56. DEBUG - SELECT t0.id AS id_1, t0.value AS value_2 FROM RobotsFilter t0 WHERE t0.value IN (?)
  57. DEBUG - "START TRANSACTION"
  58. DEBUG - INSERT INTO Report_Statistic (search_date, module, keyword, category_id, location_1, location_2, location_3, location_4, location_5, search_where) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  59. DEBUG - "COMMIT"
  60. DEBUG - SELECT t0.id AS id_1, t0.value AS value_2 FROM RobotsFilter t0 WHERE t0.value IN (?)
  61. DEBUG - "START TRANSACTION"
  62. DEBUG - INSERT INTO Report_Statistic (search_date, module, keyword, category_id, location_1, location_2, location_3, location_4, location_5, search_where) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  63. DEBUG - "COMMIT"
  64. INFO - Deprecated: Filters are deprecated. Use queries in filter context. See https://www.elastic.co/guide/en/elasticsearch/reference/2.0/query-dsl-filters.html
  65. INFO - Deprecated: Filters are deprecated. Use queries in filter context. See https://www.elastic.co/guide/en/elasticsearch/reference/2.0/query-dsl-filters.html
  66. INFO - Deprecated: Filters are deprecated. Use queries in filter context. See https://www.elastic.co/guide/en/elasticsearch/reference/2.0/query-dsl-filters.html
  67. INFO - Use bool() instead. Filtered query is deprecated since ES 2.0.0-beta1 and this method will be removed in further Elastica releases.
  68. INFO - Deprecated: Elastica\Query\Filtered passing AbstractFilter is deprecated. Pass AbstractQuery instead.
  69. INFO - Deprecated: Elastica\Query\Filtered::setFilter passing AbstractFilter is deprecated. Pass AbstractQuery instead.
  70. DEBUG - SELECT s0_.name AS name_0, s0_.value AS value_1 FROM Setting s0_ WHERE s0_.name IN ('custom_event_feature', 'custom_classified_feature', 'custom_article_feature', 'custom_banner_feature', 'custom_promotion_feature', 'custom_blog_feature')
  71. INFO - Use bool() instead. Filtered query is deprecated since ES 2.0.0-beta1 and this method will be removed in further Elastica releases.
  72. INFO - Deprecated: Elastica\Query\Filtered passing AbstractFilter is deprecated. Pass AbstractQuery instead.
  73. INFO - Deprecated: Elastica\Query\Filtered::setFilter passing AbstractFilter is deprecated. Pass AbstractQuery instead.
  74. DEBUG - SELECT s0_.name AS name_0, s0_.value AS value_1 FROM Setting s0_ WHERE s0_.name IN ('custom_event_feature', 'custom_classified_feature', 'custom_article_feature', 'custom_banner_feature', 'custom_promotion_feature', 'custom_blog_feature')
  75. INFO - Use bool() instead. Filtered query is deprecated since ES 2.0.0-beta1 and this method will be removed in further Elastica releases.
  76. INFO - Deprecated: Elastica\Query\Filtered passing AbstractFilter is deprecated. Pass AbstractQuery instead.
  77. INFO - Deprecated: Elastica\Query\Filtered::setFilter passing AbstractFilter is deprecated. Pass AbstractQuery instead.
  78. DEBUG - SELECT s0_.name AS name_0, s0_.value AS value_1 FROM Setting s0_ WHERE s0_.name IN ('custom_event_feature', 'custom_classified_feature', 'custom_article_feature', 'custom_banner_feature', 'custom_promotion_feature', 'custom_blog_feature')
  79. INFO - Use bool() instead. Filtered query is deprecated since ES 2.0.0-beta1 and this method will be removed in further Elastica releases.
  80. INFO - Deprecated: Elastica\Query\Filtered passing AbstractFilter is deprecated. Pass AbstractQuery instead.
  81. INFO - Deprecated: Elastica\Query\Filtered::setFilter passing AbstractFilter is deprecated. Pass AbstractQuery instead.
  82. DEBUG - SELECT s0_.name AS name_0, s0_.value AS value_1 FROM Setting s0_ WHERE s0_.name IN ('custom_event_feature', 'custom_classified_feature', 'custom_article_feature', 'custom_banner_feature', 'custom_promotion_feature', 'custom_blog_feature')
  83. INFO - Deprecated: Filters are deprecated. Use queries in filter context. See https://www.elastic.co/guide/en/elasticsearch/reference/2.0/query-dsl-filters.html
  84. INFO - Deprecated: Filters are deprecated. Use queries in filter context. See https://www.elastic.co/guide/en/elasticsearch/reference/2.0/query-dsl-filters.html
  85. INFO - Deprecated: Filters are deprecated. Use BoolQuery::addMust. See https://www.elastic.co/guide/en/elasticsearch/reference/2.0/query-dsl-filters.html
  86. INFO - Deprecated: Filters are deprecated. Use queries in filter context. See https://www.elastic.co/guide/en/elasticsearch/reference/2.0/query-dsl-filters.html
  87. INFO - Use bool() instead. Filtered query is deprecated since ES 2.0.0-beta1 and this method will be removed in further Elastica releases.
  88. INFO - Deprecated: Elastica\Query\Filtered passing AbstractFilter is deprecated. Pass AbstractQuery instead.
  89. INFO - Deprecated: Elastica\Query\Filtered::setFilter passing AbstractFilter is deprecated. Pass AbstractQuery instead.
  90. DEBUG - SELECT s0_.name AS name_0, s0_.value AS value_1 FROM Setting s0_ WHERE s0_.name IN ('custom_event_feature', 'custom_classified_feature', 'custom_article_feature', 'custom_banner_feature', 'custom_promotion_feature', 'custom_blog_feature')
  91. INFO - Use bool() instead. Filtered query is deprecated since ES 2.0.0-beta1 and this method will be removed in further Elastica releases.
  92. INFO - Deprecated: Elastica\Query\Filtered passing AbstractFilter is deprecated. Pass AbstractQuery instead.
  93. INFO - Deprecated: Elastica\Query\Filtered::setFilter passing AbstractFilter is deprecated. Pass AbstractQuery instead.
  94. INFO - Use bool() instead. Filtered query is deprecated since ES 2.0.0-beta1 and this method will be removed in further Elastica releases.
  95. INFO - Deprecated: Elastica\Query\Filtered passing AbstractFilter is deprecated. Pass AbstractQuery instead.
  96. INFO - Deprecated: Elastica\Query\Filtered::setFilter passing AbstractFilter is deprecated. Pass AbstractQuery instead.
  97. DEBUG - Notified event "search.global" to listener "ArcaSolutions\SearchBundle\Entity\ScriptFields\NextOccurrenceScriptField::registerItem".
  98. DEBUG - Notified event "search.global" to listener "ArcaSolutions\SearchBundle\Entity\Filters\CategoryFilter::registerItem".
  99. DEBUG - Notified event "search.global" to listener "ArcaSolutions\SearchBundle\Entity\Filters\LocationFilter::registerItem".
  100. DEBUG - Notified event "search.global" to listener "ArcaSolutions\SearchBundle\Entity\Filters\RatingFilter::registerItem".
  101. DEBUG - Notified event "search.global" to listener "ArcaSolutions\SearchBundle\Entity\Filters\DateFilter::registerItem".
  102. DEBUG - Notified event "search.global" to listener "ArcaSolutions\SearchBundle\Entity\Filters\BoundingFilter::registerItem".
  103. DEBUG - Notified event "search.global" to listener "ArcaSolutions\SearchBundle\Entity\Sorters\RelevancySorter::register".
  104. DEBUG - Notified event "search.global" to listener "ArcaSolutions\SearchBundle\Entity\Sorters\DistanceSorter::register".
  105. DEBUG - Notified event "search.global" to listener "ArcaSolutions\SearchBundle\Entity\Sorters\AlphabeticalSorter::register".
  106. DEBUG - Notified event "search.global" to listener "ArcaSolutions\SearchBundle\Entity\Sorters\ViewSorter::register".
  107. DEBUG - Notified event "search.global" to listener "ArcaSolutions\SearchBundle\Entity\Sorters\UpcomingSorter::register".
  108. DEBUG - Notified event "search.global" to listener "ArcaSolutions\ListingBundle\Search\ListingConfiguration::registerItem".
  109. DEBUG - Notified event "search.global" to listener "ArcaSolutions\ClassifiedBundle\Search\ClassifiedConfiguration::registerItem".
  110. DEBUG - Notified event "search.global" to listener "ArcaSolutions\EventBundle\Search\EventConfiguration::registerItem".
  111. DEBUG - Notified event "search.global" to listener "ArcaSolutions\ArticleBundle\Search\ArticleConfiguration::registerItem".
  112. DEBUG - Notified event "search.global" to listener "ArcaSolutions\DealBundle\Search\DealConfiguration::registerItem".
  113. DEBUG - Notified event "search.global" to listener "ArcaSolutions\BlogBundle\Search\BlogConfiguration::registerItem".
  114. DEBUG - Notified event "search.global" to listener "Mmrd\JobsboardBundle\Search\JobConfiguration::registerItem".
  115. DEBUG - Notified event "search.global" to listener "ArcaSolutions\SearchBundle\Entity\Filters\ModuleFilter::registerItem".
  116. INFO - Deprecated: Elastica\Aggregation\Filter passing filter as AbstractFilter is deprecated. Pass instance of AbstractQuery instead.
  117. INFO - Deprecated: Elastica\Aggregation\Filter\setFilter() passing filter as AbstractFilter is deprecated. Pass instance of AbstractQuery instead.
  118. INFO - Deprecated: Elastica\Aggregation\Filter passing filter as AbstractFilter is deprecated. Pass instance of AbstractQuery instead.
  119. INFO - Deprecated: Elastica\Aggregation\Filter\setFilter() passing filter as AbstractFilter is deprecated. Pass instance of AbstractQuery instead.
  120. INFO - Deprecated: Elastica\Aggregation\Filter passing filter as AbstractFilter is deprecated. Pass instance of AbstractQuery instead.
  121. INFO - Deprecated: Elastica\Aggregation\Filter\setFilter() passing filter as AbstractFilter is deprecated. Pass instance of AbstractQuery instead.
  122. INFO - Deprecated: Elastica\Aggregation\Filter passing filter as AbstractFilter is deprecated. Pass instance of AbstractQuery instead.
  123. INFO - Deprecated: Elastica\Aggregation\Filter\setFilter() passing filter as AbstractFilter is deprecated. Pass instance of AbstractQuery instead.
  124. INFO - Deprecated: Elastica\Query::setPostFilter() passing filter as AbstractFilter is deprecated. Pass instance of AbstractQuery instead.
  125. DEBUG - Translation use fallback catalogue.
  126. DEBUG - SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.url AS url_2, p0_.meta_description AS meta_description_3, p0_.meta_key AS meta_key_4, p0_.sitemap AS sitemap_5, p0_.custom_tag AS custom_tag_6, p0_.pagetype_id AS pagetype_id_7, p0_.updated AS updated_8, p0_.pagetype_id AS pagetype_id_9 FROM Page p0_ LEFT JOIN PageType p1_ ON p0_.pagetype_id = p1_.id WHERE p1_.title = ?
  127. INFO - Defining the initRuntime() method in the "knp_pagination" extension is deprecated since version 1.23. Use the `needs_environment` option to get the Twig_Environment instance in filters, functions, or tests; or explicitly implement Twig_Extension_InitRuntimeInterface if needed (not recommended).
  128. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2 FROM Theme t0 WHERE t0.title = ? LIMIT 1
  129. INFO - Using "replace" with character by character replacement is deprecated since version 1.22 and will be removed in Twig 2.0
  130. INFO - Using "replace" with character by character replacement is deprecated since version 1.22 and will be removed in Twig 2.0
  131. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2 FROM Theme t0 WHERE t0.title = ? LIMIT 1
  132. DEBUG - SELECT t0.id AS id_1, t0.page_id AS page_id_2, t0.widget_id AS widget_id_3, t0.content AS content_4, t0.`order` AS order_5, t0.theme_id AS theme_id_6, t0.page_id AS page_id_7, t0.widget_id AS widget_id_8, t9.id AS id_10, t9.title AS title_11, t9.twig_file AS twig_file_12, t9.content AS content_13, t9.`type` AS type_14, t9.`modal` AS modal_15, t0.theme_id AS theme_id_16 FROM Page_Widget t0 LEFT JOIN Widget t9 ON t0.widget_id = t9.id WHERE t0.page_id = ? AND t0.theme_id = ? ORDER BY t0.`order` ASC
  133. DEBUG - SELECT s0_.`order` AS order_0, s0_.area AS area_1, s0_.label AS label_2, s0_.link AS link_3, s0_.custom AS custom_4, s0_.page_id AS page_id_5 FROM Setting_Navigation s0_ WHERE s0_.area = ? AND (s0_.link IS NOT NULL OR s0_.page_id IS NOT NULL) ORDER BY s0_.`order` ASC
  134. DEBUG - SELECT s0_.name AS name_0, s0_.value AS value_1 FROM Setting s0_ WHERE s0_.name IN ('custom_event_feature', 'custom_classified_feature', 'custom_article_feature', 'custom_banner_feature', 'custom_promotion_feature', 'custom_blog_feature')
  135. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.meta_description AS meta_description_4, t0.meta_key AS meta_key_5, t0.sitemap AS sitemap_6, t0.custom_tag AS custom_tag_7, t0.pagetype_id AS pagetype_id_8, t0.updated AS updated_9, t0.pagetype_id AS pagetype_id_10 FROM Page t0 WHERE t0.id = ?
  136. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2 FROM PageType t0 WHERE t0.id = ?
  137. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.meta_description AS meta_description_4, t0.meta_key AS meta_key_5, t0.sitemap AS sitemap_6, t0.custom_tag AS custom_tag_7, t0.pagetype_id AS pagetype_id_8, t0.updated AS updated_9, t0.pagetype_id AS pagetype_id_10 FROM Page t0 WHERE t0.id = ?
  138. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2 FROM PageType t0 WHERE t0.id = ?
  139. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.meta_description AS meta_description_4, t0.meta_key AS meta_key_5, t0.sitemap AS sitemap_6, t0.custom_tag AS custom_tag_7, t0.pagetype_id AS pagetype_id_8, t0.updated AS updated_9, t0.pagetype_id AS pagetype_id_10 FROM Page t0 WHERE t0.id = ?
  140. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2 FROM PageType t0 WHERE t0.id = ?
  141. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.meta_description AS meta_description_4, t0.meta_key AS meta_key_5, t0.sitemap AS sitemap_6, t0.custom_tag AS custom_tag_7, t0.pagetype_id AS pagetype_id_8, t0.updated AS updated_9, t0.pagetype_id AS pagetype_id_10 FROM Page t0 WHERE t0.id = ?
  142. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2 FROM PageType t0 WHERE t0.id = ?
  143. DEBUG - Translation use fallback catalogue.
  144. DEBUG - Translation use fallback catalogue.
  145. DEBUG - Translation use fallback catalogue.
  146. DEBUG - Translation use fallback catalogue.
  147. DEBUG - Translation use fallback catalogue.
  148. DEBUG - Translation use fallback catalogue.
  149. DEBUG - SELECT t0.name AS name_1, t0.value AS value_2 FROM Setting t0 WHERE t0.name = ? LIMIT 1
  150. DEBUG - SELECT b0_.value AS value_0, b0_.name AS name_1, b0_.defaultlevel AS defaultlevel_2, b0_.price AS price_3, b0_.price_yearly AS price_yearly_4, b0_.width AS width_5, b0_.height AS height_6, b0_.active AS active_7, b0_.popular AS popular_8, b0_.displayName AS displayName_9, b0_.trial AS trial_10 FROM BannerLevel b0_ WHERE b0_.active = ? AND b0_.value = ?
  151. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2, t0.category_id AS category_id_3, t0.thumb_id AS thumb_id_4, t0.image_id AS image_id_5, t0.icon_id AS icon_id_6, t0.featured AS featured_7, t0.summary_description AS summary_description_8, t0.seo_description AS seo_description_9, t0.page_title AS page_title_10, t0.friendly_url AS friendly_url_11, t0.keywords AS keywords_12, t0.seo_keywords AS seo_keywords_13, t0.content AS content_14, t0.enabled AS enabled_15, t0.tag AS tag_16, t0.category_id AS category_id_17, t0.image_id AS image_id_18, t19.id AS id_20, t19.type AS type_21, t19.width AS width_22, t19.height AS height_23, t19.prefix AS prefix_24, t19.unsplash AS unsplash_25, t0.icon_id AS icon_id_26, t27.id AS id_28, t27.type AS type_29, t27.width AS width_30, t27.height AS height_31, t27.prefix AS prefix_32, t27.unsplash AS unsplash_33, t0.import_id AS import_id_34 FROM ListingCategory t0 LEFT JOIN Image t19 ON t0.image_id = t19.id LEFT JOIN Image t27 ON t0.icon_id = t27.id WHERE t0.id IN (?)
  152. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2, t0.category_id AS category_id_3, t0.thumb_id AS thumb_id_4, t0.image_id AS image_id_5, t0.icon_id AS icon_id_6, t0.featured AS featured_7, t0.summary_description AS summary_description_8, t0.seo_description AS seo_description_9, t0.page_title AS page_title_10, t0.friendly_url AS friendly_url_11, t0.keywords AS keywords_12, t0.seo_keywords AS seo_keywords_13, t0.content AS content_14, t0.enabled AS enabled_15, t0.tag AS tag_16, t0.category_id AS category_id_17, t0.image_id AS image_id_18, t19.id AS id_20, t19.type AS type_21, t19.width AS width_22, t19.height AS height_23, t19.prefix AS prefix_24, t19.unsplash AS unsplash_25, t0.icon_id AS icon_id_26, t27.id AS id_28, t27.type AS type_29, t27.width AS width_30, t27.height AS height_31, t27.prefix AS prefix_32, t27.unsplash AS unsplash_33, t0.import_id AS import_id_34 FROM ListingCategory t0 LEFT JOIN Image t19 ON t0.image_id = t19.id LEFT JOIN Image t27 ON t0.icon_id = t27.id WHERE t0.id = ?
  153. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2, t0.category_id AS category_id_3, t0.thumb_id AS thumb_id_4, t0.image_id AS image_id_5, t0.icon_id AS icon_id_6, t0.featured AS featured_7, t0.summary_description AS summary_description_8, t0.seo_description AS seo_description_9, t0.page_title AS page_title_10, t0.friendly_url AS friendly_url_11, t0.keywords AS keywords_12, t0.seo_keywords AS seo_keywords_13, t0.content AS content_14, t0.enabled AS enabled_15, t0.tag AS tag_16, t0.category_id AS category_id_17, t0.image_id AS image_id_18, t19.id AS id_20, t19.type AS type_21, t19.width AS width_22, t19.height AS height_23, t19.prefix AS prefix_24, t19.unsplash AS unsplash_25, t0.icon_id AS icon_id_26, t27.id AS id_28, t27.type AS type_29, t27.width AS width_30, t27.height AS height_31, t27.prefix AS prefix_32, t27.unsplash AS unsplash_33, t0.import_id AS import_id_34 FROM ListingCategory t0 LEFT JOIN Image t19 ON t0.image_id = t19.id LEFT JOIN Image t27 ON t0.icon_id = t27.id WHERE t0.id = ?
  154. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2, t0.category_id AS category_id_3, t0.thumb_id AS thumb_id_4, t0.image_id AS image_id_5, t0.icon_id AS icon_id_6, t0.featured AS featured_7, t0.summary_description AS summary_description_8, t0.seo_description AS seo_description_9, t0.page_title AS page_title_10, t0.friendly_url AS friendly_url_11, t0.keywords AS keywords_12, t0.seo_keywords AS seo_keywords_13, t0.content AS content_14, t0.enabled AS enabled_15, t0.category_id AS category_id_16, t0.image_id AS image_id_17, t18.id AS id_19, t18.type AS type_20, t18.width AS width_21, t18.height AS height_22, t18.prefix AS prefix_23, t18.unsplash AS unsplash_24, t0.icon_id AS icon_id_25, t26.id AS id_27, t26.type AS type_28, t26.width AS width_29, t26.height AS height_30, t26.prefix AS prefix_31, t26.unsplash AS unsplash_32 FROM ClassifiedCategory t0 LEFT JOIN Image t18 ON t0.image_id = t18.id LEFT JOIN Image t26 ON t0.icon_id = t26.id WHERE t0.id IN (?)
  155. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2, t0.category_id AS category_id_3, t0.thumb_id AS thumb_id_4, t0.image_id AS image_id_5, t0.icon_id AS icon_id_6, t0.featured AS featured_7, t0.summary_description AS summary_description_8, t0.seo_description AS seo_description_9, t0.page_title AS page_title_10, t0.friendly_url AS friendly_url_11, t0.keywords AS keywords_12, t0.seo_keywords AS seo_keywords_13, t0.content AS content_14, t0.enabled AS enabled_15, t0.category_id AS category_id_16, t0.image_id AS image_id_17, t18.id AS id_19, t18.type AS type_20, t18.width AS width_21, t18.height AS height_22, t18.prefix AS prefix_23, t18.unsplash AS unsplash_24, t0.icon_id AS icon_id_25, t26.id AS id_27, t26.type AS type_28, t26.width AS width_29, t26.height AS height_30, t26.prefix AS prefix_31, t26.unsplash AS unsplash_32 FROM ClassifiedCategory t0 LEFT JOIN Image t18 ON t0.image_id = t18.id LEFT JOIN Image t26 ON t0.icon_id = t26.id WHERE t0.id = ?
  156. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2, t0.category_id AS category_id_3, t0.thumb_id AS thumb_id_4, t0.image_id AS image_id_5, t0.icon_id AS icon_id_6, t0.featured AS featured_7, t0.summary_description AS summary_description_8, t0.seo_description AS seo_description_9, t0.page_title AS page_title_10, t0.friendly_url AS friendly_url_11, t0.keywords AS keywords_12, t0.seo_keywords AS seo_keywords_13, t0.content AS content_14, t0.enabled AS enabled_15, t0.tag AS tag_16, t0.category_id AS category_id_17, t0.image_id AS image_id_18, t19.id AS id_20, t19.type AS type_21, t19.width AS width_22, t19.height AS height_23, t19.prefix AS prefix_24, t19.unsplash AS unsplash_25, t0.icon_id AS icon_id_26, t27.id AS id_28, t27.type AS type_29, t27.width AS width_30, t27.height AS height_31, t27.prefix AS prefix_32, t27.unsplash AS unsplash_33, t0.import_id AS import_id_34 FROM ListingCategory t0 LEFT JOIN Image t19 ON t0.image_id = t19.id LEFT JOIN Image t27 ON t0.icon_id = t27.id WHERE t0.id IN (?)
  157. DEBUG - SELECT b0_.id AS id_0, b0_.account_id AS account_id_1, b0_.image_id AS image_id_2, b0_.category_id AS category_id_3, b0_.renewal_date AS renewal_date_4, b0_.discount_id AS discount_id_5, b0_.caption AS caption_6, b0_.status AS status_7, b0_.target_window AS target_window_8, b0_.type AS type_9, b0_.section AS section_10, b0_.content_line1 AS content_line1_11, b0_.content_line2 AS content_line2_12, b0_.destination_protocol AS destination_protocol_13, b0_.display_url AS display_url_14, b0_.destination_url AS destination_url_15, b0_.updated AS updated_16, b0_.entered AS entered_17, b0_.show_type AS show_type_18, b0_.script AS script_19, b0_.package_id AS package_id_20, b0_.package_price AS package_price_21, RAND() AS sclr_22, b0_.image_id AS image_id_23 FROM Banner b0_ WHERE (b0_.renewal_date >= CURRENT_DATE OR b0_.renewal_date = '0000-00-00 00:00:00' OR b0_.renewal_date IS NULL) AND (b0_.section = 'global' OR (b0_.section = 'listing' AND b0_.category_id IN (?)) OR (b0_.section = 'classified' AND b0_.category_id IN (?)) OR (b0_.section = 'promotion' AND b0_.category_id IN (?))) AND b0_.status = 'A' AND b0_.type = 3 ORDER BY sclr_22 ASC LIMIT 1
  158. DEBUG - SELECT b0_.value AS value_0, b0_.name AS name_1, b0_.defaultlevel AS defaultlevel_2, b0_.price AS price_3, b0_.price_yearly AS price_yearly_4, b0_.width AS width_5, b0_.height AS height_6, b0_.active AS active_7, b0_.popular AS popular_8, b0_.displayName AS displayName_9, b0_.trial AS trial_10 FROM BannerLevel b0_ WHERE b0_.active = ? AND b0_.value = ?
  159. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2, t0.category_id AS category_id_3, t0.thumb_id AS thumb_id_4, t0.image_id AS image_id_5, t0.icon_id AS icon_id_6, t0.featured AS featured_7, t0.summary_description AS summary_description_8, t0.seo_description AS seo_description_9, t0.page_title AS page_title_10, t0.friendly_url AS friendly_url_11, t0.keywords AS keywords_12, t0.seo_keywords AS seo_keywords_13, t0.content AS content_14, t0.enabled AS enabled_15, t0.tag AS tag_16, t0.category_id AS category_id_17, t0.image_id AS image_id_18, t19.id AS id_20, t19.type AS type_21, t19.width AS width_22, t19.height AS height_23, t19.prefix AS prefix_24, t19.unsplash AS unsplash_25, t0.icon_id AS icon_id_26, t27.id AS id_28, t27.type AS type_29, t27.width AS width_30, t27.height AS height_31, t27.prefix AS prefix_32, t27.unsplash AS unsplash_33, t0.import_id AS import_id_34 FROM ListingCategory t0 LEFT JOIN Image t19 ON t0.image_id = t19.id LEFT JOIN Image t27 ON t0.icon_id = t27.id WHERE t0.id IN (?)
  160. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2, t0.category_id AS category_id_3, t0.thumb_id AS thumb_id_4, t0.image_id AS image_id_5, t0.icon_id AS icon_id_6, t0.featured AS featured_7, t0.summary_description AS summary_description_8, t0.seo_description AS seo_description_9, t0.page_title AS page_title_10, t0.friendly_url AS friendly_url_11, t0.keywords AS keywords_12, t0.seo_keywords AS seo_keywords_13, t0.content AS content_14, t0.enabled AS enabled_15, t0.category_id AS category_id_16, t0.image_id AS image_id_17, t18.id AS id_19, t18.type AS type_20, t18.width AS width_21, t18.height AS height_22, t18.prefix AS prefix_23, t18.unsplash AS unsplash_24, t0.icon_id AS icon_id_25, t26.id AS id_27, t26.type AS type_28, t26.width AS width_29, t26.height AS height_30, t26.prefix AS prefix_31, t26.unsplash AS unsplash_32 FROM ClassifiedCategory t0 LEFT JOIN Image t18 ON t0.image_id = t18.id LEFT JOIN Image t26 ON t0.icon_id = t26.id WHERE t0.id IN (?)
  161. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2, t0.category_id AS category_id_3, t0.thumb_id AS thumb_id_4, t0.image_id AS image_id_5, t0.icon_id AS icon_id_6, t0.featured AS featured_7, t0.summary_description AS summary_description_8, t0.seo_description AS seo_description_9, t0.page_title AS page_title_10, t0.friendly_url AS friendly_url_11, t0.keywords AS keywords_12, t0.seo_keywords AS seo_keywords_13, t0.content AS content_14, t0.enabled AS enabled_15, t0.tag AS tag_16, t0.category_id AS category_id_17, t0.image_id AS image_id_18, t19.id AS id_20, t19.type AS type_21, t19.width AS width_22, t19.height AS height_23, t19.prefix AS prefix_24, t19.unsplash AS unsplash_25, t0.icon_id AS icon_id_26, t27.id AS id_28, t27.type AS type_29, t27.width AS width_30, t27.height AS height_31, t27.prefix AS prefix_32, t27.unsplash AS unsplash_33, t0.import_id AS import_id_34 FROM ListingCategory t0 LEFT JOIN Image t19 ON t0.image_id = t19.id LEFT JOIN Image t27 ON t0.icon_id = t27.id WHERE t0.id IN (?)
  162. DEBUG - SELECT b0_.id AS id_0, b0_.account_id AS account_id_1, b0_.image_id AS image_id_2, b0_.category_id AS category_id_3, b0_.renewal_date AS renewal_date_4, b0_.discount_id AS discount_id_5, b0_.caption AS caption_6, b0_.status AS status_7, b0_.target_window AS target_window_8, b0_.type AS type_9, b0_.section AS section_10, b0_.content_line1 AS content_line1_11, b0_.content_line2 AS content_line2_12, b0_.destination_protocol AS destination_protocol_13, b0_.display_url AS display_url_14, b0_.destination_url AS destination_url_15, b0_.updated AS updated_16, b0_.entered AS entered_17, b0_.show_type AS show_type_18, b0_.script AS script_19, b0_.package_id AS package_id_20, b0_.package_price AS package_price_21, RAND() AS sclr_22, b0_.image_id AS image_id_23 FROM Banner b0_ WHERE (b0_.renewal_date >= CURRENT_DATE OR b0_.renewal_date = '0000-00-00 00:00:00' OR b0_.renewal_date IS NULL) AND (b0_.section = 'global' OR (b0_.section = 'listing' AND b0_.category_id IN (?)) OR (b0_.section = 'classified' AND b0_.category_id IN (?)) OR (b0_.section = 'promotion' AND b0_.category_id IN (?))) AND b0_.status = 'A' AND b0_.type = 3 ORDER BY sclr_22 ASC LIMIT 1
  163. DEBUG - SELECT b0_.value AS value_0, b0_.name AS name_1, b0_.defaultlevel AS defaultlevel_2, b0_.price AS price_3, b0_.price_yearly AS price_yearly_4, b0_.width AS width_5, b0_.height AS height_6, b0_.active AS active_7, b0_.popular AS popular_8, b0_.displayName AS displayName_9, b0_.trial AS trial_10 FROM BannerLevel b0_ WHERE b0_.active = ? AND b0_.value = ?
  164. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2, t0.category_id AS category_id_3, t0.thumb_id AS thumb_id_4, t0.image_id AS image_id_5, t0.icon_id AS icon_id_6, t0.featured AS featured_7, t0.summary_description AS summary_description_8, t0.seo_description AS seo_description_9, t0.page_title AS page_title_10, t0.friendly_url AS friendly_url_11, t0.keywords AS keywords_12, t0.seo_keywords AS seo_keywords_13, t0.content AS content_14, t0.enabled AS enabled_15, t0.tag AS tag_16, t0.category_id AS category_id_17, t0.image_id AS image_id_18, t19.id AS id_20, t19.type AS type_21, t19.width AS width_22, t19.height AS height_23, t19.prefix AS prefix_24, t19.unsplash AS unsplash_25, t0.icon_id AS icon_id_26, t27.id AS id_28, t27.type AS type_29, t27.width AS width_30, t27.height AS height_31, t27.prefix AS prefix_32, t27.unsplash AS unsplash_33, t0.import_id AS import_id_34 FROM ListingCategory t0 LEFT JOIN Image t19 ON t0.image_id = t19.id LEFT JOIN Image t27 ON t0.icon_id = t27.id WHERE t0.id IN (?)
  165. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2, t0.category_id AS category_id_3, t0.thumb_id AS thumb_id_4, t0.image_id AS image_id_5, t0.icon_id AS icon_id_6, t0.featured AS featured_7, t0.summary_description AS summary_description_8, t0.seo_description AS seo_description_9, t0.page_title AS page_title_10, t0.friendly_url AS friendly_url_11, t0.keywords AS keywords_12, t0.seo_keywords AS seo_keywords_13, t0.content AS content_14, t0.enabled AS enabled_15, t0.category_id AS category_id_16, t0.image_id AS image_id_17, t18.id AS id_19, t18.type AS type_20, t18.width AS width_21, t18.height AS height_22, t18.prefix AS prefix_23, t18.unsplash AS unsplash_24, t0.icon_id AS icon_id_25, t26.id AS id_27, t26.type AS type_28, t26.width AS width_29, t26.height AS height_30, t26.prefix AS prefix_31, t26.unsplash AS unsplash_32 FROM ClassifiedCategory t0 LEFT JOIN Image t18 ON t0.image_id = t18.id LEFT JOIN Image t26 ON t0.icon_id = t26.id WHERE t0.id IN (?)
  166. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2, t0.category_id AS category_id_3, t0.thumb_id AS thumb_id_4, t0.image_id AS image_id_5, t0.icon_id AS icon_id_6, t0.featured AS featured_7, t0.summary_description AS summary_description_8, t0.seo_description AS seo_description_9, t0.page_title AS page_title_10, t0.friendly_url AS friendly_url_11, t0.keywords AS keywords_12, t0.seo_keywords AS seo_keywords_13, t0.content AS content_14, t0.enabled AS enabled_15, t0.tag AS tag_16, t0.category_id AS category_id_17, t0.image_id AS image_id_18, t19.id AS id_20, t19.type AS type_21, t19.width AS width_22, t19.height AS height_23, t19.prefix AS prefix_24, t19.unsplash AS unsplash_25, t0.icon_id AS icon_id_26, t27.id AS id_28, t27.type AS type_29, t27.width AS width_30, t27.height AS height_31, t27.prefix AS prefix_32, t27.unsplash AS unsplash_33, t0.import_id AS import_id_34 FROM ListingCategory t0 LEFT JOIN Image t19 ON t0.image_id = t19.id LEFT JOIN Image t27 ON t0.icon_id = t27.id WHERE t0.id IN (?)
  167. DEBUG - SELECT b0_.id AS id_0, b0_.account_id AS account_id_1, b0_.image_id AS image_id_2, b0_.category_id AS category_id_3, b0_.renewal_date AS renewal_date_4, b0_.discount_id AS discount_id_5, b0_.caption AS caption_6, b0_.status AS status_7, b0_.target_window AS target_window_8, b0_.type AS type_9, b0_.section AS section_10, b0_.content_line1 AS content_line1_11, b0_.content_line2 AS content_line2_12, b0_.destination_protocol AS destination_protocol_13, b0_.display_url AS display_url_14, b0_.destination_url AS destination_url_15, b0_.updated AS updated_16, b0_.entered AS entered_17, b0_.show_type AS show_type_18, b0_.script AS script_19, b0_.package_id AS package_id_20, b0_.package_price AS package_price_21, RAND() AS sclr_22, b0_.image_id AS image_id_23 FROM Banner b0_ WHERE (b0_.renewal_date >= CURRENT_DATE OR b0_.renewal_date = '0000-00-00 00:00:00' OR b0_.renewal_date IS NULL) AND (b0_.section = 'global' OR (b0_.section = 'listing' AND b0_.category_id IN (?)) OR (b0_.section = 'classified' AND b0_.category_id IN (?)) OR (b0_.section = 'promotion' AND b0_.category_id IN (?))) AND b0_.status = 'A' AND b0_.type = 4 ORDER BY sclr_22 ASC LIMIT 1
  168. DEBUG - SELECT b0_.value AS value_0, b0_.name AS name_1, b0_.defaultlevel AS defaultlevel_2, b0_.price AS price_3, b0_.price_yearly AS price_yearly_4, b0_.width AS width_5, b0_.height AS height_6, b0_.active AS active_7, b0_.popular AS popular_8, b0_.displayName AS displayName_9, b0_.trial AS trial_10 FROM BannerLevel b0_ WHERE b0_.active = ? AND b0_.value = ?
  169. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2, t0.category_id AS category_id_3, t0.thumb_id AS thumb_id_4, t0.image_id AS image_id_5, t0.icon_id AS icon_id_6, t0.featured AS featured_7, t0.summary_description AS summary_description_8, t0.seo_description AS seo_description_9, t0.page_title AS page_title_10, t0.friendly_url AS friendly_url_11, t0.keywords AS keywords_12, t0.seo_keywords AS seo_keywords_13, t0.content AS content_14, t0.enabled AS enabled_15, t0.tag AS tag_16, t0.category_id AS category_id_17, t0.image_id AS image_id_18, t19.id AS id_20, t19.type AS type_21, t19.width AS width_22, t19.height AS height_23, t19.prefix AS prefix_24, t19.unsplash AS unsplash_25, t0.icon_id AS icon_id_26, t27.id AS id_28, t27.type AS type_29, t27.width AS width_30, t27.height AS height_31, t27.prefix AS prefix_32, t27.unsplash AS unsplash_33, t0.import_id AS import_id_34 FROM ListingCategory t0 LEFT JOIN Image t19 ON t0.image_id = t19.id LEFT JOIN Image t27 ON t0.icon_id = t27.id WHERE t0.id IN (?)
  170. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2, t0.category_id AS category_id_3, t0.thumb_id AS thumb_id_4, t0.image_id AS image_id_5, t0.icon_id AS icon_id_6, t0.featured AS featured_7, t0.summary_description AS summary_description_8, t0.seo_description AS seo_description_9, t0.page_title AS page_title_10, t0.friendly_url AS friendly_url_11, t0.keywords AS keywords_12, t0.seo_keywords AS seo_keywords_13, t0.content AS content_14, t0.enabled AS enabled_15, t0.category_id AS category_id_16, t0.image_id AS image_id_17, t18.id AS id_19, t18.type AS type_20, t18.width AS width_21, t18.height AS height_22, t18.prefix AS prefix_23, t18.unsplash AS unsplash_24, t0.icon_id AS icon_id_25, t26.id AS id_27, t26.type AS type_28, t26.width AS width_29, t26.height AS height_30, t26.prefix AS prefix_31, t26.unsplash AS unsplash_32 FROM ClassifiedCategory t0 LEFT JOIN Image t18 ON t0.image_id = t18.id LEFT JOIN Image t26 ON t0.icon_id = t26.id WHERE t0.id IN (?)
  171. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2, t0.category_id AS category_id_3, t0.thumb_id AS thumb_id_4, t0.image_id AS image_id_5, t0.icon_id AS icon_id_6, t0.featured AS featured_7, t0.summary_description AS summary_description_8, t0.seo_description AS seo_description_9, t0.page_title AS page_title_10, t0.friendly_url AS friendly_url_11, t0.keywords AS keywords_12, t0.seo_keywords AS seo_keywords_13, t0.content AS content_14, t0.enabled AS enabled_15, t0.tag AS tag_16, t0.category_id AS category_id_17, t0.image_id AS image_id_18, t19.id AS id_20, t19.type AS type_21, t19.width AS width_22, t19.height AS height_23, t19.prefix AS prefix_24, t19.unsplash AS unsplash_25, t0.icon_id AS icon_id_26, t27.id AS id_28, t27.type AS type_29, t27.width AS width_30, t27.height AS height_31, t27.prefix AS prefix_32, t27.unsplash AS unsplash_33, t0.import_id AS import_id_34 FROM ListingCategory t0 LEFT JOIN Image t19 ON t0.image_id = t19.id LEFT JOIN Image t27 ON t0.icon_id = t27.id WHERE t0.id IN (?)
  172. DEBUG - SELECT b0_.id AS id_0, b0_.account_id AS account_id_1, b0_.image_id AS image_id_2, b0_.category_id AS category_id_3, b0_.renewal_date AS renewal_date_4, b0_.discount_id AS discount_id_5, b0_.caption AS caption_6, b0_.status AS status_7, b0_.target_window AS target_window_8, b0_.type AS type_9, b0_.section AS section_10, b0_.content_line1 AS content_line1_11, b0_.content_line2 AS content_line2_12, b0_.destination_protocol AS destination_protocol_13, b0_.display_url AS display_url_14, b0_.destination_url AS destination_url_15, b0_.updated AS updated_16, b0_.entered AS entered_17, b0_.show_type AS show_type_18, b0_.script AS script_19, b0_.package_id AS package_id_20, b0_.package_price AS package_price_21, RAND() AS sclr_22, b0_.image_id AS image_id_23 FROM Banner b0_ WHERE (b0_.renewal_date >= CURRENT_DATE OR b0_.renewal_date = '0000-00-00 00:00:00' OR b0_.renewal_date IS NULL) AND (b0_.section = 'global' OR (b0_.section = 'listing' AND b0_.category_id IN (?)) OR (b0_.section = 'classified' AND b0_.category_id IN (?)) OR (b0_.section = 'promotion' AND b0_.category_id IN (?))) AND b0_.status = 'A' AND b0_.type = 6 ORDER BY sclr_22 ASC LIMIT 1
  173. DEBUG - SELECT b0_.value AS value_0, b0_.name AS name_1, b0_.defaultlevel AS defaultlevel_2, b0_.price AS price_3, b0_.price_yearly AS price_yearly_4, b0_.width AS width_5, b0_.height AS height_6, b0_.active AS active_7, b0_.popular AS popular_8, b0_.displayName AS displayName_9, b0_.trial AS trial_10 FROM BannerLevel b0_ WHERE b0_.active = ? AND b0_.value = ?
  174. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2, t0.category_id AS category_id_3, t0.thumb_id AS thumb_id_4, t0.image_id AS image_id_5, t0.icon_id AS icon_id_6, t0.featured AS featured_7, t0.summary_description AS summary_description_8, t0.seo_description AS seo_description_9, t0.page_title AS page_title_10, t0.friendly_url AS friendly_url_11, t0.keywords AS keywords_12, t0.seo_keywords AS seo_keywords_13, t0.content AS content_14, t0.enabled AS enabled_15, t0.tag AS tag_16, t0.category_id AS category_id_17, t0.image_id AS image_id_18, t19.id AS id_20, t19.type AS type_21, t19.width AS width_22, t19.height AS height_23, t19.prefix AS prefix_24, t19.unsplash AS unsplash_25, t0.icon_id AS icon_id_26, t27.id AS id_28, t27.type AS type_29, t27.width AS width_30, t27.height AS height_31, t27.prefix AS prefix_32, t27.unsplash AS unsplash_33, t0.import_id AS import_id_34 FROM ListingCategory t0 LEFT JOIN Image t19 ON t0.image_id = t19.id LEFT JOIN Image t27 ON t0.icon_id = t27.id WHERE t0.id IN (?)
  175. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2, t0.category_id AS category_id_3, t0.thumb_id AS thumb_id_4, t0.image_id AS image_id_5, t0.icon_id AS icon_id_6, t0.featured AS featured_7, t0.summary_description AS summary_description_8, t0.seo_description AS seo_description_9, t0.page_title AS page_title_10, t0.friendly_url AS friendly_url_11, t0.keywords AS keywords_12, t0.seo_keywords AS seo_keywords_13, t0.content AS content_14, t0.enabled AS enabled_15, t0.category_id AS category_id_16, t0.image_id AS image_id_17, t18.id AS id_19, t18.type AS type_20, t18.width AS width_21, t18.height AS height_22, t18.prefix AS prefix_23, t18.unsplash AS unsplash_24, t0.icon_id AS icon_id_25, t26.id AS id_27, t26.type AS type_28, t26.width AS width_29, t26.height AS height_30, t26.prefix AS prefix_31, t26.unsplash AS unsplash_32 FROM ClassifiedCategory t0 LEFT JOIN Image t18 ON t0.image_id = t18.id LEFT JOIN Image t26 ON t0.icon_id = t26.id WHERE t0.id IN (?)
  176. DEBUG - SELECT t0.id AS id_1, t0.title AS title_2, t0.category_id AS category_id_3, t0.thumb_id AS thumb_id_4, t0.image_id AS image_id_5, t0.icon_id AS icon_id_6, t0.featured AS featured_7, t0.summary_description AS summary_description_8, t0.seo_description AS seo_description_9, t0.page_title AS page_title_10, t0.friendly_url AS friendly_url_11, t0.keywords AS keywords_12, t0.seo_keywords AS seo_keywords_13, t0.content AS content_14, t0.enabled AS enabled_15, t0.tag AS tag_16, t0.category_id AS category_id_17, t0.image_id AS image_id_18, t19.id AS id_20, t19.type AS type_21, t19.width AS width_22, t19.height AS height_23, t19.prefix AS prefix_24, t19.unsplash AS unsplash_25, t0.icon_id AS icon_id_26, t27.id AS id_28, t27.type AS type_29, t27.width AS width_30, t27.height AS height_31, t27.prefix AS prefix_32, t27.unsplash AS unsplash_33, t0.import_id AS import_id_34 FROM ListingCategory t0 LEFT JOIN Image t19 ON t0.image_id = t19.id LEFT JOIN Image t27 ON t0.icon_id = t27.id WHERE t0.id IN (?)
  177. DEBUG - SELECT b0_.id AS id_0, b0_.account_id AS account_id_1, b0_.image_id AS image_id_2, b0_.category_id AS category_id_3, b0_.renewal_date AS renewal_date_4, b0_.discount_id AS discount_id_5, b0_.caption AS caption_6, b0_.status AS status_7, b0_.target_window AS target_window_8, b0_.type AS type_9, b0_.section AS section_10, b0_.content_line1 AS content_line1_11, b0_.content_line2 AS content_line2_12, b0_.destination_protocol AS destination_protocol_13, b0_.display_url AS display_url_14, b0_.destination_url AS destination_url_15, b0_.updated AS updated_16, b0_.entered AS entered_17, b0_.show_type AS show_type_18, b0_.script AS script_19, b0_.package_id AS package_id_20, b0_.package_price AS package_price_21, RAND() AS sclr_22, b0_.image_id AS image_id_23 FROM Banner b0_ WHERE (b0_.renewal_date >= CURRENT_DATE OR b0_.renewal_date = '0000-00-00 00:00:00' OR b0_.renewal_date IS NULL) AND (b0_.section = 'global' OR (b0_.section = 'listing' AND b0_.category_id IN (?)) OR (b0_.section = 'classified' AND b0_.category_id IN (?)) OR (b0_.section = 'promotion' AND b0_.category_id IN (?))) AND b0_.status = 'A' AND b0_.type = 6 ORDER BY sclr_22 ASC LIMIT 1
  178. INFO - Use bool() instead. Filtered query is deprecated since ES 2.0.0-beta1 and this method will be removed in further Elastica releases.
  179. INFO - Deprecated: Elastica\Query\Filtered passing AbstractFilter is deprecated. Pass AbstractQuery instead.
  180. INFO - Deprecated: Elastica\Query\Filtered::setFilter passing AbstractFilter is deprecated. Pass AbstractQuery instead.
  181. INFO - Use bool() instead. Filtered query is deprecated since ES 2.0.0-beta1 and this method will be removed in further Elastica releases.
  182. INFO - Deprecated: Elastica\Query\Filtered passing AbstractFilter is deprecated. Pass AbstractQuery instead.
  183. INFO - Deprecated: Elastica\Query\Filtered::setFilter passing AbstractFilter is deprecated. Pass AbstractQuery instead.
  184. INFO - Use bool() instead. Filtered query is deprecated since ES 2.0.0-beta1 and this method will be removed in further Elastica releases.
  185. INFO - Deprecated: Elastica\Query\Filtered passing AbstractFilter is deprecated. Pass AbstractQuery instead.
  186. INFO - Deprecated: Elastica\Query\Filtered::setFilter passing AbstractFilter is deprecated. Pass AbstractQuery instead.
  187. DEBUG - Notified event "knp_pager.before" to listener "Knp\Component\Pager\Event\Subscriber\Sortable\SortableSubscriber::before".
  188. DEBUG - Notified event "knp_pager.before" to listener "Knp\Component\Pager\Event\Subscriber\Filtration\FiltrationSubscriber::before".
  189. DEBUG - Notified event "knp_pager.before" to listener "Knp\Component\Pager\Event\Subscriber\Paginate\PaginationSubscriber::before".
  190. CRITICAL - An exception has been thrown during the rendering of a template ("No mapping found for [title.raw] in order to sort on [reason: all shards failed]") in "::widgets/results/results-listing.html.twig" at line 19. in File: /var/edge2/edirectory/app/cache/dev/edge.mmrdpub.com/classes.php:4954
  191. CRITICAL - Uncaught PHP Exception Twig_Error_Runtime: "An exception has been thrown during the rendering of a template ("No mapping found for [title.raw] in order to sort on [reason: all shards failed]") in "::widgets/results/results-listing.html.twig" at line 19." at /var/edge2/edirectory/app/cache/dev/edge.mmrdpub.com/classes.php line 4954
  192. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure".
  193. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelRequest".
  194. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest".
  195. DEBUG - Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\SessionListener::onKernelRequest".
  196. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\FragmentListener::onKernelRequest".
  197. DEBUG - Notified event "kernel.request" to listener "FOS\RestBundle\EventListener\FormatListener::onKernelRequest".
  198. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest".
  199. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest".
  200. DEBUG - Notified event "kernel.request" to listener "FOS\RestBundle\EventListener\BodyListener::onKernelRequest".
  201. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelRequest".
  202. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\Security\Http\Firewall::onKernelRequest".
  203. DEBUG - Notified event "kernel.request" to listener "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest".
  204. DEBUG - Notified event "kernel.request" to listener "Nelmio\ApiDocBundle\EventListener\RequestListener::onKernelRequest".
  205. DEBUG - Notified event "kernel.request" to listener "ArcaSolutionsMultiDomainBundleEventListenerDatabaseListener_0000000044bb43cd000000004fafb8d673dfc5597730201a66d5ffc7aa497743::onKernelRequest".
  206. DEBUG - Notified event "kernel.controller" to listener "ArcaSolutions\MultiDomainBundle\EventListener\DomainListener::onKernelController".
  207. DEBUG - Notified event "kernel.controller" to listener "FOS\RestBundle\EventListener\ParamFetcherListener::onKernelController".
  208. DEBUG - Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController".
  209. DEBUG - Notified event "kernel.controller" to listener "ArcaSolutions\CoreBundle\EventListener\BeforeControllerListener::onKernelController".
  210. DEBUG - Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController".
  211. DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController".
  212. DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController".
  213. DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController".
  214. DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelController".
  215. DEBUG - Notified event "kernel.controller" to listener "ArcaSolutions\AdminBundle\EventListener\BeforeControllerListener::onKernerController".
  216. DEBUG - Notified event "kernel.controller" to listener "FOS\RestBundle\EventListener\ViewResponseListener::onKernelController".

Stack Trace (Plain Text)  +