Query Metrics
7
Database Queries
7
Different statements
161.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.09 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 404000 460857 469496 479324 485343 493994 501322 531937 539626 551221 558570 560182 564660 583564 585157 587982 588483 592149 596944 597903 600874 606176 607354 608545 609107 610001 610422 616604 616839 617617 617625 620566 620938 621979 622527 624099 626579 630345 642996 646052 647119 651979 657735 657737 658555 658869 668085 668099 668133 668331 668944 673908 675930 677265 686321 693236 693273 696198 704673 705111 705139 707604 708533 710094 711358 712582 713921 715800 716972 720235 723819 724027 731361 732584 733041 733176 733651 733671 734037 734330 734401 735654 736252 737361 737856 740173 742235 743196 745974 747368 747637 749172 750314 751925 755352 755780 760241 760551 761634 761883 762369 768227 770982 777327 785229 786578 792479 793461 806741 809976 815917 816001 818753 819895 819902 822219 822646 822981 ] |
||||||||||||||||||||||||||||||
|
17.05 ms (10.55%) |
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 531937 693273 675930 704673 705111 710094 657735 560182 583564 616839 617625 622527 749172 739943 745974 751925 806741 737361 742235 822646 651979 620566 617617 624099 819902 822219 469496 479324 501322 460857 493994 646052 658555 693236 558570 610001 607354 734037 733176 747637 755352 762369 708533 777327 404000 485343 819895 822981 816001 818753 815917 539626 551221 668085 696198 711358 712582 716972 720235 657737 658869 668331 668944 677265 705139 713921 647119 668099 668133 673908 686321 707604 715800 564660 592149 597903 600874 608545 621979 587982 588483 606176 609107 610422 626579 585157 616604 596944 620938 630345 642996 792479 809976 785229 786578 793461 723819 724027 734330 743196 750314 760241 761634 734401 735654 736252 737856 740173 733041 733671 755780 768227 732584 762399 731361 733651 747368 760551 761883 770982 ] |
||||||||||||||||||||||||||||||
|
3.84 ms (2.38%) |
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 404000 460857 469496 479324 485343 493994 501322 531937 539626 551221 558570 560182 564660 583564 585157 587982 588483 592149 596944 597903 600874 606176 607354 608545 609107 610001 610422 616604 616839 617617 617625 620566 620938 621979 622527 624099 626579 630345 642996 646052 647119 651979 657735 657737 658555 658869 668085 668099 668133 668331 668944 673908 675930 677265 686321 693236 693273 696198 704673 705111 705139 707604 708533 710094 711358 712582 713921 715800 716972 720235 723819 724027 731361 732584 733041 733176 733651 733671 734037 734330 734401 735654 736252 737361 737856 740173 742235 743196 745974 747368 747637 749172 750314 751925 755352 755780 760241 760551 761634 761883 762369 768227 770982 777327 785229 786578 792479 793461 806741 809976 815917 816001 818753 819895 819902 822219 822646 822981 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big cock real"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие cock real"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.29 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие cock real"
]
|
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.