Symfony Profiler

SELECT 
  t0.id AS id_1, 
  t0.value AS value_2 
FROM 
  RobotsFilter t0 
WHERE 
  t0.value IN (?)

SELECT t0.id AS id_1, t0.value AS value_2 FROM RobotsFilter t0 WHERE t0.value IN ('57.141.3.9', '57.141.3.*', '57.141.*.*', '57.*.*.*');

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.abbreviation AS abbreviation_3, 
  t0.friendly_url AS friendly_url_4, 
  t0.page_title AS page_title_5, 
  t0.seo_description AS seo_description_6, 
  t0.seo_keywords AS seo_keywords_7, 
  t0.latitude AS latitude_8, 
  t0.longitude AS longitude_9, 
  t0.radius AS radius_10, 
  t0.import_id AS import_id_11 
FROM 
  Location_1 t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.friendly_url AS friendly_url_4, t0.page_title AS page_title_5, t0.seo_description AS seo_description_6, t0.seo_keywords AS seo_keywords_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.radius AS radius_10, t0.import_id AS import_id_11 FROM Location_1 t0 WHERE t0.id = 1;

SELECT 
  t0.id AS id_1, 
  t0.location_2 AS location_2_2, 
  t0.location_1 AS location_1_3, 
  t0.name AS name_4, 
  t0.abbreviation AS abbreviation_5, 
  t0.friendly_url AS friendly_url_6, 
  t0.page_title AS page_title_7, 
  t0.seo_description AS seo_description_8, 
  t0.seo_keywords AS seo_keywords_9, 
  t0.latitude AS latitude_10, 
  t0.longitude AS longitude_11, 
  t0.radius AS radius_12, 
  t0.import_id AS import_id_13 
FROM 
  Location_3 t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.location_2 AS location_2_2, t0.location_1 AS location_1_3, t0.name AS name_4, t0.abbreviation AS abbreviation_5, t0.friendly_url AS friendly_url_6, t0.page_title AS page_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.radius AS radius_12, t0.import_id AS import_id_13 FROM Location_3 t0 WHERE t0.id = 15;

SELECT 
  t0.id AS id_1, 
  t0.location_3 AS location_3_2, 
  t0.location_2 AS location_2_3, 
  t0.location_1 AS location_1_4, 
  t0.name AS name_5, 
  t0.abbreviation AS abbreviation_6, 
  t0.friendly_url AS friendly_url_7, 
  t0.page_title AS page_title_8, 
  t0.seo_description AS seo_description_9, 
  t0.seo_keywords AS seo_keywords_10, 
  t0.latitude AS latitude_11, 
  t0.longitude AS longitude_12, 
  t0.radius AS radius_13, 
  t0.import_id AS import_id_14 
FROM 
  Location_4 t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.location_3 AS location_3_2, t0.location_2 AS location_2_3, t0.location_1 AS location_1_4, t0.name AS name_5, t0.abbreviation AS abbreviation_6, t0.friendly_url AS friendly_url_7, t0.page_title AS page_title_8, t0.seo_description AS seo_description_9, t0.seo_keywords AS seo_keywords_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12, t0.radius AS radius_13, t0.import_id AS import_id_14 FROM Location_4 t0 WHERE t0.id = 117;

SELECT 
  t0.name AS name_1, 
  t0.value AS value_2 
FROM 
  Setting t0

SELECT t0.name AS name_1, t0.value AS value_2 FROM Setting t0;

SELECT 
  t0.id AS id_1, 
  t0.account_id AS account_id_2, 
  t0.image_id AS image_id_3, 
  t0.thumb_id AS thumb_id_4, 
  t0.cover_id AS cover_id_5, 
  t0.location_1 AS location_1_6, 
  t0.location_2 AS location_2_7, 
  t0.location_3 AS location_3_8, 
  t0.location_4 AS location_4_9, 
  t0.location_5 AS location_5_10, 
  t0.updated AS updated_11, 
  t0.entered AS entered_12, 
  t0.renewal_date AS renewal_date_13, 
  t0.discount_id AS discount_id_14, 
  t0.title AS title_15, 
  t0.seo_title AS seo_title_16, 
  t0.friendly_url AS friendly_url_17, 
  t0.email AS email_18, 
  t0.show_email AS show_email_19, 
  t0.url AS url_20, 
  t0.display_url AS display_url_21, 
  t0.short_url AS short_url_22, 
  t0.address AS address_23, 
  t0.address2 AS address2_24, 
  t0.zip_code AS zip_code_25, 
  t0.latitude AS latitude_26, 
  t0.longitude AS longitude_27, 
  t0.design AS design_28, 
  t0.phone AS phone_29, 
  t0.fax AS fax_30, 
  t0.description AS description_31, 
  t0.year AS year_32, 
  t0.no_of_employee AS no_of_employee_33, 
  t0.total_ads_year AS total_ads_year_34, 
  t0.order AS order_35, 
  t0.packageinfo AS packageinfo_36, 
  t0.logo AS logo_37, 
  t0.ads_no AS ads_no_38, 
  t0.book_type_name AS book_type_name_39, 
  t0.seo_description AS seo_description_40, 
  t0.long_description AS long_description_41, 
  t0.keywords AS keywords_42, 
  t0.seo_keywords AS seo_keywords_43, 
  t0.attachment_file AS attachment_file_44, 
  t0.attachment_caption AS attachment_caption_45, 
  t0.features AS features_46, 
  t0.price AS price_47, 
  t0.social_network AS social_network_48, 
  t0.status AS status_49, 
  t0.level AS level_50, 
  t0.reminder AS reminder_51, 
  t0.fulltextsearch_keyword AS fulltextsearch_keyword_52, 
  t0.fulltextsearch_where AS fulltextsearch_where_53, 
  t0.video_snippet AS video_snippet_54, 
  t0.video_url AS video_url_55, 
  t0.video_description AS video_description_56, 
  t0.hours_work AS hours_work_57, 
  t0.locations AS locations_58, 
  t0.claim_disable AS claim_disable_59, 
  t0.custom_checkbox0 AS custom_checkbox0_60, 
  t0.custom_checkbox1 AS custom_checkbox1_61, 
  t0.custom_checkbox2 AS custom_checkbox2_62, 
  t0.custom_checkbox3 AS custom_checkbox3_63, 
  t0.custom_checkbox4 AS custom_checkbox4_64, 
  t0.custom_checkbox5 AS custom_checkbox5_65, 
  t0.custom_checkbox6 AS custom_checkbox6_66, 
  t0.custom_checkbox7 AS custom_checkbox7_67, 
  t0.custom_checkbox8 AS custom_checkbox8_68, 
  t0.custom_checkbox9 AS custom_checkbox9_69, 
  t0.custom_dropdown0 AS custom_dropdown0_70, 
  t0.custom_dropdown1 AS custom_dropdown1_71, 
  t0.custom_dropdown2 AS custom_dropdown2_72, 
  t0.custom_dropdown3 AS custom_dropdown3_73, 
  t0.custom_dropdown4 AS custom_dropdown4_74, 
  t0.custom_dropdown5 AS custom_dropdown5_75, 
  t0.custom_dropdown6 AS custom_dropdown6_76, 
  t0.custom_dropdown7 AS custom_dropdown7_77, 
  t0.custom_dropdown8 AS custom_dropdown8_78, 
  t0.custom_dropdown9 AS custom_dropdown9_79, 
  t0.custom_text0 AS custom_text0_80, 
  t0.custom_text1 AS custom_text1_81, 
  t0.custom_text2 AS custom_text2_82, 
  t0.custom_text3 AS custom_text3_83, 
  t0.custom_text4 AS custom_text4_84, 
  t0.custom_text5 AS custom_text5_85, 
  t0.custom_text6 AS custom_text6_86, 
  t0.custom_text7 AS custom_text7_87, 
  t0.custom_text8 AS custom_text8_88, 
  t0.custom_text9 AS custom_text9_89, 
  t0.custom_short_desc0 AS custom_short_desc0_90, 
  t0.custom_short_desc1 AS custom_short_desc1_91, 
  t0.custom_short_desc2 AS custom_short_desc2_92, 
  t0.custom_short_desc3 AS custom_short_desc3_93, 
  t0.custom_short_desc4 AS custom_short_desc4_94, 
  t0.custom_short_desc5 AS custom_short_desc5_95, 
  t0.custom_short_desc6 AS custom_short_desc6_96, 
  t0.custom_short_desc7 AS custom_short_desc7_97, 
  t0.custom_short_desc8 AS custom_short_desc8_98, 
  t0.custom_short_desc9 AS custom_short_desc9_99, 
  t0.custom_long_desc0 AS custom_long_desc0_100, 
  t0.custom_long_desc1 AS custom_long_desc1_101, 
  t0.custom_long_desc2 AS custom_long_desc2_102, 
  t0.custom_long_desc3 AS custom_long_desc3_103, 
  t0.custom_long_desc4 AS custom_long_desc4_104, 
  t0.custom_long_desc5 AS custom_long_desc5_105, 
  t0.custom_long_desc6 AS custom_long_desc6_106, 
  t0.custom_long_desc7 AS custom_long_desc7_107, 
  t0.custom_long_desc8 AS custom_long_desc8_108, 
  t0.custom_long_desc9 AS custom_long_desc9_109, 
  t0.number_views AS number_views_110, 
  t0.avg_review AS avg_review_111, 
  t0.map_zoom AS map_zoom_112, 
  t0.package_id AS package_id_113, 
  t0.package_price AS package_price_114, 
  t0.last_traffic_sent AS last_traffic_sent_115, 
  t0.custom_id AS custom_id_116, 
  t0.parent_no AS parent_no_117, 
  t0.client_keyword AS client_keyword_118, 
  t0.business_keyword AS business_keyword_119, 
  t0.brand_keyword AS brand_keyword_120, 
  t0.product_keyword AS product_keyword_121, 
  t0.authorized_brand AS authorized_brand_122, 
  t0.search_term AS search_term_123, 
  t0.brand_ids AS brand_ids_124, 
  t0.product_ids AS product_ids_125, 
  t0.collected_date AS collected_date_126, 
  t0.msiccode AS msiccode_127, 
  t0.import_id AS import_id_128, 
  t0.listingtemplate_id AS listingtemplate_id_129, 
  t0.level AS level_130, 
  t0.image_id AS image_id_131, 
  t0.account_id AS account_id_132, 
  t0.cover_id AS cover_id_133 
FROM 
  Listing t0 
WHERE 
  t0.id = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.account_id AS account_id_2, t0.image_id AS image_id_3, t0.thumb_id AS thumb_id_4, t0.cover_id AS cover_id_5, t0.location_1 AS location_1_6, t0.location_2 AS location_2_7, t0.location_3 AS location_3_8, t0.location_4 AS location_4_9, t0.location_5 AS location_5_10, t0.updated AS updated_11, t0.entered AS entered_12, t0.renewal_date AS renewal_date_13, t0.discount_id AS discount_id_14, t0.title AS title_15, t0.seo_title AS seo_title_16, t0.friendly_url AS friendly_url_17, t0.email AS email_18, t0.show_email AS show_email_19, t0.url AS url_20, t0.display_url AS display_url_21, t0.short_url AS short_url_22, t0.address AS address_23, t0.address2 AS address2_24, t0.zip_code AS zip_code_25, t0.latitude AS latitude_26, t0.longitude AS longitude_27, t0.design AS design_28, t0.phone AS phone_29, t0.fax AS fax_30, t0.description AS description_31, t0.year AS year_32, t0.no_of_employee AS no_of_employee_33, t0.total_ads_year AS total_ads_year_34, t0.order AS order_35, t0.packageinfo AS packageinfo_36, t0.logo AS logo_37, t0.ads_no AS ads_no_38, t0.book_type_name AS book_type_name_39, t0.seo_description AS seo_description_40, t0.long_description AS long_description_41, t0.keywords AS keywords_42, t0.seo_keywords AS seo_keywords_43, t0.attachment_file AS attachment_file_44, t0.attachment_caption AS attachment_caption_45, t0.features AS features_46, t0.price AS price_47, t0.social_network AS social_network_48, t0.status AS status_49, t0.level AS level_50, t0.reminder AS reminder_51, t0.fulltextsearch_keyword AS fulltextsearch_keyword_52, t0.fulltextsearch_where AS fulltextsearch_where_53, t0.video_snippet AS video_snippet_54, t0.video_url AS video_url_55, t0.video_description AS video_description_56, t0.hours_work AS hours_work_57, t0.locations AS locations_58, t0.claim_disable AS claim_disable_59, t0.custom_checkbox0 AS custom_checkbox0_60, t0.custom_checkbox1 AS custom_checkbox1_61, t0.custom_checkbox2 AS custom_checkbox2_62, t0.custom_checkbox3 AS custom_checkbox3_63, t0.custom_checkbox4 AS custom_checkbox4_64, t0.custom_checkbox5 AS custom_checkbox5_65, t0.custom_checkbox6 AS custom_checkbox6_66, t0.custom_checkbox7 AS custom_checkbox7_67, t0.custom_checkbox8 AS custom_checkbox8_68, t0.custom_checkbox9 AS custom_checkbox9_69, t0.custom_dropdown0 AS custom_dropdown0_70, t0.custom_dropdown1 AS custom_dropdown1_71, t0.custom_dropdown2 AS custom_dropdown2_72, t0.custom_dropdown3 AS custom_dropdown3_73, t0.custom_dropdown4 AS custom_dropdown4_74, t0.custom_dropdown5 AS custom_dropdown5_75, t0.custom_dropdown6 AS custom_dropdown6_76, t0.custom_dropdown7 AS custom_dropdown7_77, t0.custom_dropdown8 AS custom_dropdown8_78, t0.custom_dropdown9 AS custom_dropdown9_79, t0.custom_text0 AS custom_text0_80, t0.custom_text1 AS custom_text1_81, t0.custom_text2 AS custom_text2_82, t0.custom_text3 AS custom_text3_83, t0.custom_text4 AS custom_text4_84, t0.custom_text5 AS custom_text5_85, t0.custom_text6 AS custom_text6_86, t0.custom_text7 AS custom_text7_87, t0.custom_text8 AS custom_text8_88, t0.custom_text9 AS custom_text9_89, t0.custom_short_desc0 AS custom_short_desc0_90, t0.custom_short_desc1 AS custom_short_desc1_91, t0.custom_short_desc2 AS custom_short_desc2_92, t0.custom_short_desc3 AS custom_short_desc3_93, t0.custom_short_desc4 AS custom_short_desc4_94, t0.custom_short_desc5 AS custom_short_desc5_95, t0.custom_short_desc6 AS custom_short_desc6_96, t0.custom_short_desc7 AS custom_short_desc7_97, t0.custom_short_desc8 AS custom_short_desc8_98, t0.custom_short_desc9 AS custom_short_desc9_99, t0.custom_long_desc0 AS custom_long_desc0_100, t0.custom_long_desc1 AS custom_long_desc1_101, t0.custom_long_desc2 AS custom_long_desc2_102, t0.custom_long_desc3 AS custom_long_desc3_103, t0.custom_long_desc4 AS custom_long_desc4_104, t0.custom_long_desc5 AS custom_long_desc5_105, t0.custom_long_desc6 AS custom_long_desc6_106, t0.custom_long_desc7 AS custom_long_desc7_107, t0.custom_long_desc8 AS custom_long_desc8_108, t0.custom_long_desc9 AS custom_long_desc9_109, t0.number_views AS number_views_110, t0.avg_review AS avg_review_111, t0.map_zoom AS map_zoom_112, t0.package_id AS package_id_113, t0.package_price AS package_price_114, t0.last_traffic_sent AS last_traffic_sent_115, t0.custom_id AS custom_id_116, t0.parent_no AS parent_no_117, t0.client_keyword AS client_keyword_118, t0.business_keyword AS business_keyword_119, t0.brand_keyword AS brand_keyword_120, t0.product_keyword AS product_keyword_121, t0.authorized_brand AS authorized_brand_122, t0.search_term AS search_term_123, t0.brand_ids AS brand_ids_124, t0.product_ids AS product_ids_125, t0.collected_date AS collected_date_126, t0.msiccode AS msiccode_127, t0.import_id AS import_id_128, t0.listingtemplate_id AS listingtemplate_id_129, t0.level AS level_130, t0.image_id AS image_id_131, t0.account_id AS account_id_132, t0.cover_id AS cover_id_133 FROM Listing t0 WHERE t0.id = '134091' LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.level AS level_2, 
  t0.field AS field_3 
FROM 
  ListingLevel_Field t0 
WHERE 
  t0.level = ?

SELECT t0.id AS id_1, t0.level AS level_2, t0.field AS field_3 FROM ListingLevel_Field t0 WHERE t0.level = 70;

SELECT 
  t0.value AS value_1, 
  t0.name AS name_2, 
  t0.defaultlevel AS defaultlevel_3, 
  t0.detail AS detail_4, 
  t0.images AS images_5, 
  t0.has_cover_image AS has_cover_image_6, 
  t0.has_logo_image AS has_logo_image_7, 
  t0.has_review AS has_review_8, 
  t0.price AS price_9, 
  t0.price_yearly AS price_yearly_10, 
  t0.free_category AS free_category_11, 
  t0.category_price AS category_price_12, 
  t0.active AS active_13, 
  t0.popular AS popular_14, 
  t0.featured AS featured_15, 
  t0.trial AS trial_16, 
  t0.deals AS deals_17, 
  t0.classified_quantity_association AS classified_quantity_association_18 
FROM 
  ListingLevel t0 
WHERE 
  t0.value = ?

SELECT t0.value AS value_1, t0.name AS name_2, t0.defaultlevel AS defaultlevel_3, t0.detail AS detail_4, t0.images AS images_5, t0.has_cover_image AS has_cover_image_6, t0.has_logo_image AS has_logo_image_7, t0.has_review AS has_review_8, t0.price AS price_9, t0.price_yearly AS price_yearly_10, t0.free_category AS free_category_11, t0.category_price AS category_price_12, t0.active AS active_13, t0.popular AS popular_14, t0.featured AS featured_15, t0.trial AS trial_16, t0.deals AS deals_17, t0.classified_quantity_association AS classified_quantity_association_18 FROM ListingLevel t0 WHERE t0.value = 70;

SELECT 
  t0.id AS id_1, 
  t0.listing_id AS listing_id_2, 
  t0.report_type AS report_type_3, 
  t0.report_amount AS report_amount_4, 
  t0.date AS date_5 
FROM 
  Report_Listing t0 
WHERE 
  t0.listing_id = ? 
  AND t0.date = ? 
  AND t0.report_type = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.listing_id AS listing_id_2, t0.report_type AS report_type_3, t0.report_amount AS report_amount_4, t0.date AS date_5 FROM Report_Listing t0 WHERE t0.listing_id = 134091 AND t0.date = '2025-01-23' AND t0.report_type = 2 LIMIT 1;

UPDATE 
  Listing 
SET 
  number_views = ? 
WHERE 
  id = ?

UPDATE Listing SET number_views = 4 WHERE id = 134091;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO Report_Listing (
  listing_id, report_type, report_amount, 
  date
) 
VALUES 
  (?, ?, ?, ?)

INSERT INTO Report_Listing (listing_id, report_type, report_amount, date) VALUES (134091, 2, 1, '2025-01-23');

"COMMIT"

"COMMIT";

SELECT 
  t0.id AS id_1, 
  t0.default_id AS default_id_2, 
  t0.name AS name_3, 
  t0.name_plural AS name_plural_4, 
  t0.enabled AS enabled_5, 
  t0.`show` AS show_6 
FROM 
  Setting_Location t0 
WHERE 
  t0.enabled = ?

SELECT t0.id AS id_1, t0.default_id AS default_id_2, t0.name AS name_3, t0.name_plural AS name_plural_4, t0.enabled AS enabled_5, t0.`show` AS show_6 FROM Setting_Location t0 WHERE t0.enabled = 'y';

SELECT 
  t0.id AS id_1, 
  t0.title AS title_2 
FROM 
  Theme t0 
WHERE 
  t0.title = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.title AS title_2 FROM Theme t0 WHERE t0.title = 'Default' LIMIT 1;

SELECT 
  COUNT(*) AS dctrn_count 
FROM 
  (
    SELECT 
      DISTINCT id_0 
    FROM 
      (
        SELECT 
          r0_.id AS id_0, 
          r0_.item_type AS item_type_1, 
          r0_.item_id AS item_id_2, 
          r0_.member_id AS member_id_3, 
          r0_.added AS added_4, 
          r0_.ip AS ip_5, 
          r0_.review_title AS review_title_6, 
          r0_.review AS review_7, 
          r0_.reviewer_name AS reviewer_name_8, 
          r0_.reviewer_email AS reviewer_email_9, 
          r0_.reviewer_location AS reviewer_location_10, 
          r0_.rating AS rating_11, 
          r0_.approved AS approved_12, 
          r0_.response AS response_13, 
          r0_.responseapproved AS responseapproved_14, 
          r0_.`like` AS like_15, 
          r0_.dislike AS dislike_16, 
          r0_.like_ips AS like_ips_17, 
          r0_.dislike_ips AS dislike_ips_18, 
          r0_.new AS new_19 
        FROM 
          Review r0_ 
        WHERE 
          r0_.item_id = ? 
          AND r0_.approved = ? 
          AND r0_.item_type = ? 
        ORDER BY 
          r0_.added DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.item_type AS item_type_1, r0_.item_id AS item_id_2, r0_.member_id AS member_id_3, r0_.added AS added_4, r0_.ip AS ip_5, r0_.review_title AS review_title_6, r0_.review AS review_7, r0_.reviewer_name AS reviewer_name_8, r0_.reviewer_email AS reviewer_email_9, r0_.reviewer_location AS reviewer_location_10, r0_.rating AS rating_11, r0_.approved AS approved_12, r0_.response AS response_13, r0_.responseapproved AS responseapproved_14, r0_.`like` AS like_15, r0_.dislike AS dislike_16, r0_.like_ips AS like_ips_17, r0_.dislike_ips AS dislike_ips_18, r0_.new AS new_19 FROM Review r0_ WHERE r0_.item_id = 134091 AND r0_.approved = 1 AND r0_.item_type = 'listing' ORDER BY r0_.added DESC) dctrn_result) dctrn_table;

SELECT 
  t0.id AS id_1, 
  t0.layout_id AS layout_id_2, 
  t0.title AS title_3, 
  t0.updated AS updated_4, 
  t0.entered AS entered_5, 
  t0.status AS status_6, 
  t0.price AS price_7, 
  t0.cat_id AS cat_id_8, 
  t0.editable AS editable_9, 
  t10.listingtemplate_id AS listingtemplate_id_11, 
  t10.field AS field_12, 
  t10.label AS label_13, 
  t10.fieldvalues AS fieldvalues_14, 
  t10.instructions AS instructions_15, 
  t10.required AS required_16, 
  t10.search AS search_17, 
  t10.searchbykeyword AS searchbykeyword_18, 
  t10.searchbyrange AS searchbyrange_19, 
  t10.show_order AS show_order_20, 
  t10.enabled AS enabled_21, 
  t10.listingtemplate_id AS listingtemplate_id_22 
FROM 
  ListingTemplate t0 
  LEFT JOIN ListingTemplate_Field t10 ON t10.listingtemplate_id = t0.id 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.layout_id AS layout_id_2, t0.title AS title_3, t0.updated AS updated_4, t0.entered AS entered_5, t0.status AS status_6, t0.price AS price_7, t0.cat_id AS cat_id_8, t0.editable AS editable_9, t10.listingtemplate_id AS listingtemplate_id_11, t10.field AS field_12, t10.label AS label_13, t10.fieldvalues AS fieldvalues_14, t10.instructions AS instructions_15, t10.required AS required_16, t10.search AS search_17, t10.searchbykeyword AS searchbykeyword_18, t10.searchbyrange AS searchbyrange_19, t10.show_order AS show_order_20, t10.enabled AS enabled_21, t10.listingtemplate_id AS listingtemplate_id_22 FROM ListingTemplate t0 LEFT JOIN ListingTemplate_Field t10 ON t10.listingtemplate_id = t0.id WHERE t0.id = 1;

SELECT 
  t0.name AS name_1, 
  t0.value AS value_2 
FROM 
  Setting t0 
WHERE 
  t0.name = ? 
LIMIT 
  1

SELECT t0.name AS name_1, t0.value AS value_2 FROM Setting t0 WHERE t0.name = 'review_listing_enabled' LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.title AS title_2, 
  t0.category_id AS category_id_3, 
  t0.cat_id AS cat_id_4, 
  t0.thumb_id AS thumb_id_5, 
  t0.image_id AS image_id_6, 
  t0.icon_id AS icon_id_7, 
  t0.type AS type_8, 
  t0.featured AS featured_9, 
  t0.summary_description AS summary_description_10, 
  t0.seo_description AS seo_description_11, 
  t0.page_title AS page_title_12, 
  t0.friendly_url AS friendly_url_13, 
  t0.keywords AS keywords_14, 
  t0.seo_keywords AS seo_keywords_15, 
  t0.content AS content_16, 
  t0.isic_no AS isic_no_17, 
  t0.title_mm AS title_mm_18, 
  t0.enabled AS enabled_19, 
  t0.category_id AS category_id_20, 
  t0.image_id AS image_id_21, 
  t22.id AS id_23, 
  t22.type AS type_24, 
  t22.width AS width_25, 
  t22.height AS height_26, 
  t22.prefix AS prefix_27, 
  t22.unsplash AS unsplash_28, 
  t0.icon_id AS icon_id_29, 
  t30.id AS id_31, 
  t30.type AS type_32, 
  t30.width AS width_33, 
  t30.height AS height_34, 
  t30.prefix AS prefix_35, 
  t30.unsplash AS unsplash_36, 
  t0.import_id AS import_id_37 
FROM 
  ListingCategory t0 
  LEFT JOIN Image t22 ON t0.image_id = t22.id 
  LEFT JOIN Image t30 ON t0.icon_id = t30.id 
  INNER JOIN Listing_Category ON t0.id = Listing_Category.category_id 
WHERE 
  Listing_Category.listing_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.category_id AS category_id_3, t0.cat_id AS cat_id_4, t0.thumb_id AS thumb_id_5, t0.image_id AS image_id_6, t0.icon_id AS icon_id_7, t0.type AS type_8, t0.featured AS featured_9, t0.summary_description AS summary_description_10, t0.seo_description AS seo_description_11, t0.page_title AS page_title_12, t0.friendly_url AS friendly_url_13, t0.keywords AS keywords_14, t0.seo_keywords AS seo_keywords_15, t0.content AS content_16, t0.isic_no AS isic_no_17, t0.title_mm AS title_mm_18, t0.enabled AS enabled_19, t0.category_id AS category_id_20, t0.image_id AS image_id_21, t22.id AS id_23, t22.type AS type_24, t22.width AS width_25, t22.height AS height_26, t22.prefix AS prefix_27, t22.unsplash AS unsplash_28, t0.icon_id AS icon_id_29, t30.id AS id_31, t30.type AS type_32, t30.width AS width_33, t30.height AS height_34, t30.prefix AS prefix_35, t30.unsplash AS unsplash_36, t0.import_id AS import_id_37 FROM ListingCategory t0 LEFT JOIN Image t22 ON t0.image_id = t22.id LEFT JOIN Image t30 ON t0.icon_id = t30.id INNER JOIN Listing_Category ON t0.id = Listing_Category.category_id WHERE Listing_Category.listing_id = 134091;

SELECT 
  t0.id AS id_1, 
  t0.account_id AS account_id_2, 
  t0.image_id AS image_id_3, 
  t0.thumb_id AS thumb_id_4, 
  t0.cover_id AS cover_id_5, 
  t0.updated AS updated_6, 
  t0.entered AS entered_7, 
  t0.name AS name_8, 
  t0.seo_name AS seo_name_9, 
  t0.description AS description_10, 
  t0.long_description AS long_description_11, 
  t0.seo_description AS seo_description_12, 
  t0.keywords AS keywords_13, 
  t0.seo_keywords AS seo_keywords_14, 
  t0.fulltextsearch_keyword AS fulltextsearch_keyword_15, 
  t0.fulltextsearch_where AS fulltextsearch_where_16, 
  t0.start_date AS start_date_17, 
  t0.end_date AS end_date_18, 
  t0.conditions AS conditions_19, 
  t0.number_views AS number_views_20, 
  t0.visibility_start AS visibility_start_21, 
  t0.visibility_end AS visibility_end_22, 
  t0.realvalue AS realvalue_23, 
  t0.dealvalue AS dealvalue_24, 
  t0.deal_type AS deal_type_25, 
  t0.amount AS amount_26, 
  t0.friendly_url AS friendly_url_27, 
  t0.listing_id AS listing_id_28, 
  t0.listing_status AS listing_status_29, 
  t0.listing_level AS listing_level_30, 
  t0.listing_location1 AS listing_location1_31, 
  t0.listing_location2 AS listing_location2_32, 
  t0.listing_location3 AS listing_location3_33, 
  t0.listing_location4 AS listing_location4_34, 
  t0.listing_location5 AS listing_location5_35, 
  t0.listing_address AS listing_address_36, 
  t0.listing_address2 AS listing_address2_37, 
  t0.listing_zipcode AS listing_zipcode_38, 
  t0.listing_latitude AS listing_latitude_39, 
  t0.listing_longitude AS listing_longitude_40, 
  t0.currency AS currency_41, 
  t0.first_name AS first_name_42, 
  t0.last_name AS last_name_43, 
  t0.email AS email_44, 
  t0.phone AS phone_45, 
  t0.address AS address_46, 
  t0.latitude AS latitude_47, 
  t0.longitude AS longitude_48, 
  t0.listing_id AS listing_id_49, 
  t50.id AS id_51, 
  t50.account_id AS account_id_52, 
  t50.image_id AS image_id_53, 
  t50.thumb_id AS thumb_id_54, 
  t50.cover_id AS cover_id_55, 
  t50.location_1 AS location_1_56, 
  t50.location_2 AS location_2_57, 
  t50.location_3 AS location_3_58, 
  t50.location_4 AS location_4_59, 
  t50.location_5 AS location_5_60, 
  t50.updated AS updated_61, 
  t50.entered AS entered_62, 
  t50.renewal_date AS renewal_date_63, 
  t50.discount_id AS discount_id_64, 
  t50.title AS title_65, 
  t50.seo_title AS seo_title_66, 
  t50.friendly_url AS friendly_url_67, 
  t50.email AS email_68, 
  t50.show_email AS show_email_69, 
  t50.url AS url_70, 
  t50.display_url AS display_url_71, 
  t50.short_url AS short_url_72, 
  t50.address AS address_73, 
  t50.address2 AS address2_74, 
  t50.zip_code AS zip_code_75, 
  t50.latitude AS latitude_76, 
  t50.longitude AS longitude_77, 
  t50.design AS design_78, 
  t50.phone AS phone_79, 
  t50.fax AS fax_80, 
  t50.description AS description_81, 
  t50.year AS year_82, 
  t50.no_of_employee AS no_of_employee_83, 
  t50.total_ads_year AS total_ads_year_84, 
  t50.order AS order_85, 
  t50.packageinfo AS packageinfo_86, 
  t50.logo AS logo_87, 
  t50.ads_no AS ads_no_88, 
  t50.book_type_name AS book_type_name_89, 
  t50.seo_description AS seo_description_90, 
  t50.long_description AS long_description_91, 
  t50.keywords AS keywords_92, 
  t50.seo_keywords AS seo_keywords_93, 
  t50.attachment_file AS attachment_file_94, 
  t50.attachment_caption AS attachment_caption_95, 
  t50.features AS features_96, 
  t50.price AS price_97, 
  t50.social_network AS social_network_98, 
  t50.status AS status_99, 
  t50.level AS level_100, 
  t50.reminder AS reminder_101, 
  t50.fulltextsearch_keyword AS fulltextsearch_keyword_102, 
  t50.fulltextsearch_where AS fulltextsearch_where_103, 
  t50.video_snippet AS video_snippet_104, 
  t50.video_url AS video_url_105, 
  t50.video_description AS video_description_106, 
  t50.hours_work AS hours_work_107, 
  t50.locations AS locations_108, 
  t50.claim_disable AS claim_disable_109, 
  t50.custom_checkbox0 AS custom_checkbox0_110, 
  t50.custom_checkbox1 AS custom_checkbox1_111, 
  t50.custom_checkbox2 AS custom_checkbox2_112, 
  t50.custom_checkbox3 AS custom_checkbox3_113, 
  t50.custom_checkbox4 AS custom_checkbox4_114, 
  t50.custom_checkbox5 AS custom_checkbox5_115, 
  t50.custom_checkbox6 AS custom_checkbox6_116, 
  t50.custom_checkbox7 AS custom_checkbox7_117, 
  t50.custom_checkbox8 AS custom_checkbox8_118, 
  t50.custom_checkbox9 AS custom_checkbox9_119, 
  t50.custom_dropdown0 AS custom_dropdown0_120, 
  t50.custom_dropdown1 AS custom_dropdown1_121, 
  t50.custom_dropdown2 AS custom_dropdown2_122, 
  t50.custom_dropdown3 AS custom_dropdown3_123, 
  t50.custom_dropdown4 AS custom_dropdown4_124, 
  t50.custom_dropdown5 AS custom_dropdown5_125, 
  t50.custom_dropdown6 AS custom_dropdown6_126, 
  t50.custom_dropdown7 AS custom_dropdown7_127, 
  t50.custom_dropdown8 AS custom_dropdown8_128, 
  t50.custom_dropdown9 AS custom_dropdown9_129, 
  t50.custom_text0 AS custom_text0_130, 
  t50.custom_text1 AS custom_text1_131, 
  t50.custom_text2 AS custom_text2_132, 
  t50.custom_text3 AS custom_text3_133, 
  t50.custom_text4 AS custom_text4_134, 
  t50.custom_text5 AS custom_text5_135, 
  t50.custom_text6 AS custom_text6_136, 
  t50.custom_text7 AS custom_text7_137, 
  t50.custom_text8 AS custom_text8_138, 
  t50.custom_text9 AS custom_text9_139, 
  t50.custom_short_desc0 AS custom_short_desc0_140, 
  t50.custom_short_desc1 AS custom_short_desc1_141, 
  t50.custom_short_desc2 AS custom_short_desc2_142, 
  t50.custom_short_desc3 AS custom_short_desc3_143, 
  t50.custom_short_desc4 AS custom_short_desc4_144, 
  t50.custom_short_desc5 AS custom_short_desc5_145, 
  t50.custom_short_desc6 AS custom_short_desc6_146, 
  t50.custom_short_desc7 AS custom_short_desc7_147, 
  t50.custom_short_desc8 AS custom_short_desc8_148, 
  t50.custom_short_desc9 AS custom_short_desc9_149, 
  t50.custom_long_desc0 AS custom_long_desc0_150, 
  t50.custom_long_desc1 AS custom_long_desc1_151, 
  t50.custom_long_desc2 AS custom_long_desc2_152, 
  t50.custom_long_desc3 AS custom_long_desc3_153, 
  t50.custom_long_desc4 AS custom_long_desc4_154, 
  t50.custom_long_desc5 AS custom_long_desc5_155, 
  t50.custom_long_desc6 AS custom_long_desc6_156, 
  t50.custom_long_desc7 AS custom_long_desc7_157, 
  t50.custom_long_desc8 AS custom_long_desc8_158, 
  t50.custom_long_desc9 AS custom_long_desc9_159, 
  t50.number_views AS number_views_160, 
  t50.avg_review AS avg_review_161, 
  t50.map_zoom AS map_zoom_162, 
  t50.package_id AS package_id_163, 
  t50.package_price AS package_price_164, 
  t50.last_traffic_sent AS last_traffic_sent_165, 
  t50.custom_id AS custom_id_166, 
  t50.parent_no AS parent_no_167, 
  t50.client_keyword AS client_keyword_168, 
  t50.business_keyword AS business_keyword_169, 
  t50.brand_keyword AS brand_keyword_170, 
  t50.product_keyword AS product_keyword_171, 
  t50.authorized_brand AS authorized_brand_172, 
  t50.search_term AS search_term_173, 
  t50.brand_ids AS brand_ids_174, 
  t50.product_ids AS product_ids_175, 
  t50.collected_date AS collected_date_176, 
  t50.msiccode AS msiccode_177, 
  t50.import_id AS import_id_178, 
  t50.listingtemplate_id AS listingtemplate_id_179, 
  t50.level AS level_180, 
  t50.image_id AS image_id_181, 
  t50.account_id AS account_id_182, 
  t50.cover_id AS cover_id_183, 
  t0.image_id AS image_id_184, 
  t185.id AS id_186, 
  t185.type AS type_187, 
  t185.width AS width_188, 
  t185.height AS height_189, 
  t185.prefix AS prefix_190, 
  t185.unsplash AS unsplash_191, 
  t0.cover_id AS cover_id_192, 
  t193.id AS id_194, 
  t193.type AS type_195, 
  t193.width AS width_196, 
  t193.height AS height_197, 
  t193.prefix AS prefix_198, 
  t193.unsplash AS unsplash_199 
FROM 
  Promotion t0 
  LEFT JOIN Listing t50 ON t0.listing_id = t50.id 
  LEFT JOIN Image t185 ON t0.image_id = t185.id 
  LEFT JOIN Image t193 ON t0.cover_id = t193.id 
WHERE 
  t0.listing_id = ?