Query Metrics
7
Database Queries
7
Different statements
181.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.23 ms (85.76%) |
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 395624 426823 432503 441427 441496 441577 451007 455382 467833 469495 475541 482894 485039 487188 491588 495129 496510 497615 500152 506696 509773 509933 510725 514150 520337 521019 521179 524118 525458 527711 528616 538521 539475 540724 540729 549477 551601 557380 560461 561013 563294 564300 566129 567523 567828 568512 571772 577887 580491 580519 585930 588568 590807 591936 594760 598885 601218 602430 602874 603910 605928 606668 608273 617706 620812 624079 625018 625924 628497 645369 645663 648762 649094 650280 674954 675890 685051 685131 687408 693246 693278 695873 699197 699444 700941 708237 717490 729836 729905 731060 734794 750498 751725 763850 764136 766453 767213 771043 775148 784015 784110 788007 788144 791025 793944 794818 797072 799775 800003 805254 807271 807464 809979 810157 811405 811774 812774 812912 817733 ] |
||||||||||||||||||||||||||||||
|
14.95 ms (8.26%) |
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 784015 791025 797072 807464 811405 395624 469495 441496 467833 426823 510725 441577 675890 699197 685051 717490 580491 605928 793944 771043 750498 699444 649094 441427 487188 451007 482894 485039 521019 527711 538521 525458 551601 561013 567523 571772 580519 602430 590807 628497 585930 788007 775148 784828 794818 734794 763850 731060 729905 751725 708237 810157 475541 540724 500152 521179 495129 528616 617706 625018 693246 693278 811774 809979 812912 764136 807271 432503 455382 491588 497615 540729 496510 524118 506696 509933 567828 549477 560461 564300 563294 674954 700941 645663 695873 650280 557380 568512 588568 598885 591936 594760 601218 606668 602874 608273 805254 603910 620812 625924 509773 817733 514150 520337 539475 566129 577887 645369 685131 648762 687408 624079 788144 799775 812774 767213 784110 800003 766453 729836 ] |
||||||||||||||||||||||||||||||
|
3.48 ms (1.92%) |
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 395624 426823 432503 441427 441496 441577 451007 455382 467833 469495 475541 482894 485039 487188 491588 495129 496510 497615 500152 506696 509773 509933 510725 514150 520337 521019 521179 524118 525458 527711 528616 538521 539475 540724 540729 549477 551601 557380 560461 561013 563294 564300 566129 567523 567828 568512 571772 577887 580491 580519 585930 588568 590807 591936 594760 598885 601218 602430 602874 603910 605928 606668 608273 617706 620812 624079 625018 625924 628497 645369 645663 648762 649094 650280 674954 675890 685051 685131 687408 693246 693278 695873 699197 699444 700941 708237 717490 729836 729905 731060 734794 750498 751725 763850 764136 766453 767213 771043 775148 784015 784110 788007 788144 791025 793944 794818 797072 799775 800003 805254 807271 807464 809979 810157 811405 811774 812774 812912 817733 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur student"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск student"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск student"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.95%) |
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.