Query Metrics
7
Database Queries
7
Different statements
153.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.45 ms (84.21%) |
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 3671 4463 6739 7169 38890 96341 187636 187759 187917 187964 197736 234584 314552 319863 358507 358566 386142 388968 391512 393105 394773 395137 395719 397361 397439 397937 398229 398348 400684 400813 400839 401229 404185 404777 407867 419518 430989 432723 454313 465446 468120 473194 473740 476180 477515 477596 478039 478510 478963 480305 480470 480760 483147 486349 504336 506501 519573 522020 522364 531789 537614 542217 542604 545179 547029 554852 555065 555100 555123 555138 568477 600314 600444 610473 618861 620219 620220 620252 620260 620266 620268 655153 689358 690144 693356 695188 708817 718746 720714 726372 726875 730759 732243 735027 735442 741067 749109 750554 755953 763510 766777 770331 770911 770925 775989 781326 785121 787298 797178 801277 803457 806180 807971 811488 812715 813597 813731 815053 815118 819508 ] |
||||||||||||||||||||||||||||||
|
14.41 ms (9.37%) |
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 6739 690144 600444 763510 787298 234584 319863 478039 732243 519573 187964 187759 555123 478963 693356 394773 404777 38890 400839 531789 465446 555065 620220 726875 775989 454313 386142 395137 480305 401229 815053 811488 314552 397361 504336 620268 620266 400813 486349 397439 813597 477515 708817 620260 735027 741067 797178 803457 806180 397937 7169 815118 620219 755953 770925 726372 735442 749109 770331 395719 4463 480470 480760 478510 522364 555100 407867 468120 473194 473740 689358 483147 187636 391512 545179 766777 398348 506501 568477 542217 555138 618861 620252 419518 393105 432723 801277 522020 187917 3671 600314 770911 720714 476180 655153 750554 404185 388968 358566 398229 813731 819508 537614 547029 554852 695188 718746 807971 781326 730759 785121 812715 610473 96341 400684 430989 542604 477596 197736 358507 ] |
||||||||||||||||||||||||||||||
|
3.26 ms (2.12%) |
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 3671 4463 6739 7169 38890 96341 187636 187759 187917 187964 197736 234584 314552 319863 358507 358566 386142 388968 391512 393105 394773 395137 395719 397361 397439 397937 398229 398348 400684 400813 400839 401229 404185 404777 407867 419518 430989 432723 454313 465446 468120 473194 473740 476180 477515 477596 478039 478510 478963 480305 480470 480760 483147 486349 504336 506501 519573 522020 522364 531789 537614 542217 542604 545179 547029 554852 555065 555100 555123 555138 568477 600314 600444 610473 618861 620219 620220 620252 620260 620266 620268 655153 689358 690144 693356 695188 708817 718746 720714 726372 726875 730759 732243 735027 735442 741067 749109 750554 755953 763510 766777 770331 770911 770925 775989 781326 785121 787298 797178 801277 803457 806180 807971 811488 812715 813597 813731 815053 815118 819508 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature blonde anal"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature беловолосая анал"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature беловолосая анал"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.