Query Metrics
7
Database Queries
7
Different statements
222.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
199.79 ms (89.82%) |
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 99157 121824 242216 298293 386147 399540 401195 529933 530955 531728 532870 534737 536150 537175 537690 540858 544034 546244 546249 546525 549116 550544 550711 553218 554673 557529 561062 561770 561783 561792 579262 582758 586935 592094 595622 602455 615537 621205 628468 631274 636777 636957 641842 642824 652174 653205 663352 670464 696378 697104 697305 698213 708042 708071 708112 709264 710553 712067 712274 714722 721257 723213 735504 738295 740509 743193 743251 744013 746801 747108 749140 749523 749655 750988 751429 752976 753001 753038 753717 754579 754602 757561 758450 758586 773275 773637 777717 778049 779285 782669 782848 783280 784833 784842 787074 790544 792370 798479 800146 804185 807239 811252 814221 816102 816157 819684 820026 820598 820968 822302 822440 822442 822916 823016 823123 823137 825720 826234 826669 827242 ] |
||||||||||||||||||||||||||||||
|
11.76 ms (5.29%) |
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 800146 746801 752976 753001 753038 754579 758450 773275 773637 749140 749523 735504 744013 750988 757561 740509 697104 784833 784842 804185 811252 298293 99157 386147 121824 401195 822916 826234 816157 820598 816102 825720 536150 537690 530955 534737 557529 579262 546244 714722 697305 712274 652174 698213 592094 641842 779285 787074 778049 782848 792370 743193 749655 758586 754602 738295 743251 747108 751429 753717 708112 709264 798479 807239 399540 242216 814221 822440 822442 823123 540858 819684 820026 827242 820968 822302 823016 823137 826669 532870 537175 529933 531728 544034 550711 554673 550544 553218 670464 721257 653205 663352 710553 696378 708042 708071 712067 723213 546249 546525 549116 561062 561770 561783 561792 582758 595622 628468 602455 615537 621205 636777 636957 642824 586935 631274 777717 782669 783280 790544 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.18%) |
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 99157 121824 242216 298293 386147 399540 401195 529933 530955 531728 532870 534737 536150 537175 537690 540858 544034 546244 546249 546525 549116 550544 550711 553218 554673 557529 561062 561770 561783 561792 579262 582758 586935 592094 595622 602455 615537 621205 628468 631274 636777 636957 641842 642824 652174 653205 663352 670464 696378 697104 697305 698213 708042 708071 708112 709264 710553 712067 712274 714722 721257 723213 735504 738295 740509 743193 743251 744013 746801 747108 749140 749523 749655 750988 751429 752976 753001 753038 753717 754579 754602 757561 758450 758586 773275 773637 777717 778049 779285 782669 782848 783280 784833 784842 787074 790544 792370 798479 800146 804185 807239 811252 814221 816102 816157 819684 820026 820598 820968 822302 822440 822442 822916 823016 823123 823137 825720 826234 826669 827242 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк мастурбац"
]
|
||||||||||||||||||||||||||||||
|
2.27 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.79%) |
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.