Query Metrics
7
Database Queries
7
Different statements
187.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.14 ms (87.75%) |
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 391075 402982 403268 403979 409727 413730 470600 488604 509228 520162 524121 528571 533680 536957 537542 540967 541082 541108 543950 545019 545067 546679 547991 548752 555686 557949 560368 566413 566431 566442 566447 568187 568192 571308 577209 577215 578552 579304 581427 583688 587216 591165 591170 595923 596550 604679 604698 613864 621371 622343 622822 635842 635853 635855 635874 642525 644538 645064 648943 648952 650797 653174 653328 654268 654291 654652 654680 664521 675208 675241 675934 675971 675986 676402 676836 677460 677544 677609 680587 680588 681719 682914 690012 693596 693772 694032 701638 714084 715583 716017 720916 728742 728946 729214 732257 732743 733076 736055 736778 759766 771453 774943 775893 776276 782036 785405 788084 788596 792488 793555 797402 809636 810053 812429 813018 813044 824804 825202 825894 826105 ] |
||||||||||||||||||||||||||||||
|
13.18 ms (7.05%) |
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 653328 729214 583688 581427 555686 543950 675971 676402 785405 693596 824804 650797 557949 577209 733076 675208 546679 540967 716017 645064 635874 566431 621371 403979 728742 825202 826105 635842 622343 604698 509228 548752 736055 809636 693772 690012 470600 788084 613864 622822 675986 776276 793555 595923 566447 568187 774943 788596 736778 409727 680587 680588 545019 537542 654268 591165 568192 813044 732257 812429 533680 596550 524121 644538 391075 759766 810053 728946 682914 775893 488604 571308 413730 654291 402982 677609 579304 792488 813018 732743 566413 664521 578552 520162 536957 714084 642525 566442 675934 591170 587216 541082 715583 694032 771453 677460 654652 604679 560368 825894 545067 648943 677544 648952 653174 654680 701638 635855 635853 541108 577215 547991 782036 720916 528571 797402 675241 676836 403268 681719 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.37%) |
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 391075 402982 403268 403979 409727 413730 470600 488604 509228 520162 524121 528571 533680 536957 537542 540967 541082 541108 543950 545019 545067 546679 547991 548752 555686 557949 560368 566413 566431 566442 566447 568187 568192 571308 577209 577215 578552 579304 581427 583688 587216 591165 591170 595923 596550 604679 604698 613864 621371 622343 622822 635842 635853 635855 635874 642525 644538 645064 648943 648952 650797 653174 653328 654268 654291 654652 654680 664521 675208 675241 675934 675971 675986 676402 676836 677460 677544 677609 680587 680588 681719 682914 690012 693596 693772 694032 701638 714084 715583 716017 720916 728742 728946 729214 732257 732743 733076 736055 736778 759766 771453 774943 775893 776276 782036 785405 788084 788596 792488 793555 797402 809636 810053 812429 813018 813044 824804 825202 825894 826105 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"threesome amateur"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс втро любительск"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.84%) |
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.