Query Metrics
7
Database Queries
7
Different statements
153.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.53 ms (84.56%) |
1 |
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 93079 194507 343078 373798 384847 386595 393453 393724 395733 395824 398160 400169 402680 405531 406621 422626 426716 435645 435648 445928 464732 478545 482179 487439 488604 501785 508525 511011 514692 516215 517154 517190 530663 533527 534907 536681 540306 541919 542346 543401 543721 543740 544667 544739 546544 548606 548751 548900 551319 552012 552330 556016 556432 559715 560091 563540 567152 567462 567997 569140 570698 574828 576046 576337 581600 584018 584721 586635 587761 590857 592708 593815 596507 596550 596990 606587 607285 622090 622210 633140 636267 640700 641718 641755 644292 650843 651906 652172 653551 664824 664955 665440 667273 670112 675043 675809 679143 691991 714115 716027 723504 742165 742219 748715 750809 754198 773580 788177 801604 802175 811795 814223 817190 818518 818523 819193 820512 821001 823018 825629 ] |
||||||||||||||||||||||||||||||
|
13.30 ms (8.68%) |
1 |
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 665440 667273 675043 714115 551319 592708 811795 754198 773580 343078 435648 750809 534907 801604 445928 590857 541919 422626 517190 542346 567462 556432 546544 548900 636267 536681 548751 464732 405531 514692 487439 596550 548606 567152 393724 488604 530663 508525 543721 748715 406621 650843 426716 563540 570698 556016 606587 633140 596990 640700 395824 384847 93079 817190 819193 543740 587761 596507 723504 386595 395733 814223 516215 482179 544667 552330 559715 567997 576337 664824 821001 517154 584721 544739 622090 802175 742219 398160 373798 400169 435645 511011 543401 574828 569140 652172 670112 716027 644292 586635 402680 501785 823018 818518 478545 560091 552012 581600 653551 675809 651906 679143 691991 584018 622210 641718 641755 607285 788177 742165 576046 664955 593815 194507 393453 820512 825629 818523 540306 533527 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.86%) |
1 |
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 93079 194507 343078 373798 384847 386595 393453 393724 395733 395824 398160 400169 402680 405531 406621 422626 426716 435645 435648 445928 464732 478545 482179 487439 488604 501785 508525 511011 514692 516215 517154 517190 530663 533527 534907 536681 540306 541919 542346 543401 543721 543740 544667 544739 546544 548606 548751 548900 551319 552012 552330 556016 556432 559715 560091 563540 567152 567462 567997 569140 570698 574828 576046 576337 581600 584018 584721 586635 587761 590857 592708 593815 596507 596550 596990 606587 607285 622090 622210 633140 636267 640700 641718 641755 644292 650843 651906 652172 653551 664824 664955 665440 667273 670112 675043 675809 679143 691991 714115 716027 723504 742165 742219 748715 750809 754198 773580 788177 801604 802175 811795 814223 817190 818518 818523 819193 820512 821001 823018 825629 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny threesome"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые секс втро"
]
|
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.