Query Metrics
7
Database Queries
7
Different statements
151.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.38 ms (82.77%) |
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 396780 423468 424193 424753 443002 444697 448396 448647 452725 453935 454465 455626 457522 457965 458634 463704 463708 464184 465905 466820 478207 478212 479474 479598 479877 481195 481533 481774 483982 485551 486174 488532 488996 489700 495828 498765 500186 502582 505785 509009 512722 513581 513695 515849 521280 526026 529255 529934 531949 538912 542760 543420 544966 545172 547142 553768 554051 555076 555507 565328 565859 571813 572918 577572 579213 586965 590144 590917 591852 594401 595701 598374 602036 602547 606106 610026 613227 614499 618129 618364 620645 625765 627815 627820 634271 643315 653941 655456 657529 675095 675122 677892 691724 694139 696480 701573 702364 710510 712525 714755 715833 715834 717199 719461 725314 728605 728774 739926 747222 750115 750788 752151 762848 763604 792396 793851 794933 794978 811335 811924 ] |
||||||||||||||||||||||||||||||
|
16.94 ms (11.18%) |
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 547142 486174 565328 579213 554051 701573 586965 594401 598374 610026 620645 614499 618364 728605 794933 725314 750115 750788 443002 478212 481774 515849 488532 483982 457522 526026 545172 572918 752151 489700 502582 505785 465905 577572 691724 702364 793851 481533 529255 529934 538912 512722 555507 544966 653941 571813 590917 715833 448647 479598 481195 509009 485551 513695 423468 458634 488996 553768 712525 714755 675122 595701 606106 613227 627815 618129 634271 747222 763604 625765 463704 719461 396780 444697 455626 452725 521280 464184 542760 677892 694139 715834 717199 591852 602547 643315 627820 762848 728774 811924 424193 479877 495828 500186 792396 655456 457965 454465 498765 531949 513581 479474 675095 565859 590144 794978 811335 739926 448396 453935 463708 478207 602036 543420 424753 466820 710510 696480 657529 555076 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.88%) |
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 396780 423468 424193 424753 443002 444697 448396 448647 452725 453935 454465 455626 457522 457965 458634 463704 463708 464184 465905 466820 478207 478212 479474 479598 479877 481195 481533 481774 483982 485551 486174 488532 488996 489700 495828 498765 500186 502582 505785 509009 512722 513581 513695 515849 521280 526026 529255 529934 531949 538912 542760 543420 544966 545172 547142 553768 554051 555076 555507 565328 565859 571813 572918 577572 579213 586965 590144 590917 591852 594401 595701 598374 602036 602547 606106 610026 613227 614499 618129 618364 620645 625765 627815 627820 634271 643315 653941 655456 657529 675095 675122 677892 691724 694139 696480 701573 702364 710510 712525 714755 715833 715834 717199 719461 725314 728605 728774 739926 747222 750115 750788 752151 762848 763604 792396 793851 794933 794978 811335 811924 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife sucking dick"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен sucking член"
]
|
||||||||||||||||||||||||||||||
|
1.18 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен sucking член"
]
|
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.