Query Metrics
7
Database Queries
7
Different statements
161.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.32 ms (84.27%) |
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 72666 271496 271756 370332 384440 395793 397389 402735 403695 410251 411090 414099 420426 421984 423352 423939 424068 429937 433404 435453 445702 448198 449937 450127 450129 450152 450156 452208 453497 456121 457004 462277 462669 462721 463699 470086 470823 472591 472870 473754 478724 478730 487950 490058 491889 497298 497808 500965 501320 506902 507083 509120 509565 516963 518048 520873 521722 522199 522325 525397 527845 534602 536989 541016 541582 542433 544517 551645 552602 552948 554064 557807 557901 557922 571074 574236 583146 585569 593977 598230 602540 606298 613208 613608 613848 621226 631691 632749 653330 654230 661613 673862 694139 708082 708148 708894 718864 724720 732142 752677 763378 764307 764486 765266 766628 766634 767769 775004 780936 781397 789783 791610 792904 794090 800565 805292 809702 812866 813046 814272 ] |
||||||||||||||||||||||||||||||
|
15.02 ms (9.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 501320 411090 534602 521722 509565 544517 541016 661613 708082 653330 602540 613848 732142 763378 708148 708894 370332 490058 452208 506902 583146 606298 518048 522199 435453 414099 450152 450156 470086 536989 500965 507083 516963 473754 487950 557901 554064 557922 574236 654230 718864 551645 552602 557807 631691 613208 613608 800565 813046 724720 764307 780936 792904 470823 410251 463699 520873 457004 462669 271496 271756 421984 423939 420426 433404 814272 445702 448198 450129 456121 449937 450127 497808 527845 542433 552948 775004 794090 812866 789783 791610 809702 752677 767769 764486 765266 766628 766634 781397 402735 462277 478730 395793 429937 424068 478724 453497 462721 491889 509120 72666 673862 384440 397389 403695 805292 423352 497298 472591 541582 694139 571074 585569 593977 621226 598230 632749 522325 525397 472870 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.84%) |
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 72666 271496 271756 370332 384440 395793 397389 402735 403695 410251 411090 414099 420426 421984 423352 423939 424068 429937 433404 435453 445702 448198 449937 450127 450129 450152 450156 452208 453497 456121 457004 462277 462669 462721 463699 470086 470823 472591 472870 473754 478724 478730 487950 490058 491889 497298 497808 500965 501320 506902 507083 509120 509565 516963 518048 520873 521722 522199 522325 525397 527845 534602 536989 541016 541582 542433 544517 551645 552602 552948 554064 557807 557901 557922 571074 574236 583146 585569 593977 598230 602540 606298 613208 613608 613848 621226 631691 632749 653330 654230 661613 673862 694139 708082 708148 708894 718864 724720 732142 752677 763378 764307 764486 765266 766628 766634 767769 775004 780936 781397 789783 791610 792904 794090 800565 805292 809702 812866 813046 814272 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur swallows"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск swallows"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск swallows"
]
|
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.