Query Metrics
7
Database Queries
7
Different statements
168.40 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.16 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.10 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"erotic teen anal"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.71 ms |
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id` AND `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id` AND `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 619441 465817 490862 470782 430783 524939 453829 592005 597902 378035 576201 397699 536888 430350 576388 447713 421648 496983 497645 448781 560029 419833 483951 439257 446241 452425 446673 466006 484183 460120 492161 501718 530948 549860 443514 468705 491565 522192 598690 435880 439318 551226 561850 509672 512505 483094 552256 428210 441005 468237 420800 519530 484223 543745 576395 422863 543304 541084 598133 419455 477340 477496 435108 561412 676523 426307 500300 496437 490071 477757 452781 524479 382190 431448 432246 467559 541345 653189 558134 589040 621259 598142 520763 525026 677025 593125 614029 528923 ] |
||||||||||||||||||||||||||||||
| 4 | 2.50 ms |
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 378035 382190 397699 419455 419833 420800 421648 422863 426307 428210 430350 430783 431448 432246 435108 435880 439257 439318 441005 443514 446241 446673 447713 448781 452425 452781 453829 460120 465817 466006 467559 468237 468705 470782 477340 477496 477757 483094 483951 484183 484223 490071 490862 491565 492161 496437 496983 497645 500300 501718 509672 512505 519530 520763 522192 524479 524939 525026 528923 530948 536888 541084 543304 543745 549860 551226 552256 558134 560029 561412 561850 576201 576388 576395 589040 592005 593125 597902 598133 598142 598690 614029 619441 621259 653189 676523 677025 ] |
||||||||||||||||||||||||||||||
| 5 | 141.45 ms |
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id AND f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id` AND `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 378035 382190 397699 419455 419833 420800 421648 422863 426307 428210 430350 430783 431448 432246 435108 435880 439257 439318 441005 443514 446241 446673 447713 448781 452425 452781 453829 460120 465817 466006 467559 468237 468705 470782 477340 477496 477757 483094 483951 484183 484223 490071 490862 491565 492161 496437 496983 497645 500300 501718 509672 512505 519530 520763 522192 524479 524939 525026 528923 530948 536888 541084 543304 543745 549860 551226 552256 558134 560029 561412 561850 576201 576388 576395 589040 592005 593125 597902 598133 598142 598690 614029 619441 621259 653189 676523 677025 ] |
||||||||||||||||||||||||||||||
| 6 | 1.78 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"эротик teen анал"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.69 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"эротик teen анал"
]
|
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
No loaded entities.