Query Metrics
7
Database Queries
7
Different statements
155.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.86 ms (83.37%) |
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 29374 51420 81658 185642 311097 324827 365903 382770 388453 389806 390111 393473 398674 398922 399094 399563 400903 402729 403417 404954 406350 407600 415697 415983 418740 419120 421275 421466 422319 423646 425065 430210 432266 446152 452621 459496 460215 468527 472743 477734 477907 478786 482028 482814 486008 491194 491220 493469 493934 502066 506217 509765 521753 522381 523326 523978 524845 540729 551366 552194 556807 562295 568575 570319 572590 574520 575161 598163 599935 607900 611522 621872 622733 623811 648754 659512 659656 660923 660930 669609 670949 671700 675455 675812 675817 687982 694123 701452 701466 722154 736610 740762 741270 741808 746328 752990 760406 761797 774635 778226 778761 779120 780217 780225 780719 780805 781630 786136 787653 790369 790925 795691 795708 797235 801901 806014 813159 814105 819050 826903 ] |
||||||||||||||||||||||||||||||
|
15.14 ms (9.72%) |
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 399094 399563 390111 398674 423646 524845 468527 482814 446152 422319 324827 425065 552194 418740 491220 421275 521753 760406 741808 607900 779120 407600 389806 814105 502066 419120 493934 722154 780805 491194 404954 415697 472743 406350 522381 790925 575161 506217 562295 452621 486008 460215 459496 509765 701466 382770 701452 736610 388453 795708 482028 797235 570319 790369 403417 780719 687982 523978 185642 478786 795691 574520 523326 671700 540729 432266 477907 400903 670949 599935 29374 622733 493469 659512 598163 623811 51420 801901 556807 477734 648754 660930 740762 787653 402729 819050 660923 675812 551366 393473 611522 421466 774635 778226 826903 572590 806014 415983 781630 778761 786136 813159 761797 398922 694123 741270 780225 669609 81658 311097 365903 430210 675817 659656 780217 752990 621872 568575 675455 746328 ] |
||||||||||||||||||||||||||||||
|
3.24 ms (2.08%) |
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 29374 51420 81658 185642 311097 324827 365903 382770 388453 389806 390111 393473 398674 398922 399094 399563 400903 402729 403417 404954 406350 407600 415697 415983 418740 419120 421275 421466 422319 423646 425065 430210 432266 446152 452621 459496 460215 468527 472743 477734 477907 478786 482028 482814 486008 491194 491220 493469 493934 502066 506217 509765 521753 522381 523326 523978 524845 540729 551366 552194 556807 562295 568575 570319 572590 574520 575161 598163 599935 607900 611522 621872 622733 623811 648754 659512 659656 660923 660930 669609 670949 671700 675455 675812 675817 687982 694123 701452 701466 722154 736610 740762 741270 741808 746328 752990 760406 761797 774635 778226 778761 779120 780217 780225 780719 780805 781630 786136 787653 790369 790925 795691 795708 797235 801901 806014 813159 814105 819050 826903 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс красивая"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.04%) |
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.