Query Metrics
7
Database Queries
7
Different statements
145.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.39 ms (82.73%) |
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 397490 416876 416878 417846 424388 426939 429321 431709 433965 434623 443482 444009 446918 449743 449853 453197 461838 464866 483233 489096 490757 494323 506423 508298 509377 512148 515772 516114 518231 523485 524280 524335 525557 527764 529629 532049 542908 546127 554112 555628 556991 558222 563083 563680 563721 571805 572965 575189 575542 578008 581793 585168 592856 599606 601955 605403 610983 618700 625340 626281 672902 674068 677906 683126 683978 685736 697650 698285 699194 699267 702279 703289 705080 716796 720656 723087 725704 726453 729198 753693 756724 763445 763749 763964 764668 764715 771742 772536 777260 777937 779102 779256 779909 779939 780188 780833 781530 785211 789008 789291 790470 791818 792406 795498 795717 797950 800935 801503 802274 805283 805361 807284 807296 807488 809433 812703 818081 818094 823949 ] |
||||||||||||||||||||||||||||||
|
14.32 ms (9.84%) |
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 771742 779909 791818 801503 397490 444009 446918 449743 506423 489096 542908 578008 555628 575189 581793 556991 416878 508298 509377 417846 818081 818094 823949 525557 527764 674068 683978 699267 672902 716796 585168 599606 618700 625340 805361 766558 756724 601955 720656 779256 785211 790470 529629 698285 490757 512148 809433 431709 494323 429321 524335 523485 554112 563721 683126 685736 697650 702279 563680 592856 626281 777937 780833 789291 805283 779939 797950 800935 807284 792406 807296 807488 763749 726453 729198 763445 764668 772536 763964 779102 812703 434623 433965 516114 563083 723087 753693 464866 558222 424388 443482 518231 575542 449853 453197 515772 532049 546127 572965 571805 699194 705080 677906 605403 610983 780188 795498 777260 795717 725704 781530 764715 703289 789008 802274 416876 426939 461838 483233 524280 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.87%) |
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 397490 416876 416878 417846 424388 426939 429321 431709 433965 434623 443482 444009 446918 449743 449853 453197 461838 464866 483233 489096 490757 494323 506423 508298 509377 512148 515772 516114 518231 523485 524280 524335 525557 527764 529629 532049 542908 546127 554112 555628 556991 558222 563083 563680 563721 571805 572965 575189 575542 578008 581793 585168 592856 599606 601955 605403 610983 618700 625340 626281 672902 674068 677906 683126 683978 685736 697650 698285 699194 699267 702279 703289 705080 716796 720656 723087 725704 726453 729198 753693 756724 763445 763749 763964 764668 764715 771742 772536 777260 777937 779102 779256 779909 779939 780188 780833 781530 785211 789008 789291 790470 791818 792406 795498 795717 797950 800935 801503 802274 805283 805361 807284 807296 807488 809433 812703 818081 818094 823949 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov sleeping"
]
|
||||||||||||||||||||||||||||||
|
2.19 ms (1.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов спящ"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.25%) |
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.