Query Metrics
7
Database Queries
7
Different statements
179.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.64 ms (87.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 27777 38313 69969 73926 163368 233346 295616 295700 308583 335196 358200 381811 382378 382884 382979 386103 386297 388482 388848 390387 393734 393747 393783 396165 396734 398805 402588 403045 403049 446376 484126 488311 503926 505524 515110 515118 515198 515227 528353 550436 550662 560384 589579 607167 622376 624464 624851 631901 663919 667858 676525 678726 678802 682511 693624 694540 700662 701488 709591 709639 712804 712830 715097 716069 716161 722659 722676 732422 732426 732457 735480 735516 735814 736403 741445 741484 741639 743034 743039 743123 743147 747832 747852 747858 747861 747875 748214 754895 755780 759572 759596 759642 766020 770202 773578 774155 776732 776878 778602 781987 781992 782399 789228 789233 789270 789806 790954 795077 800249 800881 807938 812132 812148 812150 814722 817404 819963 825258 827117 827204 ] |
||||||||||||||||||||||||||||||
|
11.97 ms (6.66%) |
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 807938 398805 550436 528353 381811 358200 505524 446376 736403 73926 295616 503926 515198 722659 663919 700662 709591 622376 624851 789233 789270 812150 741484 735480 774155 393747 295700 388482 393783 402588 825258 693624 694540 631901 827204 560384 678726 701488 722676 715097 776732 743147 800881 812148 747852 741639 743039 781987 393734 515118 667858 716069 743123 747858 741445 747875 754895 747861 755780 759596 732426 396734 38313 515227 770202 386297 382979 403045 382378 607167 484126 550662 163368 390387 827117 488311 676525 678802 776878 800249 781992 748214 735814 709639 778602 403049 382884 69969 814722 819963 515110 682511 712830 624464 589579 790954 743034 782399 789806 747832 766020 732422 732457 735516 759642 759572 773578 812132 233346 308583 388848 386103 396165 27777 817404 712804 789228 795077 716161 335196 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.48%) |
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 27777 38313 69969 73926 163368 233346 295616 295700 308583 335196 358200 381811 382378 382884 382979 386103 386297 388482 388848 390387 393734 393747 393783 396165 396734 398805 402588 403045 403049 446376 484126 488311 503926 505524 515110 515118 515198 515227 528353 550436 550662 560384 589579 607167 622376 624464 624851 631901 663919 667858 676525 678726 678802 682511 693624 694540 700662 701488 709591 709639 712804 712830 715097 716069 716161 722659 722676 732422 732426 732457 735480 735516 735814 736403 741445 741484 741639 743034 743039 743123 743147 747832 747852 747858 747861 747875 748214 754895 755780 759572 759596 759642 766020 770202 773578 774155 776732 776878 778602 781987 781992 782399 789228 789233 789270 789806 790954 795077 800249 800881 807938 812132 812148 812150 814722 817404 819963 825258 827117 827204 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"grandpa секс"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"grandpa fuck"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"grandpa секс"
]
|
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.