Query Metrics
7
Database Queries
7
Different statements
230.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.35 ms (89.42%) |
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 388629 397766 412332 420605 423823 427543 427940 433066 433993 435411 438401 439022 441850 441852 455002 455253 456795 459065 459985 461217 466365 469597 473316 473825 476527 479426 481019 486139 494552 506003 513894 518348 522088 525944 527712 528561 541678 552370 556171 557665 558592 559005 568932 569440 570833 577688 579215 579227 582197 585452 586707 590176 590184 593276 595459 597258 598216 599230 601081 603800 604362 608800 608945 612255 616442 618839 619965 619974 622167 623234 623303 625325 629195 629552 639845 640432 648183 650098 653801 659452 660435 686457 692130 693656 696291 699867 720547 726734 731346 733742 757353 760210 762817 767982 771770 772909 774468 780191 783446 788079 790126 793449 794964 795142 796339 800554 800903 802947 804876 806473 807419 808685 808858 809605 809705 810619 811950 815080 818090 824606 ] |
||||||||||||||||||||||||||||||
|
14.47 ms (6.27%) |
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 556171 696291 648183 720547 590176 800903 733742 793449 760210 420605 439022 423823 774468 818090 824606 466365 455002 473825 481019 455253 456795 459065 461217 486139 522088 494552 525944 459985 541678 559005 570833 568932 582197 650098 659452 692130 653801 660435 686457 693656 699867 552370 577688 579227 595459 608945 618839 619974 622167 629195 640432 598216 629552 639845 585452 599230 601081 616442 623303 586707 603800 783446 790126 808685 808858 780191 796339 800554 807419 809605 811950 726734 757353 772909 794964 795142 802947 804876 809705 810619 762817 767982 771770 731346 604362 608800 623234 788079 806473 388629 441852 441850 473316 433993 427940 435411 506003 527712 528561 518348 427543 619965 476527 513894 625325 590184 612255 433066 438401 815080 469597 479426 557665 558592 569440 579215 597258 593276 397766 412332 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.11%) |
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 388629 397766 412332 420605 423823 427543 427940 433066 433993 435411 438401 439022 441850 441852 455002 455253 456795 459065 459985 461217 466365 469597 473316 473825 476527 479426 481019 486139 494552 506003 513894 518348 522088 525944 527712 528561 541678 552370 556171 557665 558592 559005 568932 569440 570833 577688 579215 579227 582197 585452 586707 590176 590184 593276 595459 597258 598216 599230 601081 603800 604362 608800 608945 612255 616442 618839 619965 619974 622167 623234 623303 625325 629195 629552 639845 640432 648183 650098 653801 659452 660435 686457 692130 693656 696291 699867 720547 726734 731346 733742 757353 760210 762817 767982 771770 772909 774468 780191 783446 788079 790126 793449 794964 795142 796339 800554 800903 802947 804876 806473 807419 808685 808858 809605 809705 810619 811950 815080 818090 824606 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов hard"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов hard"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov hard"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.67%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.