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.147.69.90', '3.147.69.*', '3.147.*.*', '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.147.69.90', '3.147.69.*', '3.147.*.*', '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 = '132';

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.147.69.90', '3.147.69.*', '3.147.*.*', '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-01-25 14:13:27', 'l', ' ', 662, '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-01-25 14:13:27', 'c', ' ', 660, '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-01-25 14:13:27', 'l', ' ', '0', 1, '0', 15, 132, '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';