Query Metrics
7
Database Queries
7
Different statements
152.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.47 ms (82.20%) |
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 86684 123273 233707 396101 411619 423766 425654 429788 443142 444206 447867 450143 450894 456196 456495 458152 458561 459144 461487 461829 462798 463123 463769 465739 468470 470660 472466 474377 474824 475534 478235 478777 478805 482426 484332 486045 486537 487568 489381 490879 491141 491290 491709 491962 492315 493218 494933 499581 504747 506023 506369 507348 509050 509056 510007 510472 510796 511197 511886 512089 513948 516089 516178 517885 518351 518859 519775 520500 520617 521492 521906 523005 526129 527794 541537 541891 542050 545199 546600 546697 546946 551687 552908 554366 555910 556312 557109 561350 563453 565327 565354 565863 568965 570307 570363 571298 571486 571934 580723 598811 625582 626472 631615 672777 678878 703554 712122 712639 721068 723432 724102 726694 739675 741082 766908 783562 784571 788799 792581 798018 ] |
||||||||||||||||||||||||||||||
|
16.77 ms (10.99%) |
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 542050 546946 557109 565327 568965 571486 541891 556312 561350 463123 396101 456196 470660 472466 504747 521906 484332 490879 510007 510796 518859 458561 458152 233707 507348 506023 506369 519775 489381 492315 86684 462798 463769 411619 520500 511197 499581 527794 450143 474377 551687 571298 570307 678878 721068 703554 712122 723432 631615 783562 798018 741082 456495 423766 443142 482426 494933 511886 512089 520617 461487 486537 555910 565863 552908 571934 545199 672777 546600 554366 563453 570363 580723 766908 474824 478235 459144 425654 468470 509050 509056 513948 523005 491141 491709 487568 516089 444206 447867 478805 546697 625582 465739 450894 478777 516178 517885 526129 493218 510472 518351 486045 491962 598811 123273 491290 521492 565354 429788 541537 712639 784571 726694 724102 739675 626472 788799 792581 461829 475534 ] |
||||||||||||||||||||||||||||||
|
3.46 ms (2.27%) |
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 86684 123273 233707 396101 411619 423766 425654 429788 443142 444206 447867 450143 450894 456196 456495 458152 458561 459144 461487 461829 462798 463123 463769 465739 468470 470660 472466 474377 474824 475534 478235 478777 478805 482426 484332 486045 486537 487568 489381 490879 491141 491290 491709 491962 492315 493218 494933 499581 504747 506023 506369 507348 509050 509056 510007 510472 510796 511197 511886 512089 513948 516089 516178 517885 518351 518859 519775 520500 520617 521492 521906 523005 526129 527794 541537 541891 542050 545199 546600 546697 546946 551687 552908 554366 555910 556312 557109 561350 563453 565327 565354 565863 568965 570307 570363 571298 571486 571934 580723 598811 625582 626472 631615 672777 678878 703554 712122 712639 721068 723432 724102 726694 739675 741082 766908 783562 784571 788799 792581 798018 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в комнате секс"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в комнат секс"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.99%) |
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.