Query Metrics
7
Database Queries
7
Different statements
171.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.56 ms (85.96%) |
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 29166 122190 145706 197398 203017 280774 368895 381790 382312 383315 385569 390537 395311 400954 401774 401796 401832 411081 411709 413702 420064 429444 429889 432878 432886 453394 454223 464526 465828 470436 475479 488187 498722 504823 515347 525999 530444 534980 536142 537147 538714 538843 542753 542770 544286 551829 561738 566668 577298 578816 583914 584477 588876 588887 590270 592470 592495 593532 593535 598317 598491 601487 602811 603399 613304 626304 629799 635615 636426 660054 663281 663526 663780 664594 670980 672821 679204 680334 698882 708644 712884 714316 716119 716237 716253 718878 719028 722322 723377 724429 724483 734322 738325 748195 753600 754626 760097 760211 761517 770158 776799 776807 777670 780231 781857 781875 785916 786405 790510 792270 795656 800474 802041 805324 808491 808544 810640 810782 814309 828548 ] |
||||||||||||||||||||||||||||||
|
14.50 ms (8.45%) |
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 598317 723377 453394 504823 584477 464526 432886 454223 551829 429444 593535 429889 488187 465828 400954 542753 515347 498722 542770 475479 593532 592495 770158 536142 719028 383315 577298 718878 808544 534980 708644 664594 808491 724429 776799 753600 716119 395311 413702 722322 561738 636426 734322 613304 672821 714316 530444 590270 800474 724483 781857 828548 566668 805324 29166 635615 660054 203017 679204 197398 538714 716237 603399 780231 795656 537147 786405 716253 145706 602811 280774 538843 578816 629799 401796 777670 601487 810782 760211 781875 761517 588887 592470 382312 583914 698882 663281 738325 411709 544286 385569 390537 401832 525999 814309 381790 680334 401774 122190 663780 432878 748195 588876 368895 663526 760097 790510 670980 626304 810640 776807 792270 802041 420064 470436 598491 785916 712884 754626 411081 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (1.94%) |
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 29166 122190 145706 197398 203017 280774 368895 381790 382312 383315 385569 390537 395311 400954 401774 401796 401832 411081 411709 413702 420064 429444 429889 432878 432886 453394 454223 464526 465828 470436 475479 488187 498722 504823 515347 525999 530444 534980 536142 537147 538714 538843 542753 542770 544286 551829 561738 566668 577298 578816 583914 584477 588876 588887 590270 592470 592495 593532 593535 598317 598491 601487 602811 603399 613304 626304 629799 635615 636426 660054 663281 663526 663780 664594 670980 672821 679204 680334 698882 708644 712884 714316 716119 716237 716253 718878 719028 722322 723377 724429 724483 734322 738325 748195 753600 754626 760097 760211 761517 770158 776799 776807 777670 780231 781857 781875 785916 786405 790510 792270 795656 800474 802041 805324 808491 808544 810640 810782 814309 828548 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stockings tits"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.78%) |
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.