Query Metrics
7
Database Queries
7
Different statements
151.38 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.45 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.47 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass booty anal"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.10 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 631919 538416 503119 540498 685389 465256 519309 619109 530039 468282 591668 517074 495795 390360 385755 524687 492120 463837 530836 484710 480432 533556 539292 481584 433248 448954 473500 583923 385062 460024 533848 406350 397401 619592 433301 426592 493159 526494 487726 407019 815002 503127 698124 459513 519497 566312 473391 463280 427543 545383 396015 507785 475275 526951 498611 448289 629359 397855 587167 439257 453349 419468 811826 809508 483569 438768 447068 406933 538567 427950 518996 404629 554774 742926 596862 604517 527908 450274 425903 545834 487703 ] |
||||||||||||||||||||||||||||||
| 4 | 3.05 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 385062 385755 390360 396015 397401 397855 404629 406350 406933 407019 419468 425903 426592 427543 427950 433248 433301 438768 439257 447068 448289 448954 450274 453349 459513 460024 463280 463837 465256 468282 473391 473500 475275 480432 481584 483569 484710 487703 487726 492120 493159 495795 498611 503119 503127 507785 517074 518996 519309 519497 524687 526494 526951 527908 530039 530836 533556 533848 538416 538567 539292 540498 545383 545834 554774 566312 583923 587167 591668 596862 604517 619109 619592 629359 631919 685389 698124 742926 809508 811826 815002 ] |
||||||||||||||||||||||||||||||
| 5 | 128.36 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 385062 385755 390360 396015 397401 397855 404629 406350 406933 407019 419468 425903 426592 427543 427950 433248 433301 438768 439257 447068 448289 448954 450274 453349 459513 460024 463280 463837 465256 468282 473391 473500 475275 480432 481584 483569 484710 487703 487726 492120 493159 495795 498611 503119 503127 507785 517074 518996 519309 519497 524687 526494 526951 527908 530039 530836 533556 533848 538416 538567 539292 540498 545383 545834 554774 566312 583923 587167 591668 596862 604517 619109 619592 629359 631919 685389 698124 742926 809508 811826 815002 ] |
||||||||||||||||||||||||||||||
| 6 | 1.60 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп booty анал"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.34 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.