Query Metrics
7
Database Queries
7
Different statements
117.92 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.48 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.98 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"oil booty sex"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.08 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 542572 738519 486699 582557 806146 425394 757105 454697 433216 464042 530157 602602 726675 479846 475277 513795 792550 401132 482714 454668 594386 439822 482668 396015 650488 722512 396646 482812 465040 205133 475303 535155 445748 433230 433278 514928 519641 530512 530528 448289 485175 530079 530836 430493 414133 527464 472206 410088 433202 486023 410615 591668 612356 433276 532441 397855 438768 405181 471848 507785 473500 495795 433301 529375 433248 545834 619109 467019 427543 619592 530833 475275 602946 535539 483569 542584 518633 811826 523256 465487 508275 530846 518996 487703 ] |
||||||||||||||||||||||||||||||
| 4 | 2.33 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 205133 396015 396646 397855 401132 405181 410088 410615 414133 425394 427543 430493 433202 433216 433230 433248 433276 433278 433301 438768 439822 445748 448289 454668 454697 464042 465040 465487 467019 471848 472206 473500 475275 475277 475303 479846 482668 482714 482812 483569 485175 486023 486699 487703 495795 507785 508275 513795 514928 518633 518996 519641 523256 527464 529375 530079 530157 530512 530528 530833 530836 530846 532441 535155 535539 542572 542584 545834 582557 591668 594386 602602 602946 612356 619109 619592 650488 722512 726675 738519 757105 792550 806146 811826 ] |
||||||||||||||||||||||||||||||
| 5 | 95.96 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 205133 396015 396646 397855 401132 405181 410088 410615 414133 425394 427543 430493 433202 433216 433230 433248 433276 433278 433301 438768 439822 445748 448289 454668 454697 464042 465040 465487 467019 471848 472206 473500 475275 475277 475303 479846 482668 482714 482812 483569 485175 486023 486699 487703 495795 507785 508275 513795 514928 518633 518996 519641 523256 527464 529375 530079 530157 530512 530528 530833 530836 530846 532441 535155 535539 542572 542584 545834 582557 591668 594386 602602 602946 612356 619109 619592 650488 722512 726675 738519 757105 792550 806146 811826 ] |
||||||||||||||||||||||||||||||
| 6 | 1.58 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"масл booty секс"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.51 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"масл booty секс"
]
|
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.