Query Metrics
7
Database Queries
7
Different statements
184.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.80 ms (85.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 154491 382670 394574 398376 403896 410694 412721 414253 416175 416707 421993 437723 439392 444531 444967 447158 449970 468670 471130 474596 493861 494293 496714 505093 511407 511858 512852 513830 514083 514117 515423 516676 522174 522639 524215 524964 529634 531347 531834 532639 536551 540868 556139 569610 573283 584031 592773 593039 595213 595591 600887 608664 620486 625462 626044 628105 628106 629379 635722 639065 639850 642013 642134 647530 647549 648931 655242 659234 661582 662046 662550 671450 675163 686335 696595 697466 697876 701313 704100 709150 709865 710068 712097 713500 713734 722394 735931 736037 739119 740926 743164 744688 744980 748525 751004 751491 752648 759335 773166 779294 782861 785075 788652 789181 791332 796692 796939 798593 803608 804638 804639 806139 806828 807110 807642 809660 811714 814671 824256 824351 ] |
||||||||||||||||||||||||||||||
|
16.11 ms (8.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 584031 647530 697466 713500 722394 639850 593039 639065 807110 811714 791332 796692 798593 803608 748525 751491 785075 809660 736037 744980 773166 744688 759335 735931 608664 620486 789181 806139 806828 807642 824351 556139 437723 398376 511858 531347 444967 569610 573283 804638 804639 439392 154491 412721 414253 416175 540868 531834 529634 522639 655242 592773 628105 739119 752648 628106 796939 382670 524215 522174 524964 743164 444531 403896 416707 410694 449970 468670 505093 516676 474596 662046 626044 421993 447158 824256 686335 511407 788652 751004 513830 515423 493861 600887 740926 642013 512852 496714 471130 782861 394574 814671 494293 536551 514083 514117 532639 659234 661582 671450 709150 712097 713734 647549 662550 697876 704100 709865 648931 675163 696595 701313 710068 625462 629379 642134 595591 595213 635722 779294 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.65%) |
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 154491 382670 394574 398376 403896 410694 412721 414253 416175 416707 421993 437723 439392 444531 444967 447158 449970 468670 471130 474596 493861 494293 496714 505093 511407 511858 512852 513830 514083 514117 515423 516676 522174 522639 524215 524964 529634 531347 531834 532639 536551 540868 556139 569610 573283 584031 592773 593039 595213 595591 600887 608664 620486 625462 626044 628105 628106 629379 635722 639065 639850 642013 642134 647530 647549 648931 655242 659234 661582 662046 662550 671450 675163 686335 696595 697466 697876 701313 704100 709150 709865 710068 712097 713500 713734 722394 735931 736037 739119 740926 743164 744688 744980 748525 751004 751491 752648 759335 773166 779294 782861 785075 788652 789181 791332 796692 796939 798593 803608 804638 804639 806139 806828 807110 807642 809660 811714 814671 824256 824351 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo girl solo"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд девушк соло"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.77%) |
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.