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 ('3.139.233.121', '3.139.233.*', '3.139.*.*', '3.*.*.*');

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 ('3.139.233.121', '3.139.233.*', '3.139.*.*', '3.*.*.*');

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 = '103';

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 ('3.139.233.121', '3.139.233.*', '3.139.*.*', '3.*.*.*');

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 ('3.139.233.121', '3.139.233.*', '3.139.*.*', '3.*.*.*');

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 ('3.139.233.121', '3.139.233.*', '3.139.*.*', '3.*.*.*');

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 ('3.139.233.121', '3.139.233.*', '3.139.*.*', '3.*.*.*');

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 ('3.139.233.121', '3.139.233.*', '3.139.*.*', '3.*.*.*');

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 
  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', 
    'custom_job_feature'
  )

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', 'custom_job_feature');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO Report_Statistic (
  search_date, module, keyword, category_id, 
  location_1, location_2, location_3, 
  location_4, location_5, search_where
) 
VALUES 
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO Report_Statistic (search_date, module, keyword, category_id, location_1, location_2, location_3, location_4, location_5, search_where) VALUES ('2025-02-02 15:34:57', 'c', ' ', 353, '0', '0', '0', '0', '0', NULL);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO Report_Statistic (
  search_date, module, keyword, category_id, 
  location_1, location_2, location_3, 
  location_4, location_5, search_where
) 
VALUES 
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO Report_Statistic (search_date, module, keyword, category_id, location_1, location_2, location_3, location_4, location_5, search_where) VALUES ('2025-02-02 15:34:57', 'l', ' ', 354, '0', '0', '0', '0', '0', NULL);

"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';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO Report_Statistic (
  search_date, module, keyword, category_id, 
  location_1, location_2, location_3, 
  location_4, location_5, search_where
) 
VALUES 
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO Report_Statistic (search_date, module, keyword, category_id, location_1, location_2, location_3, location_4, location_5, search_where) VALUES ('2025-02-02 15:34:57', 'l', ' ', '0', 1, '0', 15, 103, '0', NULL);

"COMMIT"

"COMMIT";

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', 
    'custom_job_feature'
  )

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', 'custom_job_feature');

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', 
    'custom_job_feature'
  )

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', 'custom_job_feature');

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', 
    'custom_job_feature'
  )

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', 'custom_job_feature');

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', 
    'custom_job_feature'
  )

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', 'custom_job_feature');

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', 
    'custom_job_feature'
  )

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', 'custom_job_feature');

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 = ?

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 = 'Directory Results';

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.active = ? 
ORDER BY 
  t0.value DESC

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.active = 'y' ORDER BY t0.value DESC;

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.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 = 50;

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 = 30;

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 = 10;

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.price AS price_7, 
  t0.price_yearly AS price_yearly_8, 
  t0.active AS active_9, 
  t0.popular AS popular_10, 
  t0.featured AS featured_11, 
  t0.trial AS trial_12, 
  t0.video AS video_13, 
  t0.additional_files AS additional_files_14 
FROM 
  ClassifiedLevel t0 
WHERE 
  t0.active = ? 
ORDER BY 
  t0.value DESC

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.price AS price_7, t0.price_yearly AS price_yearly_8, t0.active AS active_9, t0.popular AS popular_10, t0.featured AS featured_11, t0.trial AS trial_12, t0.video AS video_13, t0.additional_files AS additional_files_14 FROM ClassifiedLevel t0 WHERE t0.active = 'y' ORDER BY t0.value DESC;

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

SELECT t0.id AS id_1, t0.level AS level_2, t0.field AS field_3 FROM ClassifiedLevel_Field t0 WHERE t0.level = 50;

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

SELECT t0.id AS id_1, t0.level AS level_2, t0.field AS field_3 FROM ClassifiedLevel_Field t0 WHERE t0.level = 30;

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

SELECT t0.id AS id_1, t0.level AS level_2, t0.field AS field_3 FROM ClassifiedLevel_Field t0 WHERE t0.level = 10;

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.price AS price_7, 
  t0.price_yearly AS price_yearly_8, 
  t0.active AS active_9, 
  t0.popular AS popular_10, 
  t0.featured AS featured_11, 
  t0.trial AS trial_12 
FROM 
  EventLevel t0 
WHERE 
  t0.active = ? 
ORDER BY 
  t0.value DESC

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.price AS price_7, t0.price_yearly AS price_yearly_8, t0.active AS active_9, t0.popular AS popular_10, t0.featured AS featured_11, t0.trial AS trial_12 FROM EventLevel t0 WHERE t0.active = 'y' ORDER BY t0.value DESC;

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

SELECT t0.id AS id_1, t0.level AS level_2, t0.field AS field_3 FROM EventLevel_Field t0 WHERE t0.level = 50;

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

SELECT t0.id AS id_1, t0.level AS level_2, t0.field AS field_3 FROM EventLevel_Field t0 WHERE t0.level = 30;

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

SELECT t0.id AS id_1, t0.level AS level_2, t0.field AS field_3 FROM EventLevel_Field t0 WHERE t0.level = 10;

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 = '151365' AND t0.date = '2025-02-02' AND t0.report_type = 1 LIMIT 1;

"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 ('151365', 1, 1, '2025-02-02');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO Report_Statistic (
  search_date, module, keyword, category_id, 
  location_1, location_2, location_3, 
  location_4, location_5, search_where
) 
VALUES 
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO Report_Statistic (search_date, module, keyword, category_id, location_1, location_2, location_3, location_4, location_5, search_where) VALUES ('2025-02-02 15:34:57', 'c', ' ', 353, '0', '0', '0', '0', '0', NULL);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO Report_Statistic (
  search_date, module, keyword, category_id, 
  location_1, location_2, location_3, 
  location_4, location_5, search_where
) 
VALUES 
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO Report_Statistic (search_date, module, keyword, category_id, location_1, location_2, location_3, location_4, location_5, search_where) VALUES ('2025-02-02 15:34:57', 'l', ' ', 354, '0', '0', '0', '0', '0', NULL);

"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';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO Report_Statistic (
  search_date, module, keyword, category_id, 
  location_1, location_2, location_3, 
  location_4, location_5, search_where
) 
VALUES 
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO Report_Statistic (search_date, module, keyword, category_id, location_1, location_2, location_3, location_4, location_5, search_where) VALUES ('2025-02-02 15:34:57', 'l', ' ', '0', 1, '0', 15, 103, '0', NULL);

"COMMIT"

"COMMIT";

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', 
    'custom_job_feature'
  )

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', 'custom_job_feature');

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', 
    'custom_job_feature'
  )

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', 'custom_job_feature');

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', 
    'custom_job_feature'
  )

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', 'custom_job_feature');

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', 
    'custom_job_feature'
  )

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', 'custom_job_feature');

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', 
    'custom_job_feature'
  )

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', 'custom_job_feature');

SELECT 
  r0_.id AS id_0, 
  r0_.listing_id AS listing_id_1, 
  r0_.day AS day_2, 
  r0_.total_view AS total_view_3, 
  r0_.site_visit_count AS site_visit_count_4 
FROM 
  Report_ClientCookie_Daily r0_ 
WHERE 
  r0_.listing_id = ? 
  AND DATE(r0_.day) = ?

SELECT r0_.id AS id_0, r0_.listing_id AS listing_id_1, r0_.day AS day_2, r0_.total_view AS total_view_3, r0_.site_visit_count AS site_visit_count_4 FROM Report_ClientCookie_Daily r0_ WHERE r0_.listing_id = NULL AND DATE(r0_.day) = '2025-02-02';

SELECT 
  t0.id AS id_1, 
  t0.listing_id AS listing_id_2, 
  t0.cookie AS cookie_3, 
  t0.created_date AS created_date_4, 
  t0.last_visit_date AS last_visit_date_5, 
  t0.initial_status AS initial_status_6, 
  t0.total_views AS total_views_7, 
  t0.site_visit_count AS site_visit_count_8 
FROM 
  Report_ClientCookie t0 
WHERE 
  t0.listing_id IS NULL 
LIMIT 
  1

SELECT t0.id AS id_1, t0.listing_id AS listing_id_2, t0.cookie AS cookie_3, t0.created_date AS created_date_4, t0.last_visit_date AS last_visit_date_5, t0.initial_status AS initial_status_6, t0.total_views AS total_views_7, t0.site_visit_count AS site_visit_count_8 FROM Report_ClientCookie t0 WHERE t0.listing_id IS NULL LIMIT 1;

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 
  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 
  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

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 = 2 AND t0.theme_id = 1 ORDER BY t0.`order` ASC;

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

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 = 'header' AND (s0_.link IS NOT NULL OR s0_.page_id IS NOT NULL) ORDER BY s0_.`order` ASC;

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', 
    'custom_job_feature'
  )

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', 'custom_job_feature');

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 = ?

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 = 1;

SELECT 
  t0.id AS id_1, 
  t0.title AS title_2 
FROM 
  PageType t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2 FROM PageType t0 WHERE t0.id = 1;

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 = ?

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 = 3;

SELECT 
  t0.id AS id_1, 
  t0.title AS title_2 
FROM 
  PageType t0 
WHERE 
  t0.id = ?