Query Metrics
7
Database Queries
7
Different statements
145.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.75 ms (82.99%) |
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 502275 519241 519837 522885 532072 537691 537709 537729 540474 541639 541642 541644 541671 541698 541712 541780 541781 541873 542481 542488 542492 543811 543934 544262 544276 544339 547288 547321 547331 547875 548282 548287 549266 549275 549282 549288 549291 549393 549877 549894 549956 549960 550007 550317 550710 551042 551704 551707 551711 552023 554900 556824 560083 560950 561586 561594 562834 562839 563534 563538 563540 566569 566682 566691 566801 570826 570829 570832 571025 571837 572551 572565 572586 572650 573914 574180 574252 574451 576632 576636 576640 576709 577257 577354 579923 579927 581332 582767 583887 586828 586851 586872 586921 587763 590932 600233 603455 623939 626549 632359 649989 668434 668465 670111 672105 681076 686044 698517 699689 702456 702955 703437 704522 706610 712703 744540 789016 815941 817043 818869 ] |
||||||||||||||||||||||||||||||
|
14.15 ms (9.72%) |
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 576640 547875 550710 572565 566801 704522 579927 586851 603455 632359 744540 668465 554900 532072 549291 542481 543811 549894 552023 572586 549877 549266 541780 541642 541644 541712 699689 698517 815941 670111 672105 702456 703437 541698 549275 571837 549393 571025 540474 547321 563538 542488 544276 649989 681076 590932 537729 549956 574252 548282 551704 686044 547288 566569 586872 623939 537691 551042 570832 576636 541781 562839 537709 542492 544262 551711 579923 549288 551707 668434 712703 570826 586921 519241 560083 561594 550317 572551 502275 576709 583887 541873 563540 577354 582767 562834 563534 576632 560950 566691 587763 626549 522885 572650 574451 541671 541639 519837 573914 581332 561586 702955 586828 789016 556824 544339 600233 706610 818869 817043 547331 548287 549282 549960 550007 566682 574180 577257 543934 570829 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.91%) |
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 502275 519241 519837 522885 532072 537691 537709 537729 540474 541639 541642 541644 541671 541698 541712 541780 541781 541873 542481 542488 542492 543811 543934 544262 544276 544339 547288 547321 547331 547875 548282 548287 549266 549275 549282 549288 549291 549393 549877 549894 549956 549960 550007 550317 550710 551042 551704 551707 551711 552023 554900 556824 560083 560950 561586 561594 562834 562839 563534 563538 563540 566569 566682 566691 566801 570826 570829 570832 571025 571837 572551 572565 572586 572650 573914 574180 574252 574451 576632 576636 576640 576709 577257 577354 579923 579927 581332 582767 583887 586828 586851 586872 586921 587763 590932 600233 603455 623939 626549 632359 649989 668434 668465 670111 672105 681076 686044 698517 699689 702456 702955 703437 704522 706610 712703 744540 789016 815941 817043 818869 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother film"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин фильм"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.17%) |
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.