Query Metrics
7
Database Queries
7
Different statements
168.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.89 ms (84.96%) |
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 31329 123769 233889 312264 383400 388766 391287 391703 393705 398484 398559 401921 411769 411777 423971 431643 443184 445633 446012 452350 454177 454227 454559 454560 454561 454563 454565 455121 458000 465698 474629 477717 485679 485698 485755 485763 485766 493020 496315 503974 505963 506075 513581 513583 517605 525479 530097 531532 531547 531914 536585 537839 543446 544669 544859 545414 550220 611530 644905 661536 663873 664285 664305 664798 664810 664848 665038 665110 665124 665210 665236 665260 665273 665384 665455 665461 665840 666778 666834 667279 668886 669457 669781 698113 705355 705705 706625 733148 733587 734572 743767 745952 747062 747151 754970 757543 758280 772107 772123 772124 775436 781812 781833 781914 781922 781967 794828 798640 799989 805868 808057 815369 818446 819271 821761 824331 824354 825241 826781 826910 ] |
||||||||||||||||||||||||||||||
|
15.17 ms (9.02%) |
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 745952 485763 544859 543446 754970 485755 485766 781967 826781 705355 411769 734572 454561 664305 665210 818446 123769 758280 808057 819271 517605 665260 733587 747062 668886 781922 398484 411777 665461 391703 312264 664848 665455 666778 531914 388766 391287 454560 669457 233889 550220 454177 458000 454559 805868 454565 644905 530097 665038 667279 781833 743767 665384 772107 505963 664798 781914 826910 452350 757543 544669 493020 531547 531532 31329 664810 664285 705705 698113 393705 781812 401921 454563 465698 824354 821761 815369 824331 706625 794828 733148 443184 477717 798640 536585 537839 669781 665236 506075 665273 423971 431643 485679 496315 503974 799989 485698 513583 513581 772123 747151 825241 661536 775436 446012 611530 665840 666834 663873 665124 772124 455121 665110 474629 398559 445633 383400 454227 545414 525479 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.67%) |
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 31329 123769 233889 312264 383400 388766 391287 391703 393705 398484 398559 401921 411769 411777 423971 431643 443184 445633 446012 452350 454177 454227 454559 454560 454561 454563 454565 455121 458000 465698 474629 477717 485679 485698 485755 485763 485766 493020 496315 503974 505963 506075 513581 513583 517605 525479 530097 531532 531547 531914 536585 537839 543446 544669 544859 545414 550220 611530 644905 661536 663873 664285 664305 664798 664810 664848 665038 665110 665124 665210 665236 665260 665273 665384 665455 665461 665840 666778 666834 667279 668886 669457 669781 698113 705355 705705 706625 733148 733587 734572 743767 745952 747062 747151 754970 757543 758280 772107 772123 772124 775436 781812 781833 781914 781922 781967 794828 798640 799989 805868 808057 815369 818446 819271 821761 824331 824354 825241 826781 826910 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbw mature blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbw mature минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbw mature минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.