Query Metrics
7
Database Queries
7
Different statements
111.06 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.59 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.91 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dick cum compilation"
]
|
||||||||||||||||||||||||||||||
| 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 509331 469274 584692 697892 719144 714779 723287 596714 729270 761573 620597 502755 419147 423581 524311 504384 559564 570717 586600 764490 593596 567046 627117 485147 550898 644124 555866 621482 517836 613171 472588 390447 428105 474114 495253 511011 521761 572681 598871 776153 801292 457769 825174 650813 396526 447944 591181 572924 491213 449761 454263 565281 491353 494312 450343 510108 602647 547658 519169 469530 613576 459382 495038 459122 486643 500566 578411 527142 415109 468928 695181 533348 508371 628332 676428 695127 729223 529720 454037 559062 546350 666850 558886 493163 490063 599545 ] |
||||||||||||||||||||||||||||||
| 4 | 2.20 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 390447 396526 415109 419147 423581 428105 447944 449761 450343 454037 454263 457769 459122 459382 468928 469274 469530 472588 474114 485147 486643 490063 491213 491353 493163 494312 495038 495253 500566 502755 504384 508371 509331 510108 511011 517836 519169 521761 524311 527142 529720 533348 546350 547658 550898 555866 558886 559062 559564 565281 567046 570717 572681 572924 578411 584692 586600 591181 593596 596714 598871 599545 602647 613171 613576 620597 621482 627117 628332 644124 650813 666850 676428 695127 695181 697892 714779 719144 723287 729223 729270 761573 764490 776153 801292 825174 ] |
||||||||||||||||||||||||||||||
| 5 | 88.87 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 390447 396526 415109 419147 423581 428105 447944 449761 450343 454037 454263 457769 459122 459382 468928 469274 469530 472588 474114 485147 486643 490063 491213 491353 493163 494312 495038 495253 500566 502755 504384 508371 509331 510108 511011 517836 519169 521761 524311 527142 529720 533348 546350 547658 550898 555866 558886 559062 559564 565281 567046 570717 572681 572924 578411 584692 586600 591181 593596 596714 598871 599545 602647 613171 613576 620597 621482 627117 628332 644124 650813 666850 676428 695127 695181 697892 714779 719144 723287 729223 729270 761573 764490 776153 801292 825174 ] |
||||||||||||||||||||||||||||||
| 6 | 1.75 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член cum подборк"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.65 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"член cum подборк"
]
|
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.