Query Metrics
7
Database Queries
7
Different statements
159.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.27 ms (83.03%) |
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 401857 413044 414342 414357 415905 416635 418102 418122 429844 430425 434293 446529 447668 450889 451264 454802 465606 467872 467878 467888 473066 473963 474539 475508 476055 478055 478775 481142 490380 492762 494181 496809 504781 511372 524198 530623 531194 531272 532739 532779 533371 533376 535644 536292 536340 536580 536608 536752 537654 537659 537663 540291 540944 541846 542583 542588 542912 544796 545608 546987 550124 550633 552272 552699 559453 560925 562282 565246 566035 578258 584460 585951 586821 590908 592970 596226 599861 599875 600071 600290 600295 600352 601517 601585 601600 604824 605306 623205 630297 630522 630869 631249 632697 633768 634556 644962 647340 647895 648841 648859 650316 651136 651647 656913 666016 666988 668663 669012 669030 669058 674927 676097 676107 677801 678161 679029 696450 749693 783939 813187 ] |
||||||||||||||||||||||||||||||
|
18.28 ms (11.48%) |
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 550633 578258 584460 546987 596226 475508 511372 414342 429844 504781 533376 536580 530623 536292 476055 540944 565246 552699 651136 696450 648859 656913 669012 601585 749693 434293 467872 490380 666988 783939 473066 496809 586821 492762 467878 418122 416635 668663 592970 813187 430425 644962 532779 533371 536340 536608 540291 535644 531194 542912 550124 542583 542588 678161 677801 676107 544796 631249 632697 600290 600352 600295 601517 634556 633768 401857 478775 415905 467888 494181 560925 478055 566035 590908 600071 524198 414357 447668 446529 531272 532739 537654 536752 537659 559453 562282 541846 545608 552272 647895 669058 674927 648841 679029 647340 676097 599861 630297 630522 585951 601600 599875 623205 605306 450889 473963 418102 669030 666016 604824 650316 630869 465606 537663 474539 651647 451264 413044 481142 454802 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.60%) |
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 401857 413044 414342 414357 415905 416635 418102 418122 429844 430425 434293 446529 447668 450889 451264 454802 465606 467872 467878 467888 473066 473963 474539 475508 476055 478055 478775 481142 490380 492762 494181 496809 504781 511372 524198 530623 531194 531272 532739 532779 533371 533376 535644 536292 536340 536580 536608 536752 537654 537659 537663 540291 540944 541846 542583 542588 542912 544796 545608 546987 550124 550633 552272 552699 559453 560925 562282 565246 566035 578258 584460 585951 586821 590908 592970 596226 599861 599875 600071 600290 600295 600352 601517 601585 601600 604824 605306 623205 630297 630522 630869 631249 632697 633768 634556 644962 647340 647895 648841 648859 650316 651136 651647 656913 666016 666988 668663 669012 669030 669058 674927 676097 676107 677801 678161 679029 696450 749693 783939 813187 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny huge dildo"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые огромные дилд"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.31 ms (0.82%) |
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.