Query Metrics
7
Database Queries
7
Different statements
156.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.92 ms (84.91%) |
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 399263 414374 426368 438772 443323 443660 443796 447426 447810 447926 448882 451893 462305 468652 469766 471691 474686 484668 484737 486183 488734 504481 505132 507591 510396 514820 521866 522911 524986 525393 530935 531182 531203 532245 532645 532655 532676 532680 532703 532755 532954 533369 533563 533837 534372 536538 536582 536584 537675 538815 540398 541634 541690 541886 542864 543731 544838 544843 545444 556046 563866 574258 575810 576696 581349 591620 597199 599833 599861 599912 599922 603285 606821 617437 627806 628371 630869 631163 634778 635171 635215 636320 636985 637121 637729 639334 639759 639796 639798 639818 642018 642066 642706 645861 647354 647960 648795 648820 648839 649525 650188 663546 666538 666883 668549 676022 676112 678135 679461 679774 695122 695123 696582 702163 719333 721846 748957 800588 815017 823695 ] |
||||||||||||||||||||||||||||||
|
14.76 ms (9.43%) |
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 636320 599833 599922 486183 663546 679461 399263 426368 443660 815017 823695 448882 447926 532954 532676 532703 537675 530935 541634 541690 543731 581349 668549 648795 648839 650188 676112 719333 647354 666883 678135 721846 575810 599861 637121 642018 617437 639759 642066 591620 603285 597199 599912 634778 800588 748957 631163 443796 462305 484737 521866 484668 507591 522911 469766 531203 540398 514820 538815 504481 533837 525393 471691 576696 544838 649525 696582 666538 637729 474686 438772 468652 488734 533563 532655 563866 695123 679774 628371 627806 443323 447426 447810 451893 534372 531182 532245 532645 533369 536538 536582 541886 545444 542864 556046 647960 648820 676022 695122 702163 544843 639818 642706 639796 639798 635171 635215 524986 532680 536584 645861 574258 639334 636985 630869 606821 532755 414374 505132 510396 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.78%) |
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 399263 414374 426368 438772 443323 443660 443796 447426 447810 447926 448882 451893 462305 468652 469766 471691 474686 484668 484737 486183 488734 504481 505132 507591 510396 514820 521866 522911 524986 525393 530935 531182 531203 532245 532645 532655 532676 532680 532703 532755 532954 533369 533563 533837 534372 536538 536582 536584 537675 538815 540398 541634 541690 541886 542864 543731 544838 544843 545444 556046 563866 574258 575810 576696 581349 591620 597199 599833 599861 599912 599922 603285 606821 617437 627806 628371 630869 631163 634778 635171 635215 636320 636985 637121 637729 639334 639759 639796 639798 639818 642018 642066 642706 645861 647354 647960 648795 648820 648839 649525 650188 663546 666538 666883 668549 676022 676112 678135 679461 679774 695122 695123 696582 702163 719333 721846 748957 800588 815017 823695 ] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy anal group"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy анал group"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy анал group"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.90%) |
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.