Query Metrics
10
Database Queries
6
Different statements
2585.99 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.55 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.note AS note_4 FROM options t0
Parameters:
[] |
| 2 | 0.50 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.note AS note_4 FROM options t0
Parameters:
[] |
| 3 | 0.46 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.note AS note_4 FROM options t0
Parameters:
[] |
| 4 | 0.48 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.note AS note_4 FROM options t0
Parameters:
[] |
| 5 | 0.43 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.note AS note_4 FROM options t0
Parameters:
[] |
| 6 | 834.57 ms |
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
Parameters:
[
"3086936a-266d-4b53-a03e-007e90892734"
]
|
| 7 | 1743.89 ms |
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
Parameters:
[
"6984540354015267344"
]
|
| 8 | 0.23 ms |
"START TRANSACTION"
Parameters:
[] |
| 9 | 2.69 ms |
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "6984540354015267344" 2 => null 3 => null 4 => "Ponemah Mills on the Shetucket River" 5 => "cid:6984540354015267344" 6 => 1025531 7 => null 8 => "Apartment building" 9 => "[]" 10 => "https://www.google.com/maps?cid=6984540354015267344&hl=en&gl=US" 11 => "0x89e670d1d5af2f5f:0x60ee127240760a10" 12 => "607 Norwich Ave, Taftville, CT 06380" 13 => null 14 => "ChIJXy-v1dFw5okREAp2QHIS7mA" 15 => "+1860-294-4198" 16 => "https://www.ponemahmills.com/the-lofts-at-ponemah-mills-taftville-ct" 17 => "www.ponemahmills.com" 18 => null 19 => "https://lh3.googleusercontent.com/gps-cs-s/AC9h4nrWO2lSttEygIS1Dsw_fXRfDInXm8FFsOd3nnvcupZzYxY3KDBVcf4JKnScyqFk1FZqTtuEeyKfSLW6cKxqcaKeahb7bMaE_odFKLlFveilUn8R6sZ1XXpo9wJ2Ksyh3t-3GyTn=w408-h306-k-no" 20 => "607 Norwich Ave, Taftville, CT 06380" 21 => "{"available_attributes":{"accessibility":["has_wheelchair_accessible_entrance","has_wheelchair_accessible_parking"]},"unavailable_attributes":null}" 22 => "Max5" 23 => "3.7" 24 => 9 25 => null 26 => "[{"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}}]" 27 => "{"work_hours":{"timetable":null,"current_status":"close"}}" 28 => "41.5710316" 29 => "-72.0474646" 30 => "2025-07-04 17:35:28" ] |
| 10 | 0.18 ms |
"ROLLBACK"
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\System\Inbox | No errors. |
| App\Entity\System\Settings | No errors. |
| App\Entity\Fp\FPTasks | No errors. |
| App\Entity\Fp\FPRankings | No errors. |
| App\Entity\Seo\SEOTasks | No errors. |
| App\Entity\Fp\FPSerps | No errors. |
| App\Entity\Seo\Locations | No errors. |
| App\Entity\System\User | No errors. |
| App\Entity\Seo\GPlaces | No errors. |