Query Metrics
7
Database Queries
7
Different statements
137.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
113.09 ms (82.55%) |
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 14232 33260 362615 382898 382958 397973 397988 401809 402518 404130 407562 417081 419998 420473 423956 424236 427759 432461 432631 445973 453194 456685 457295 460194 465031 465700 472553 483497 483587 489347 495321 497414 508802 509149 517407 519766 521845 532814 534559 540021 544075 560292 562736 566242 584504 587081 589238 591162 595129 595214 597111 602894 604480 606725 606901 608083 620487 627168 636489 641806 643827 650236 687192 700468 704184 704185 712788 717651 720176 721564 725041 726165 728225 728738 732745 733566 735678 738926 742364 745111 746846 754162 754321 761116 762899 764097 765846 768692 770544 775202 777011 783053 783341 784740 785857 787402 787641 787722 789790 796629 796871 797051 799949 800475 801082 801654 801799 802432 803374 804647 805607 807142 807173 807660 811100 812738 812743 813459 827553 ] |
||||||||||||||||||||||||||||||
|
14.09 ms (10.29%) |
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 777011 787641 801654 805607 754162 783341 785857 787402 801082 801799 807660 811100 728225 746846 725041 742364 754321 764097 728738 761116 604480 608083 784740 423956 362615 424236 517407 33260 407562 532814 606901 509149 397988 827553 721564 687192 717651 733566 14232 397973 650236 606725 636489 641806 800475 720176 460194 664379 802432 456685 472553 712788 420473 495321 483497 401809 432631 427759 432461 417081 453194 457295 483587 489347 540021 497414 519766 521845 534559 544075 560292 700468 704184 704185 562736 566242 584504 595129 595214 587081 591162 643827 597111 589238 602894 627168 775202 796871 807173 812743 789790 796629 799949 803374 804647 807142 762899 787722 813459 732745 745111 735678 738926 765846 768692 770544 726165 620487 783053 797051 812738 382898 404130 419998 445973 465031 465700 508802 382958 402518 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.72%) |
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 14232 33260 362615 382898 382958 397973 397988 401809 402518 404130 407562 417081 419998 420473 423956 424236 427759 432461 432631 445973 453194 456685 457295 460194 465031 465700 472553 483497 483587 489347 495321 497414 508802 509149 517407 519766 521845 532814 534559 540021 544075 560292 562736 566242 584504 587081 589238 591162 595129 595214 597111 602894 604480 606725 606901 608083 620487 627168 636489 641806 643827 650236 687192 700468 704184 704185 712788 717651 720176 721564 725041 726165 728225 728738 732745 733566 735678 738926 742364 745111 746846 754162 754321 761116 762899 764097 765846 768692 770544 775202 777011 783053 783341 784740 785857 787402 787641 787722 789790 796629 796871 797051 799949 800475 801082 801654 801799 802432 803374 804647 805607 807142 807173 807660 811100 812738 812743 813459 827553 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black and wife"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black жен"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black жен"
]
|
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.