Query Metrics
7
Database Queries
7
Different statements
214.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
189.29 ms (88.12%) |
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 81641 233610 381875 382699 384137 385342 386620 387012 391277 391911 396428 397086 397878 398830 407407 411930 417823 426298 428819 434789 446524 448671 449699 449721 449761 451719 455128 455974 461471 461773 467039 469532 470463 470570 470583 472279 472336 472853 474953 477936 478458 478976 484789 484938 490574 490590 497492 502029 504536 512046 513677 516082 529136 530401 531028 531533 532339 535395 536346 538208 541335 544276 544506 550650 553216 560673 562388 563168 565989 570016 570225 572355 577013 577343 580113 584312 617807 630052 655406 659637 663216 663353 663934 666834 667513 667851 671172 678308 679692 690853 692564 694464 695708 696009 696977 700697 703086 707175 708029 708774 710481 711575 711582 713169 714109 714324 714644 716317 716674 718920 721916 777668 782413 782417 794009 802771 817070 821147 822264 826018 ] |
||||||||||||||||||||||||||||||
|
16.02 ms (7.46%) |
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 617807 630052 710481 711575 711582 721916 777668 782413 782417 794009 802771 233610 382699 396428 477936 397878 398830 448671 461471 81641 397086 449699 461773 470463 538208 490590 391911 417823 449761 470583 467039 497492 580113 714109 434789 391277 411930 428819 455974 469532 478458 449721 472336 474953 504536 513677 502029 386620 385342 384137 381875 387012 426298 407407 817070 826018 822264 821147 451719 470570 455128 490574 446524 484938 512046 516082 530401 532339 529136 531028 531533 536346 535395 472279 472853 478976 484789 544506 553216 560673 563168 570225 572355 577343 541335 550650 562388 565989 577013 544276 570016 584312 666834 667851 679692 695708 696009 703086 714644 716674 718920 659637 663216 663353 663934 667513 678308 694464 696977 700697 716317 655406 671172 690853 692564 707175 708029 708774 713169 714324 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.02%) |
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 81641 233610 381875 382699 384137 385342 386620 387012 391277 391911 396428 397086 397878 398830 407407 411930 417823 426298 428819 434789 446524 448671 449699 449721 449761 451719 455128 455974 461471 461773 467039 469532 470463 470570 470583 472279 472336 472853 474953 477936 478458 478976 484789 484938 490574 490590 497492 502029 504536 512046 513677 516082 529136 530401 531028 531533 532339 535395 536346 538208 541335 544276 544506 550650 553216 560673 562388 563168 565989 570016 570225 572355 577013 577343 580113 584312 617807 630052 655406 659637 663216 663353 663934 666834 667513 667851 671172 678308 679692 690853 692564 694464 695708 696009 696977 700697 703086 707175 708029 708774 710481 711575 711582 713169 714109 714324 714644 716317 716674 718920 721916 777668 782413 782417 794009 802771 817070 821147 822264 826018 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая short"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette short"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"черноволосая short"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.72%) |
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.