Query Metrics
7
Database Queries
7
Different statements
163.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.95 ms (86.09%) |
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 382844 384498 388118 390197 390284 408581 512186 529611 532661 532662 532975 544781 549424 572946 576983 587753 606828 608054 609891 612656 621468 626667 631350 632284 637483 644358 648983 652262 652841 657178 658360 659608 661397 671099 683242 690424 696065 696472 696526 706508 709495 712597 713414 718895 722854 729992 730672 733108 736003 736939 739879 740408 740741 742467 742540 745247 748694 748970 748983 749525 749532 751961 754197 757077 760340 762359 762472 763189 764081 764296 766090 766314 766451 766785 767775 768187 771193 773650 774623 778822 780302 781070 781364 781630 783637 783853 784695 786070 786758 787015 788261 790669 790762 791669 792218 792433 792520 795168 795500 796242 798281 798391 799078 799612 801566 801664 806313 810958 812421 812456 814098 819914 821293 823022 823430 827510 ] |
||||||||||||||||||||||||||||||
|
12.64 ms (7.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 652262 788261 766090 767775 781364 798391 819914 696472 390197 388118 821293 786070 781630 799612 733108 751961 762359 762472 764296 768187 631350 774623 781070 792520 806313 549424 671099 648983 696526 612656 796242 749525 749532 766451 783853 787015 792218 792433 801566 730672 748694 754197 742540 773650 712597 812421 532975 382844 576983 657178 706508 722854 718895 626667 637483 606828 795168 795500 736003 740741 764081 742467 748970 757077 766314 766785 771193 632284 709495 783637 384498 390284 408581 532662 532661 823022 814098 823430 827510 512186 529611 572946 683242 696065 659608 690424 652841 658360 661397 544781 609891 621468 587753 597175 644358 781201 778822 780302 791669 801664 810958 812456 760340 767576 784695 790669 736939 729992 740408 745247 748983 763189 771135 739879 608054 713414 786758 790762 798281 799078 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.86%) |
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 382844 384498 388118 390197 390284 408581 512186 529611 532661 532662 532975 544781 549424 572946 576983 587753 606828 608054 609891 612656 621468 626667 631350 632284 637483 644358 648983 652262 652841 657178 658360 659608 661397 671099 683242 690424 696065 696472 696526 706508 709495 712597 713414 718895 722854 729992 730672 733108 736003 736939 739879 740408 740741 742467 742540 745247 748694 748970 748983 749525 749532 751961 754197 757077 760340 762359 762472 763189 764081 764296 766090 766314 766451 766785 767775 768187 771193 773650 774623 778822 780302 781070 781364 781630 783637 783853 784695 786070 786758 787015 788261 790669 790762 791669 792218 792433 792520 795168 795500 796242 798281 798391 799078 799612 801566 801664 806313 810958 812421 812456 814098 819914 821293 823022 823430 827510 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sweet sex"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"милая секс"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.94%) |
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.