Query Metrics
7
Database Queries
7
Different statements
194.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.55 ms (85.18%) |
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 7295 33974 107104 114645 116472 129999 131772 145646 191160 233186 233446 233707 312447 315513 335472 365954 383643 385245 385284 385356 385530 385958 386925 387021 388313 389829 390209 390363 390794 391655 392028 392037 392076 393903 394738 395741 395883 396818 397004 397782 397850 400810 400869 401057 402145 402599 405488 406969 407187 407610 409168 411324 411379 411393 411591 411927 411986 423129 424435 425029 428547 428829 428840 428855 439729 443174 443707 443815 448626 449929 463221 474076 478018 490407 490881 493306 494573 514302 549310 555900 556582 558523 564621 577198 579740 620780 663503 663514 665121 666071 672706 684217 713853 714864 718920 724502 725499 725578 726498 731014 733570 736741 740129 740824 746884 748392 750852 788872 796118 799988 803502 806291 807742 813837 820285 822896 824939 828027 828219 828257 ] |
||||||||||||||||||||||||||||||
|
19.20 ms (9.88%) |
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 395883 439729 406969 411379 478018 514302 490407 579740 663503 663514 665121 389829 385284 385356 129999 116472 145646 131772 393903 315513 335472 390363 396818 397782 411986 428547 425029 463221 448626 449929 714864 796118 383643 387021 392028 395741 402145 424435 428829 443815 400869 233186 428840 233707 390794 411393 411591 428855 443707 443174 493306 385958 385245 107104 114645 191160 394738 392076 312447 386925 390209 402599 405488 407610 409168 423129 407187 813837 555900 564621 556582 718920 672706 684217 713853 620780 788872 799988 725499 733570 806291 724502 731014 740129 740824 736741 725578 750852 726498 746884 748392 803502 807742 33974 385530 411324 233446 401057 397004 365954 388313 392037 400810 494573 490881 558523 391655 7295 397850 474076 411927 822896 820285 824939 828219 828257 828027 577198 549310 666071 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.56%) |
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 7295 33974 107104 114645 116472 129999 131772 145646 191160 233186 233446 233707 312447 315513 335472 365954 383643 385245 385284 385356 385530 385958 386925 387021 388313 389829 390209 390363 390794 391655 392028 392037 392076 393903 394738 395741 395883 396818 397004 397782 397850 400810 400869 401057 402145 402599 405488 406969 407187 407610 409168 411324 411379 411393 411591 411927 411986 423129 424435 425029 428547 428829 428840 428855 439729 443174 443707 443815 448626 449929 463221 474076 478018 490407 490881 493306 494573 514302 549310 555900 556582 558523 564621 577198 579740 620780 663503 663514 665121 666071 672706 684217 713853 714864 718920 724502 725499 725578 726498 731014 733570 736741 740129 740824 746884 748392 750852 788872 796118 799988 803502 806291 807742 813837 820285 822896 824939 828027 828219 828257 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother old"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин old"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.27 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин old"
]
|
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.