options:
  path_info_key: PATH_INFO
  path_info_array: SERVER
  http_port: null
  https_port: null
  default_format: null
  logging: '1'
  relative_url_root: null
  formats: { txt: text/plain, js: [application/javascript, application/x-javascript, text/javascript], css: text/css, json: [application/json, application/x-json], xml: [text/xml, application/xml, application/x-xml], rdf: application/rdf+xml, atom: application/atom+xml }
  no_script_name: false
parameterHolder:
  action: index
  module: home
attributeHolder:
  sf_route: 'sfRoute Object()'

status:
  code: 200
  text: OK
options:
  http_protocol: HTTP/1.1
  logging: '1'
  charset: utf-8
  send_http_headers: false
  content_type: 'text/html; charset=utf-8'
cookies: {  }
httpHeaders:
  Content-Type: 'text/html; charset=utf-8'
javascripts:
  'https://new.biletwise.com/assets/front/js/owl-carousel/owl.carousel.min.js': {  }
  'https://new.biletwise.com/assets/js/typehead/typeahead.bundle.min.js': {  }
  'https://new.biletwise.com/assets/front/js/biletsat.js?v=1': {  }
  'https://www.google.com/recaptcha/api.js?render=6Lc1ndUUAAAAAE_zNQfyYdsa2eHnh_vyUs3gth0J': {  }
stylesheets:
  'https://new.biletwise.com/assets/front/js/owl-carousel/owl.carousel.min.css': {  }
metas:
  title: 'Homepage | biletwise'
  keywords: Keyword
  description: 'We are with you with different products in shoes and clothing sector.'
httpMetas: {  }

options:
  auto_shutdown: false
  culture: null
  default_culture: en
  use_flash: true
  logging: '1'
  timeout: 1800
attributeHolder:
  lang: { first: 1 }
  symfony/user/sfUser/attributes: { currency_value: '{"try_to_eur":"0.1072","eur_to_try":"9.3241","try_to_usd":"0.1285","usd_to_try":"7.7837","usd_to_eur":"0.8348","eur_to_usd":"1.1979"}', user_currency: TRY }
culture: en
authenticated: false
credentials: {  }
lastRequest: 1606766904

Apple_store_link: www.apple.com
'Appstore link': '#'
Buyer: Buyer
Captcha_server_key: 6Lc1ndUUAAAAAGtyRUXtWEVuCgbwaJ4oxnTL9zPj
Captcha_site_key: 6Lc1ndUUAAAAAE_zNQfyYdsa2eHnh_vyUs3gth0J
EURO: €
Email_key: 0362c92d8a619990216f76a2ad19e05a
'Facebook id': '506267103471810'
'Facebook link': 'https://www.facebook.com/biletwise'
Filter_price_max: '1000'
Filter_price_min: '0'
Filter_price_range: '200'
'Google client id': '#'
Hardik: [email protected]
Home: 'Home Address'
Image_max_size_MB: '1'
'Instagram link': 'https://www.instagram.com/biletwise/'
'Mobile format': '+90'
Newsletter: 'Front newsletter'
Notification_popup_time: '6'
Office: Office
'Page title postfix': '| biletwise'
Play_store_link: www.google.com
'Playstore link': '#'
TRY: TL
Tax: '0'
'Theme Layout': left
'Twitter link': 'https://twitter.com/biletwise'
USD: $
admin_default_language: tr
admin_email: [email protected]
alternate_url: '{"tr":{"url":"http:\/\/new.biletwise.com\/tr\/","name":"Turkish"},"en":{"url":"http:\/\/new.biletwise.com\/en\/","name":"English"}}'
app_blog_df: 'dd MMMM yyyy'
app_event_detail_df: P
app_event_detail_tf: t
app_payment_accept_url: 'https://new.biletwise.com/hipay/accept'
app_payment_account_id: '9506434'
app_payment_account_id_test: '9506434'
app_payment_cancel_url: 'https://new.biletwise.com/hipay/cancel?cancel=1'
app_payment_install_url: 'https://new.biletwise.com/hipay/install'
app_payment_logo_url: 'https://new.biletwise.com.com/assets/images/logo.svg'
app_payment_projectid: '162822'
app_payment_reject_url: 'https://new.biletwise.com/hipay/cancel?cancel=0'
app_payment_sign_key: eef490f6eab3a53f5b27faba349c4448
app_payment_sign_key_test: eef490f6eab3a53f5b27faba349c4448
app_payment_url: 'https://payment.hipay.com/index/form/'
app_payment_url_test: 'https://test-payment.hipay.com/index/form/'
app_payment_websiteid: '162822'
app_payment_websiteid_test: '162822'
app_paymnet_backend_url: 'https://new.biletwise.com/hipay/backend'
app_popular_event_df: 'dd MMMM dddd HH:mm'
app_sell_fifth_steps_df: 'dd MMM yyyy, HH:mm'
app_sell_steps_df: P
app_sell_steps_tf: t
app_sfImageTransformPlugin_default_adapter: GD
app_sfImageTransformPlugin_default_image:
  mime_type: image/png
  filename: Untitled.png
  width: 100
  height: 100
  color: '#FFFFFF'
app_sfImageTransformPlugin_font_dir: /usr/share/fonts/truetype/msttcorefonts
app_sfImageTransformPlugin_mime_type:
  auto_detect: true
  library: gd_mime_type
app_sf_captchagd_background_color: FFFFFF
app_sf_captchagd_border_color: CCCCCC
app_sf_captchagd_chars: '123456789'
app_sf_captchagd_font_color:
  - '000000'
app_sf_captchagd_font_size: 18
app_sf_captchagd_force_new_captcha: true
app_sf_captchagd_image_height: 30
app_sf_captchagd_image_width: 150
app_sf_captchagd_length: 4
assets_version: '1'
buy_timer_in_minute: '15'
career_type: 'Business Development,Developer,Customer Service'
cargo_price: '0'
cargo_price_min: '0'
cash_on_delivery_price: '9'
client_default_language: hr
cookie_link: /index.php/en/page/cookies-policy/
cookie_link_word: 'Cookies Policy'
currency_update_time_in_minute: '20'
default_image_color: '#C1A9A5'
discount_prefix: Bilet
euro_to_try: '9.3241'
euro_to_usd: '1.1979'
event_EURO: en
event_TRY: tr
event_USD: en
event_ticket_cookie_time_in_minutes: '5'
exchange_rate: '0.5'
front_pagination_limit: '10'
google_analytics: '#'
home_big_event_link_en: 'https://new.biletwise.com/en/euro-2020-biletleri'
home_big_event_link_tr: 'https://new.biletwise.com/tr/euro-2020-mac-biletleri'
image_optimise_key: JhDq9jXbCskxYFLBb8t2Hx7Q8NDQWjDF
instagram_access_token: '#'
instagram_home_count: '8'
is_google_captcha_on: '1'
is_live_mode: '0'
kajal: [email protected]
[email protected]: [email protected]
'khyati Dobariya': [email protected]
mod_home_enabled: true
mod_home_view_class: sfPHP
payment_currency: EUR
payout_date1: '10'
payout_date2: '24'
sf_admin_module_web_dir: /sfDoctrinePlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: client
sf_app_base_cache_dir: /home/biletwise/public_html/new/cache/client
sf_app_cache_dir: /home/biletwise/public_html/new/cache/client/dev
sf_app_config_dir: /home/biletwise/public_html/new/apps/client/config
sf_app_dir: /home/biletwise/public_html/new/apps/client
sf_app_i18n_dir: /home/biletwise/public_html/new/apps/client/i18n
sf_app_lib_dir: /home/biletwise/public_html/new/apps/client/lib
sf_app_module_dir: /home/biletwise/public_html/new/apps/client/modules
sf_app_template_dir: /home/biletwise/public_html/new/apps/client/templates
sf_apps_dir: /home/biletwise/public_html/new/apps
sf_cache: false
sf_cache_dir: /home/biletwise/public_html/new/cache
sf_charset: utf-8
sf_check_lock: false
sf_compressed: false
sf_config_cache_dir: /home/biletwise/public_html/new/cache/client/dev/config
sf_config_dir: /home/biletwise/public_html/new/config
sf_csrf_secret: 4d62fa6ad27f727a7e66a9effc4c1cdfaa788139
sf_data_dir: /home/biletwise/public_html/new/data
sf_debug: true
sf_default_culture: en
sf_enabled_modules:
  - default
  - sfGuardGroup
  - sfGuardUser
  - sfGuardForgotPassword
  - sfGuardPermission
  - sfCaptchaGD
  - user
  - message
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: home
sf_error_reporting: 32767
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: true
sf_etag: false
sf_file_link_format: null
sf_i18n: true
sf_i18n_cache_dir: /home/biletwise/public_html/new/cache/client/dev/i18n
sf_lib_dir: /home/biletwise/public_html/new/lib
sf_log_dir: /home/biletwise/public_html/new/log
sf_logging_enabled: true
sf_login_action: signin
sf_login_module: user
sf_module_cache_dir: /home/biletwise/public_html/new/cache/client/dev/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: false
sf_orm: doctrine
sf_plugins_dir: /home/biletwise/public_html/new/plugins
sf_root_dir: /home/biletwise/public_html/new
sf_secure_action: secure
sf_secure_module: default
sf_standard_helpers:
  - Partial
  - Cache
  - I18N
  - Date
sf_symfony_lib_dir: /home/biletwise/public_html/new/lib/vendor/symfony/lib
sf_template_cache_dir: /home/biletwise/public_html/new/cache/client/dev/template
sf_test_cache_dir: /home/biletwise/public_html/new/cache/client/dev/test
sf_test_dir: /home/biletwise/public_html/new/test
sf_upload_dir: /home/biletwise/public_html/new/uploads
sf_use_database: true
sf_web_debug: true
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /home/biletwise/public_html/new
site_address_cookie: bilet_address
site_cart_cookie: bilet_cart
site_culture: en
site_name: biletwise
site_url: 'https://new.biletwise.com'
static_image_module: 'Homepage, Home activity, Bilet Sat, Login'
symfony.asset.javascripts_included: true
symfony.asset.stylesheets_included: true
test: test
try_to_euro: '0.1072'
try_to_usd: '0.1285'
url_prefix: 'https://'
usd_to_euro: '0.8348'
usd_to_try: '7.7837'

cookie: {  }
env: {  }
files: {  }
get: {  }
post: {  }
server:
  CONTEXT_DOCUMENT_ROOT: /home/biletwise/public_html/new
  CONTEXT_PREFIX: ''
  DOCUMENT_ROOT: /home/biletwise/public_html/new
  GATEWAY_INTERFACE: CGI/1.1
  HTTPS: on
  HTTP_ACCEPT: 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8'
  HTTP_ACCEPT_ENCODING: gzip
  HTTP_ACCEPT_LANGUAGE: 'en-US,en;q=0.5'
  HTTP_CDN_LOOP: cloudflare
  HTTP_CF_CONNECTING_IP: 3.238.190.82
  HTTP_CF_IPCOUNTRY: US
  HTTP_CF_RAY: 5fa73343bdd474a3-IAD
  HTTP_CF_REQUEST_ID: 06bc5e5e56000074a3cc901000000001
  HTTP_CF_VISITOR: '{"scheme":"https"}'
  HTTP_CONNECTION: Keep-Alive
  HTTP_HOST: new.biletwise.com
  HTTP_IF_MODIFIED_SINCE: 'Sat, 24 Oct 2020 23:20:36 GMT'
  HTTP_USER_AGENT: 'CCBot/2.0 (https://commoncrawl.org/faq/)'
  HTTP_X_FORWARDED_FOR: 3.238.190.82
  HTTP_X_FORWARDED_PROTO: https
  PATH: '/bin:/usr/bin'
  PHP_INI_SCAN_DIR: '/opt/cpanel/ea-php73/root/etc:/opt/cpanel/ea-php73/root/etc/php.d:.'
  PHP_SELF: /index.php
  QUERY_STRING: ''
  REDIRECT_HTTPS: on
  REDIRECT_SSL_TLS_SNI: new.biletwise.com
  REDIRECT_STATUS: '200'
  REDIRECT_UNIQUE_ID: X8VROKrYw4IZ35LGhJBYygAAAHE
  REDIRECT_URL: /
  REMOTE_ADDR: 172.69.62.227
  REMOTE_PORT: '12526'
  REQUEST_METHOD: GET
  REQUEST_SCHEME: https
  REQUEST_TIME: 1606766904
  REQUEST_TIME_FLOAT: 1606766904.4504
  REQUEST_URI: /
  SCRIPT_FILENAME: /home/biletwise/public_html/new/index.php
  SCRIPT_NAME: /index.php
  SERVER_ADDR: 51.89.134.81
  SERVER_ADMIN: [email protected]
  SERVER_NAME: new.biletwise.com
  SERVER_PORT: '443'
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SIGNATURE: ''
  SERVER_SOFTWARE: Apache
  SSL_TLS_SNI: new.biletwise.com
  TZ: Europe/Istanbul
  UNIQUE_ID: X8VROKrYw4IZ35LGhJBYygAAAHE
  argc: 0
  argv: {  }
session: {  }

php: 7.3.24
os: 'Linux citadel.ketencekhost.com 3.10.0-957.10.1.el7.x86_64 #1 SMP Mon Mar 18 15:06:45 UTC 2019 x86_64'
extensions:
  15: 'bcmath (7.3.24)'
  16: 'calendar (7.3.24)'
  14: cgi-fcgi
  0: 'Core (7.3.24)'
  17: 'ctype (7.3.24)'
  18: 'curl (7.3.24)'
  1: 'date (7.3.24)'
  19: 'dom (20031129)'
  20: 'fileinfo (7.3.24)'
  6: 'filter (7.3.24)'
  21: 'ftp (7.3.24)'
  22: 'gd (7.3.24)'
  7: 'hash (7.3.24)'
  23: 'iconv (7.3.24)'
  24: 'imap (7.3.24)'
  25: 'json (1.7.0)'
  2: 'libxml (7.3.24)'
  26: 'mbstring (7.3.24)'
  40: 'mysqli (7.3.24)'
  27: 'mysqlnd (mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $)'
  3: 'openssl (7.3.24)'
  8: 'pcntl (7.3.24)'
  4: 'pcre (7.3.24)'
  28: 'PDO (7.3.24)'
  41: 'pdo_mysql (7.3.24)'
  42: 'pdo_sqlite (7.3.24)'
  29: 'Phar (7.3.24)'
  30: 'posix (7.3.24)'
  9: 'readline (7.3.24)'
  10: 'Reflection (7.3.24)'
  12: 'session (7.3.24)'
  31: 'SimpleXML (7.3.24)'
  32: 'soap (7.3.24)'
  33: 'sockets (7.3.24)'
  11: 'SPL (7.3.24)'
  34: 'sqlite3 (7.3.24)'
  13: 'standard (7.3.24)'
  35: 'tokenizer (7.3.24)'
  43: 'wddx (7.3.24)'
  36: 'xml (7.3.24)'
  44: 'xmlreader (7.3.24)'
  45: 'xmlrpc (7.3.24)'
  37: 'xmlwriter (7.3.24)'
  38: 'xsl (7.3.24)'
  39: 'zip (1.15.4)'
  5: 'zlib (7.3.24)'

version: 1.4.17
path: /home/biletwise/public_html/new/lib/vendor/symfony/lib

Parameters:

• $home_products (array)
• $upcoming_products (array)

No parameters were passed to this template.

Parameters:

• $product (array)
• $on_home (string)

Parameters:

• $product (array)
• $on_home (string)

Parameters:

• $product (array)
• $on_home (string)

Parameters:

• $product (array)
• $on_home (string)

Parameters:

• $product (array)
• $on_home (string)

Parameters:

• $product (array)
• $on_home (string)

Parameters:

• $product (array)
• $on_home (string)

Parameters:

• $product (array)
• $on_home (string)

Parameters:

• $product (array)
• $on_home (string)

Parameters:

• $product (array)
• $on_home (string)

Parameters:

• $product (array)
• $on_home (string)

Parameters:

• $product (array)
• $on_home (string)

Parameters:

• $product (array)
• $upcoming (string)

Parameters:

• $product (array)
• $upcoming (string)

Parameters:

• $product (array)
• $upcoming (string)

Parameters:

• $product (array)
• $upcoming (string)

Parameters:

• $product (array)
• $upcoming (string)

Parameters:

• $product (array)
• $upcoming (string)

Parameters:

• $product (array)
• $upcoming (string)

Parameters:

• $product (array)
• $upcoming (string)

Parameters:

• $product (array)
• $upcoming (string)

Parameters:

• $product (array)
• $upcoming (string)

No parameters were passed to this template.

No parameters were passed to this template.

Parameters:

• $pricetype (array)
• $level1 (array)
• $level2 (array)
• $level3 (array)

Parameters:

• $langs (array)

Parameters:

• $level1 (array)
• $level2 (array)
• $level3 (array)

Parameters:

• $about_us (array)
• $services (array)
• $agreement (array)
• $blogs (array)

Parameters:

• $form (NewsletterForm)
  • $form['id'] (sfWidgetFormInputHidden)
  • $form['name'] (sfWidgetFormInputText)
  • $form['email'] (sfWidgetFormInputText)
  • $form['subscribed_type'] (sfWidgetFormInputHidden)
  • $form['status'] (sfWidgetFormInputCheckbox)
  • $form['is_subscribed'] (sfWidgetFormInputCheckbox)
  • $form['_csrf_token'] (sfWidgetFormInputHidden)

No parameters were passed to this template.

Doctrine Version: 1.2.4

1. SET NAMES 'UTF8'

   0.00s, "doctrine" connection

2. SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))

   0.00s, "doctrine" connection

3. SELECT l.id AS l__id, l.status AS l__status, l.is_front AS l__is_front, l.name AS l__name, l.lang_code AS l__lang_code, l.ord AS l__ord, l.created_at AS l__created_at, l.updated_at AS l__updated_at FROM language_table l WHERE (l.is_front = 1) ORDER BY l.ord asc

   0.00s, "doctrine" connection

4. SELECT s.id AS s__id, s.name AS s__name, s.label AS s__label, s.value AS s__value, s.status AS s__status, s.ord AS s__ord, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM settings s WHERE (s.label = 'Setting_currency')

   0.00s, "doctrine" connection

5. SELECT s.id AS s__id, s.name AS s__name, s.label AS s__label, s.value AS s__value, s.status AS s__status, s.ord AS s__ord, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM settings s WHERE (s.name = 'currency_update_time_in_minute') LIMIT 1

   0.00s, "doctrine" connection

6. UPDATE settings SET value = '0.1072', updated_at = '2020-11-30 23:08:24' WHERE id = '90'

   0.00s, "doctrine" connection

7. UPDATE settings SET value = '9.3241', updated_at = '2020-11-30 23:08:25' WHERE id = '91'

   0.00s, "doctrine" connection

8. UPDATE settings SET value = '0.1285', updated_at = '2020-11-30 23:08:25' WHERE id = '92'

   0.00s, "doctrine" connection

9. UPDATE settings SET value = '7.7837', updated_at = '2020-11-30 23:08:25' WHERE id = '93'

   0.00s, "doctrine" connection

10. UPDATE settings SET value = '0.8348', updated_at = '2020-11-30 23:08:26' WHERE id = '94'

    0.00s, "doctrine" connection

11. UPDATE settings SET value = '1.1979', updated_at = '2020-11-30 23:08:26' WHERE id = '95'

    0.00s, "doctrine" connection

12. SELECT s.id AS s__id, s.name AS s__name, s.label AS s__label, s.value AS s__value, s.status AS s__status, s.ord AS s__ord, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM settings s WHERE (s.status = 1)

    0.00s, "doctrine" connection

13. SELECT r.id AS r__id, r.old_url AS r__old_url, r.new_url AS r__new_url, r.status AS r__status, r.created_at AS r__created_at, r.updated_at AS r__updated_at FROM redirection_tabel r WHERE (r.status = '1' AND r.old_url = 'https://new.biletwise.com/')

    0.00s, "doctrine" connection

14. SELECT DISTINCT p3.id FROM product p3 LEFT JOIN product_translation p4 ON p3.id = p4.id AND (p4.lang = 'en') WHERE p3.status = 1 AND p3.on_home = 1 AND TIMESTAMP(p3.date, p3.time) >= '2020-11-30 23:08:26' ORDER BY p3.date asc, p3.time asc LIMIT 12

    0.02s, "doctrine" connection

15. SELECT p.id AS p__id, p.date AS p__date, p.delivery_date AS p__delivery_date, p.time AS p__time, p.canonical_url AS p__canonical_url, p.image AS p__image, p.image_alt AS p__image_alt, p.banner_image AS p__banner_image, p.commission AS p__commission, p.buy_commission AS p__buy_commission, p.shipping_charge AS p__shipping_charge, p.same_country_shipping_charge AS p__same_country_shipping_charge, p.other_country_shipping_charge AS p__other_country_shipping_charge, p.currency AS p__currency, p.venue_id AS p__venue_id, p.venue_ground_id AS p__venue_ground_id, p.sold_time_display AS p__sold_time_display, p.ord AS p__ord, p.on_home AS p__on_home, p.is_frezz AS p__is_frezz, p.is_big_event AS p__is_big_event, p.is_featured AS p__is_featured, p.is_risky AS p__is_risky, p.is_allow_user AS p__is_allow_user, p.is_last_minute AS p__is_last_minute, p.status AS p__status, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.name AS p2__name, p2.breadcrumb_name AS p2__breadcrumb_name, p2.short_description AS p2__short_description, p2.description AS p2__description, p2.meta_title AS p2__meta_title, p2.meta_keyword AS p2__meta_keyword, p2.meta_description AS p2__meta_description, p2.warning_message AS p2__warning_message, p2.lang AS p2__lang, p2.slug AS p2__slug FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id AND (p2.lang = 'en') WHERE p.id IN ('185', '23', '305', '295', '261', '226', '273', '214', '312', '257', '102', '220') AND (p.status = 1 AND p.on_home = 1 AND TIMESTAMP(p.date, p.time) >= '2020-11-30 23:08:26') ORDER BY p.date asc, p.time asc

    0.00s, "doctrine" connection

16. SELECT DISTINCT p3.id FROM product p3 LEFT JOIN product_translation p4 ON p3.id = p4.id AND (p4.lang = 'en') WHERE p3.status = 1 AND TIMESTAMP(p3.date, p3.time) >= '2020-11-30 23:08:26' ORDER BY p3.date asc, p3.time asc LIMIT 10

    0.00s, "doctrine" connection

17. SELECT p.id AS p__id, p.date AS p__date, p.delivery_date AS p__delivery_date, p.time AS p__time, p.canonical_url AS p__canonical_url, p.image AS p__image, p.image_alt AS p__image_alt, p.banner_image AS p__banner_image, p.commission AS p__commission, p.buy_commission AS p__buy_commission, p.shipping_charge AS p__shipping_charge, p.same_country_shipping_charge AS p__same_country_shipping_charge, p.other_country_shipping_charge AS p__other_country_shipping_charge, p.currency AS p__currency, p.venue_id AS p__venue_id, p.venue_ground_id AS p__venue_ground_id, p.sold_time_display AS p__sold_time_display, p.ord AS p__ord, p.on_home AS p__on_home, p.is_frezz AS p__is_frezz, p.is_big_event AS p__is_big_event, p.is_featured AS p__is_featured, p.is_risky AS p__is_risky, p.is_allow_user AS p__is_allow_user, p.is_last_minute AS p__is_last_minute, p.status AS p__status, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.name AS p2__name, p2.breadcrumb_name AS p2__breadcrumb_name, p2.short_description AS p2__short_description, p2.description AS p2__description, p2.meta_title AS p2__meta_title, p2.meta_keyword AS p2__meta_keyword, p2.meta_description AS p2__meta_description, p2.warning_message AS p2__warning_message, p2.lang AS p2__lang, p2.slug AS p2__slug FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id AND (p2.lang = 'en') WHERE p.id IN ('185', '249', '200', '272', '289', '23', '86', '305', '298', '304') AND (p.status = 1 AND TIMESTAMP(p.date, p.time) >= '2020-11-30 23:08:26') ORDER BY p.date asc, p.time asc

    0.00s, "doctrine" connection

18. SELECT p.id AS p__id, p.name AS p__name, p.description AS p__description, p.status AS p__status, p.created_at AS p__created_at, p.updated_at AS p__updated_at FROM price_type p WHERE (p.status = 1)

    0.00s, "doctrine" connection

19. SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.level AS c__level, c.lft AS c__lft, c.rgt AS c__rgt, c.category_type AS c__category_type, c.on_home AS c__on_home, c.on_footer AS c__on_footer, c.status AS c__status, c.image AS c__image, c.score_status_link AS c__score_status_link, c.banner_image AS c__banner_image, c.ord AS c__ord, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.name AS c2__name, c2.name_on_home AS c2__name_on_home, c2.breadcrumb_name AS c2__breadcrumb_name, c2.description AS c2__description, c2.image_alt AS c2__image_alt, c2.meta_title AS c2__meta_title, c2.meta_keyword AS c2__meta_keyword, c2.meta_description AS c2__meta_description, c2.lang AS c2__lang, c2.slug AS c2__slug, (select IFNULL(COUNT(*), 0) from category_product where c.id = category_id group by category_id) AS c__0 FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id AND (c2.lang = 'en') WHERE (c.id NOT IN ('1') AND c.status = 1 AND c.level < 4) ORDER BY c.lft asc

    0.00s, "doctrine" connection

20. SELECT s.id AS s__id, s.image AS s__image, s.banner_image AS s__banner_image, s.status AS s__status, s.on_home AS s__on_home, s.ord AS s__ord, s.cat_type AS s__cat_type, s.created_at AS s__created_at, s.updated_at AS s__updated_at, s2.id AS s2__id, s2.title AS s2__title, s2.sub_title AS s2__sub_title, s2.short_description AS s2__short_description, s2.description AS s2__description, s2.image_alt AS s2__image_alt, s2.meta_title AS s2__meta_title, s2.meta_keyword AS s2__meta_keyword, s2.meta_description AS s2__meta_description, s2.lang AS s2__lang, s2.slug AS s2__slug FROM static_page s LEFT JOIN static_page_translation s2 ON s.id = s2.id AND (s2.lang = 'en') WHERE (s.cat_type IN ('About_us', 'services', 'signup_agreement') AND s.status = 1) ORDER BY s.ord asc

    0.00s, "doctrine" connection

21. SELECT DISTINCT b3.id FROM blog b3 LEFT JOIN blog_translation b4 ON b3.id = b4.id AND (b4.lang = 'en') WHERE b3.cat_id = '1' AND b3.status = 1 ORDER BY b3.created_at desc LIMIT 3

    0.00s, "doctrine" connection

22. SELECT b.id AS b__id, b.image AS b__image, b.footer_image AS b__footer_image, b.banner_image AS b__banner_image, b.blogdate AS b__blogdate, b.status AS b__status, b.ord AS b__ord, b.on_footer AS b__on_footer, b.cat_id AS b__cat_id, b.created_at AS b__created_at, b.updated_at AS b__updated_at, b2.id AS b2__id, b2.name AS b2__name, b2.short_description AS b2__short_description, b2.description AS b2__description, b2.meta_title AS b2__meta_title, b2.meta_keyword AS b2__meta_keyword, b2.meta_description AS b2__meta_description, b2.lang AS b2__lang, b2.slug AS b2__slug FROM blog b LEFT JOIN blog_translation b2 ON b.id = b2.id AND (b2.lang = 'en') WHERE b.id IS NULL AND (b.cat_id = '1' AND b.status = 1) ORDER BY b.created_at desc

    0.00s, "doctrine" connection