Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.cid AS cid_2,
  t0.yid AS yid_3,
  t0.bizid AS bizid_4,
  t0.title AS title_5,
  t0.keyword AS keyword_6,
  t0.location AS location_7,
  t0.description AS description_8,
  t0.primarycat AS primarycat_9,
  t0.addcats AS addcats_10,
  t0.check_url AS check_url_11,
  t0.feature_id AS feature_id_12,
  t0.address AS address_13,
  t0.address_all AS address_all_14,
  t0.place_id AS place_id_15,
  t0.phone AS phone_16,
  t0.url AS url_17,
  t0.domain AS domain_18,
  t0.logo AS logo_19,
  t0.main_image AS main_image_20,
  t0.snippet AS snippet_21,
  t0.attributes AS attributes_22,
  t0.rating_type AS rating_type_23,
  t0.rating_value AS rating_value_24,
  t0.votes_count AS votes_count_25,
  t0.rating_max AS rating_max_26,
  t0.competitors AS competitors_27,
  t0.worktime AS worktime_28,
  t0.lat AS lat_29,
  t0.lng AS lng_30,
  t0.modified AS modified_31
FROM
  gplaces t0
WHERE
  t0.cid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cid AS cid_2, t0.yid AS yid_3, t0.bizid AS bizid_4, t0.title AS title_5, t0.keyword AS keyword_6, t0.location AS location_7, t0.description AS description_8, t0.primarycat AS primarycat_9, t0.addcats AS addcats_10, t0.check_url AS check_url_11, t0.feature_id AS feature_id_12, t0.address AS address_13, t0.address_all AS address_all_14, t0.place_id AS place_id_15, t0.phone AS phone_16, t0.url AS url_17, t0.domain AS domain_18, t0.logo AS logo_19, t0.main_image AS main_image_20, t0.snippet AS snippet_21, t0.attributes AS attributes_22, t0.rating_type AS rating_type_23, t0.rating_value AS rating_value_24, t0.votes_count AS votes_count_25, t0.rating_max AS rating_max_26, t0.competitors AS competitors_27, t0.worktime AS worktime_28, t0.lat AS lat_29, t0.lng AS lng_30, t0.modified AS modified_31 FROM gplaces t0 WHERE t0.cid = '6984540354015267344' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.purpose AS purpose_2,
  t0.task_id AS task_id_3,
  t0.d4id AS d4id_4,
  t0.api AS api_5,
  t0.function AS function_6,
  t0.se AS se_7,
  t0.language_code AS language_code_8,
  t0.location_code AS location_code_9,
  t0.keyword AS keyword_10,
  t0.se_type AS se_type_11,
  t0.device AS device_12,
  t0.os AS os_13,
  t0.status AS status_14,
  t0.created AS created_15
FROM
  seo_tasks t0
WHERE
  t0.task_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.purpose AS purpose_2, t0.task_id AS task_id_3, t0.d4id AS d4id_4, t0.api AS api_5, t0.function AS function_6, t0.se AS se_7, t0.language_code AS language_code_8, t0.location_code AS location_code_9, t0.keyword AS keyword_10, t0.se_type AS se_type_11, t0.device AS device_12, t0.os AS os_13, t0.status AS status_14, t0.created AS created_15 FROM seo_tasks t0 WHERE t0.task_id = '3086936a-266d-4b53-a03e-007e90892734' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.note AS note_4
FROM
  options t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.note AS note_4 FROM options t0;

INSERT INTO gplaces (
  cid, yid, bizid, title, keyword, location,
  description, primarycat, addcats,
  check_url, feature_id, address, address_all,
  place_id, phone, url, domain, logo,
  main_image, snippet, attributes,
  rating_type, rating_value, votes_count,
  rating_max, competitors, worktime,
  lat, lng, modified
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO gplaces (cid, yid, bizid, title, keyword, location, description, primarycat, addcats, check_url, feature_id, address, address_all, place_id, phone, url, domain, logo, main_image, snippet, attributes, rating_type, rating_value, votes_count, rating_max, competitors, worktime, lat, lng, modified) VALUES ('6984540354015267344', NULL, NULL, 'Ponemah Mills on the Shetucket River', 'cid:6984540354015267344', 1025531, NULL, 'Apartment building', '[]', 'https://www.google.com/maps?cid=6984540354015267344&hl=en&gl=US', '0x89e670d1d5af2f5f:0x60ee127240760a10', '607 Norwich Ave, Taftville, CT 06380', NULL, 'ChIJXy-v1dFw5okREAp2QHIS7mA', '+1860-294-4198', 'https://www.ponemahmills.com/the-lofts-at-ponemah-mills-taftville-ct', 'www.ponemahmills.com', NULL, 'https://lh3.googleusercontent.com/gps-cs-s/AC9h4nrWO2lSttEygIS1Dsw_fXRfDInXm8FFsOd3nnvcupZzYxY3KDBVcf4JKnScyqFk1FZqTtuEeyKfSLW6cKxqcaKeahb7bMaE_odFKLlFveilUn8R6sZ1XXpo9wJ2Ksyh3t-3GyTn=w408-h306-k-no', '607 Norwich Ave, Taftville, CT 06380', '{\"available_attributes\":{\"accessibility\":[\"has_wheelchair_accessible_entrance\",\"has_wheelchair_accessible_parking\"]},\"unavailable_attributes\":null}', 'Max5', '3.7', 9, NULL, '[{\"cid\":\"8369886374393536139\",\"feature_id\":\"0x0:0x7427cf4fdc1bde8b\",\"title\":\"The Mill at Indian Leap\",\"rating\":{\"rating_type\":\"Max5\",\"value\":4.5,\"votes_count\":8,\"rating_max\":null}},{\"cid\":\"16392245257512859146\",\"feature_id\":\"0x0:0xe37cf4363d22b60a\",\"title\":\"Falls Mill Condominiums\",\"rating\":{\"rating_type\":\"Max5\",\"value\":4.29999999999999982236431605997495353221893310546875,\"votes_count\":27,\"rating_max\":null}},{\"cid\":\"17265707603007890759\",\"feature_id\":\"0x0:0xef9c1d96590be547\",\"title\":\"Wequonnoc Village Apartments\",\"rating\":{\"rating_type\":\"Max5\",\"value\":2.5,\"votes_count\":8,\"rating_max\":null}},{\"cid\":\"12334713347002946799\",\"feature_id\":\"0x0:0xab2db46fde6154ef\",\"title\":\"The Hills At Riverview\",\"rating\":{\"rating_type\":\"Max5\",\"value\":2.79999999999999982236431605997495353221893310546875,\"votes_count\":4,\"rating_max\":null}},{\"cid\":\"9094524957101143563\",\"feature_id\":\"0x0:0x7e363e437cf0360b\",\"title\":\"Fourth Avenue Apartments\",\"rating\":{\"rating_type\":\"Max5\",\"value\":null,\"votes_count\":null,\"rating_max\":null}}]', '{\"work_hours\":{\"timetable\":null,\"current_status\":\"close\"}}', '41.5710316', '-72.0474646', '2025-07-03 11:07:44');

"START TRANSACTION"

"START TRANSACTION";

"ROLLBACK"

"ROLLBACK";