Query Metrics
7
Database Queries
7
Different statements
182.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.45 ms (86.79%) |
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 14105 21221 34342 163135 187443 382295 400951 408894 413929 415126 415610 423732 425359 425506 426522 428356 433380 435326 442336 445641 445881 445908 446017 446600 447699 447702 447916 448552 449717 452286 454179 454444 457762 457782 458427 459316 461271 465717 466059 466469 466827 468909 472544 474644 475595 475731 476312 484236 484781 495863 506302 510619 511570 516605 517652 520984 526536 529525 529780 530144 530922 531791 531867 532827 534624 535145 535885 536009 537352 537604 541737 546623 559744 568765 569345 580914 595508 597633 599733 603330 610101 611795 617816 620330 622950 624171 634713 636071 638947 645623 647076 649507 651637 664221 664593 709865 725206 732939 738043 739174 748593 749883 749929 750828 763545 771205 777997 785263 794223 798131 802597 806944 806966 807048 807134 808499 808810 809284 810471 814970 ] |
||||||||||||||||||||||||||||||
|
14.31 ms (7.84%) |
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 664593 415126 415610 445908 457782 510619 423732 428356 461271 442336 382295 400951 580914 516605 725206 454444 458427 466059 546623 433380 474644 454179 472544 459316 448552 526536 475595 446600 449717 447916 435326 452286 620330 457762 445881 520984 413929 624171 445641 517652 21221 531867 651637 426522 569345 664221 808499 810471 806944 532827 806966 777997 732939 749883 645623 595508 748593 802597 534624 763545 709865 495863 537604 807134 530922 798131 163135 14105 447699 750828 529525 739174 476312 617816 465717 771205 638947 636071 187443 749929 425506 785263 506302 535145 597633 611795 808810 511570 634713 814970 536009 647076 807048 809284 408894 559744 425359 794223 537352 603330 34342 529780 568765 541737 622950 475731 535885 484236 738043 530144 531791 468909 649507 599733 610101 484781 447702 446017 466827 466469 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.64%) |
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 14105 21221 34342 163135 187443 382295 400951 408894 413929 415126 415610 423732 425359 425506 426522 428356 433380 435326 442336 445641 445881 445908 446017 446600 447699 447702 447916 448552 449717 452286 454179 454444 457762 457782 458427 459316 461271 465717 466059 466469 466827 468909 472544 474644 475595 475731 476312 484236 484781 495863 506302 510619 511570 516605 517652 520984 526536 529525 529780 530144 530922 531791 531867 532827 534624 535145 535885 536009 537352 537604 541737 546623 559744 568765 569345 580914 595508 597633 599733 603330 610101 611795 617816 620330 622950 624171 634713 636071 638947 645623 647076 649507 651637 664221 664593 709865 725206 732939 738043 739174 748593 749883 749929 750828 763545 771205 777997 785263 794223 798131 802597 806944 806966 807048 807134 808499 808810 809284 810471 814970 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"трясет сиськи"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трясет сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.85%) |
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.