Query Metrics
7
Database Queries
7
Different statements
151.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.80 ms (83.72%) |
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 371202 413594 418828 432422 432437 432455 432476 432484 433033 433322 433715 434216 437551 445671 452408 453352 462265 492067 509399 511822 513729 529662 542183 543188 554637 557681 565250 566238 573986 580856 583925 594511 597543 597566 604170 604566 606515 627863 629443 630444 631224 633064 636508 637122 640742 647108 648192 652596 653228 653357 654411 656209 659546 661255 664808 668973 672725 675001 687490 688835 690315 691994 695631 696568 697328 698735 702432 703506 703535 703926 709533 710799 714178 714816 715225 725971 735516 736272 737018 741111 741860 742139 744544 745037 754243 759079 760828 762659 763054 765745 776017 777548 777696 777848 783088 786602 788072 790920 790973 796430 797286 800161 801987 802875 805673 807537 809235 811759 813599 814570 817283 817692 817719 818270 818395 819607 820075 821549 822155 825829 ] |
||||||||||||||||||||||||||||||
|
14.18 ms (9.36%) |
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 814570 825829 817692 542183 672725 653357 714178 776017 790920 777696 777848 783088 788072 790973 796430 801987 805673 741111 741860 736272 759079 765745 777548 786602 797286 800161 807537 809235 434216 371202 432455 432476 433715 432422 433322 513729 817719 822155 813599 817283 818270 818395 821549 819607 820075 452408 566238 554637 543188 573986 583925 661255 664808 691994 695631 696568 703926 710799 648192 652596 653228 656209 659546 668973 687490 688835 697328 698735 702432 647108 654411 715225 633064 604170 627863 636508 594511 629443 630444 631224 737018 802875 811759 742139 762659 754243 763054 725971 606515 703535 714816 462265 675001 445671 509399 529662 690315 703506 557681 604566 597543 744544 745037 735516 760828 413594 418828 565250 453352 492067 511822 640742 597566 637122 437551 433033 580856 709533 432437 432484 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.97%) |
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 371202 413594 418828 432422 432437 432455 432476 432484 433033 433322 433715 434216 437551 445671 452408 453352 462265 492067 509399 511822 513729 529662 542183 543188 554637 557681 565250 566238 573986 580856 583925 594511 597543 597566 604170 604566 606515 627863 629443 630444 631224 633064 636508 637122 640742 647108 648192 652596 653228 653357 654411 656209 659546 661255 664808 668973 672725 675001 687490 688835 690315 691994 695631 696568 697328 698735 702432 703506 703535 703926 709533 710799 714178 714816 715225 725971 735516 736272 737018 741111 741860 742139 744544 745037 754243 759079 760828 762659 763054 765745 776017 777548 777696 777848 783088 786602 788072 790920 790973 796430 797286 800161 801987 802875 805673 807537 809235 811759 813599 814570 817283 817692 817719 818270 818395 819607 820075 821549 822155 825829 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen handjob"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen дрочк член"
]
|
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.