Query Metrics
7
Database Queries
7
Different statements
187.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.04 ms (86.10%) |
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 388101 391982 400993 424421 439525 442913 443703 443824 444545 451466 460599 460732 460751 460752 462327 465362 465364 465375 465388 466270 466872 470272 470296 470581 471055 474097 476289 479114 479120 479135 484730 502002 506765 509528 512515 512593 518863 520514 522445 522730 528512 549779 550223 555750 563142 563156 563213 563225 563439 569410 571036 578169 581126 582584 584114 584810 589679 597158 599139 599327 601952 608354 614518 614523 618507 619521 619536 621196 621198 621339 621456 622794 623831 659366 666464 668529 669324 673420 695691 696985 714911 720621 721382 721459 721487 725180 731775 731781 733251 733371 735031 735908 735936 736174 741688 741692 741739 741749 742359 742373 742398 742410 743829 758509 761027 763471 766503 766509 770603 781651 781676 781726 781727 798681 800698 803537 807332 807337 807338 808690 ] |
||||||||||||||||||||||||||||||
|
15.93 ms (8.52%) |
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 584810 563156 569410 578169 582584 584114 550223 555750 563142 563439 669324 673420 695691 721382 714911 721459 659366 666464 668529 696985 720621 721487 563213 571036 589679 599327 599139 601952 608354 621339 622794 619521 621456 614518 618507 619536 621196 623831 781651 781726 781727 798681 807332 807337 725180 733371 735908 758509 763471 766509 770603 803537 731781 736174 766503 731775 735031 741688 741692 741739 742373 742410 743829 733251 735936 741749 742359 742398 761027 614523 621198 781676 800698 807338 808690 391982 443703 451466 444545 479120 388101 443824 476289 462327 465375 502002 509528 512515 518863 528512 506765 522445 512593 522730 484730 424421 466872 474097 470296 479135 520514 581126 563225 549779 597158 460732 460752 470581 460599 460751 465364 470272 479114 400993 439525 442913 465362 465388 466270 471055 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.36%) |
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 388101 391982 400993 424421 439525 442913 443703 443824 444545 451466 460599 460732 460751 460752 462327 465362 465364 465375 465388 466270 466872 470272 470296 470581 471055 474097 476289 479114 479120 479135 484730 502002 506765 509528 512515 512593 518863 520514 522445 522730 528512 549779 550223 555750 563142 563156 563213 563225 563439 569410 571036 578169 581126 582584 584114 584810 589679 597158 599139 599327 601952 608354 614518 614523 618507 619521 619536 621196 621198 621339 621456 622794 623831 659366 666464 668529 669324 673420 695691 696985 714911 720621 721382 721459 721487 725180 731775 731781 733251 733371 735031 735908 735936 736174 741688 741692 741739 741749 742359 742373 742398 742410 743829 758509 761027 763471 766503 766509 770603 781651 781676 781726 781727 798681 800698 803537 807332 807337 807338 808690 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian saggy mature"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск saggy mature"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск saggy mature"
]
|
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.