Query Metrics
206
Database Queries
5
Different statements
306.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.01 ms (57.47%) |
1 |
SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM product_url p0_ ORDER BY p0_.id DESC LIMIT 200 OFFSET 7600
Parameters:
[]
|
||||||||||||||||||||||||||||||||
|
101.24 ms (33.06%) |
200 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.lab_report_url AS lab_report_url_3, t0.results AS results_4, t0.product_page_url AS product_page_url_5, t0.additional_data AS additional_data_6, t0.state AS state_7, t0.expiry_date AS expiry_date_8, t0.extraction_date AS extraction_date_9, t0.thca_percentage AS thca_percentage_10, t0.total_thc_percentage AS total_thc_percentage_11, t0.delta_nine_percentage AS delta_nine_percentage_12, t0.delta_nine_with_thca_combined AS delta_nine_with_thca_combined_13, t0.comments AS comments_14, t0.debug_data AS debug_data_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.product_page_id AS product_page_id_18, t0.project_id AS project_id_19, t0.product_url_id AS product_url_id_20 FROM product t0 WHERE t0.product_url_id = ?
Parameters:
[
4319
]
|
||||||||||||||||||||||||||||||||
|
24.66 ms (8.05%) |
1 |
SELECT p0_.id AS id_0, p0_.url AS url_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.title AS title_4, p0_.state AS state_5, p0_.source AS source_6, p0_.debug_data AS debug_data_7, p0_.product_type AS product_type_8, p0_.product_page_data AS product_page_data_9, p0_.spider_source_url_id AS spider_source_url_id_10, p0_.project_id AS project_id_11 FROM product_url p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.id DESC
Parameters:
[ 4319 4318 4317 4316 4315 4314 4313 4312 4311 4310 4309 4308 4307 4306 4305 4304 4303 4302 4301 4300 4299 4298 4297 4296 4295 4294 4293 4292 4291 4290 4289 4288 4287 4286 4285 4284 4283 4282 4281 4280 4279 4278 4277 4276 4275 4274 4273 4272 4271 4270 4269 4268 4267 4266 4265 4264 4263 4262 4261 4260 4259 4258 4257 4256 4255 4254 4253 4252 4251 4250 4249 4248 4247 4246 4245 4244 4243 4242 4241 4240 4239 4238 4237 4236 4235 4234 4233 4232 4231 4230 4229 4228 4227 4226 4225 4224 4223 4222 4221 4220 4219 4218 4217 4216 4215 4214 4213 4212 4211 4210 4209 4208 4207 4206 4205 4204 4203 4202 4201 4200 4199 4198 4197 4196 4195 4194 4193 4192 4191 4190 4189 4188 4187 4186 4185 4184 4183 4182 4181 4180 4179 4178 4177 4176 4175 4174 4173 4172 4171 4170 4169 4168 4167 4166 4165 4164 4163 4162 4161 4160 4159 4158 4157 4156 4155 4154 4153 4152 4151 4150 4149 4148 4147 4146 4145 4144 4143 4142 4141 3749 3748 3747 3746 3745 3744 3743 3742 3741 3740 3739 3738 3731 3730 3729 3728 3727 3726 3725 3724 3723 ]
|
||||||||||||||||||||||||||||||||
|
2.70 ms (0.88%) |
1 |
SELECT count(*) AS sclr_0 FROM product_url p0_
Parameters:
[]
|
||||||||||||||||||||||||||||||||
|
1.68 ms (0.55%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.prompt AS prompt_4, t0.chat_json AS chat_json_5, t0.external_lab_reports_url AS external_lab_reports_url_6, t0.product_matching_url AS product_matching_url_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.spider_source_matching_urls AS spider_source_matching_urls_10, t0.state AS state_11, t0.website_framework AS website_framework_12, t0.debug_data AS debug_data_13, t0.product_exclude_paths AS product_exclude_paths_14, t0.user_id AS user_id_15 FROM project t0 WHERE t0.id = ?
Parameters:
[
3
]
|
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\ProductUrl | No errors. |
| App\Entity\SpiderSourceUrl | No errors. |
| App\Entity\Project | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\AILog | No errors. |
| App\Entity\User | No errors. |
| App\Entity\LabReportSource | No errors. |
| App\Entity\LabReport | No errors. |
| App\Entity\ProductPage | No errors. |
| App\Entity\LabReportFail | No errors. |
| App\Entity\AIBatchJob | No errors. |