Query Metrics
7
Database Queries
7
Different statements
165.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.51 ms (85.86%) |
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 52595 80203 213113 382263 382650 386854 387319 392780 393075 395438 397092 400743 403245 414310 415036 418364 426875 427003 427197 433366 433619 436964 437957 440918 441490 444249 444453 444619 451406 472677 476891 477491 483509 486822 490345 492626 493885 496235 509971 537604 542131 549060 549129 549393 587330 589444 590111 595078 595705 601955 609768 609819 615612 615737 619637 621811 631870 635055 636130 637258 638113 647076 647091 655747 659150 669261 678722 684410 684916 691730 692524 698099 699589 705385 705506 713075 714596 720848 722066 725627 726305 731200 732027 733510 734286 736139 739149 751451 761217 762386 767401 768960 770939 771107 771644 771790 775679 780632 781687 784434 785419 786056 787282 787712 788142 788502 789153 789565 791506 792770 793336 793596 794171 795180 795623 801630 802310 802351 804024 811126 ] |
||||||||||||||||||||||||||||||
|
13.15 ms (7.92%) |
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 397092 444249 415036 486822 492626 483509 496235 549129 705506 549393 609768 587330 631870 636130 638113 786056 789565 794171 734286 784434 785419 791506 795180 795623 771790 739149 780632 792770 793596 802310 804024 392780 427003 395438 437957 493885 768960 788502 762386 444453 472677 476891 542131 655747 684916 691730 692524 647076 635055 789153 781687 787712 802351 732027 736139 698099 722066 433366 80203 382650 451406 477491 537604 647091 595705 619637 751451 767401 725627 386854 382263 403245 414310 549060 659150 720848 684410 699589 713075 714596 669261 637258 621811 595078 615737 788142 726305 731200 761217 770939 787282 793336 801630 771644 601955 609819 705385 775679 52595 418364 400743 426875 213113 393075 387319 427197 441490 433619 440918 444619 436964 490345 509971 678722 589444 590111 615612 811126 771107 733510 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.88%) |
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 52595 80203 213113 382263 382650 386854 387319 392780 393075 395438 397092 400743 403245 414310 415036 418364 426875 427003 427197 433366 433619 436964 437957 440918 441490 444249 444453 444619 451406 472677 476891 477491 483509 486822 490345 492626 493885 496235 509971 537604 542131 549060 549129 549393 587330 589444 590111 595078 595705 601955 609768 609819 615612 615737 619637 621811 631870 635055 636130 637258 638113 647076 647091 655747 659150 669261 678722 684410 684916 691730 692524 698099 699589 705385 705506 713075 714596 720848 722066 725627 726305 731200 732027 733510 734286 736139 739149 751451 761217 762386 767401 768960 770939 771107 771644 771790 775679 780632 781687 784434 785419 786056 787282 787712 788142 788502 789153 789565 791506 792770 793336 793596 794171 795180 795623 801630 802310 802351 804024 811126 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"тверд член"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"твёрдый хуй"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.97%) |
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.