Query Metrics
7
Database Queries
7
Different statements
202.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.24 ms (87.46%) |
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 79862 384327 386862 389110 391511 393662 397106 400867 401386 402026 402244 402249 412137 415537 424054 439838 444928 448098 451545 453785 455186 458354 459493 460098 461474 462167 462943 465850 472385 472564 475087 477017 481105 483878 485043 487481 488565 488789 488905 501923 502568 505945 507152 511013 513411 513774 520573 523956 525523 527364 529077 534426 542116 549769 551251 552903 556176 556307 562102 563679 568796 570004 570627 571381 579320 584645 584845 588897 595384 599830 602495 613971 615590 617435 625519 626846 630866 654940 659424 661922 666895 675182 678641 684379 691112 692842 695127 695728 704361 705084 719215 720128 722184 722717 725343 726939 733190 736500 739616 744637 747825 752509 766800 767801 769800 772307 772361 777175 777817 777961 781034 781090 782087 782339 783078 786754 787116 787258 803485 821793 ] |
||||||||||||||||||||||||||||||
|
15.22 ms (7.51%) |
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 782339 477017 507152 782087 461474 412137 684379 719215 661922 626846 781090 787258 733190 767801 777961 659424 384327 766800 570004 584645 617435 704361 691112 602495 787116 726939 772361 451545 424054 595384 654940 739616 722184 551251 502568 501923 402244 720128 692842 402249 722717 534426 475087 615590 529077 458354 523956 481105 568796 678641 520573 821793 599830 781034 747825 415537 549769 625519 695127 389110 562102 695728 584845 393662 459493 588897 563679 769800 513411 488789 571381 439838 744637 402026 570627 391511 613971 462167 472564 579320 803485 472385 483878 513774 525523 488905 448098 401386 777175 397106 675182 772307 736500 777817 786754 453785 666895 465850 386862 552903 79862 752509 462943 485043 505945 460098 455186 444928 487481 705084 783078 725343 630866 511013 400867 527364 556307 488565 542116 556176 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.49%) |
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 79862 384327 386862 389110 391511 393662 397106 400867 401386 402026 402244 402249 412137 415537 424054 439838 444928 448098 451545 453785 455186 458354 459493 460098 461474 462167 462943 465850 472385 472564 475087 477017 481105 483878 485043 487481 488565 488789 488905 501923 502568 505945 507152 511013 513411 513774 520573 523956 525523 527364 529077 534426 542116 549769 551251 552903 556176 556307 562102 563679 568796 570004 570627 571381 579320 584645 584845 588897 595384 599830 602495 613971 615590 617435 625519 626846 630866 654940 659424 661922 666895 675182 678641 684379 691112 692842 695127 695728 704361 705084 719215 720128 722184 722717 725343 726939 733190 736500 739616 744637 747825 752509 766800 767801 769800 772307 772361 777175 777817 777961 781034 781090 782087 782339 783078 786754 787116 787258 803485 821793 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"трахают в рот молодую…"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс в рот молодая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.84%) |
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.