Query Metrics
7
Database Queries
7
Different statements
371.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.79 ms (57.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"онлифанс социальн сет mom"
]
|
||||||||||||||||||||||||||||||
|
137.61 ms (37.07%) |
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 424547 484521 536724 542744 542789 551086 555565 569575 572872 578606 579651 582336 583142 585539 586408 586442 586728 587153 590783 591167 595734 600798 603842 603977 606088 606292 613011 615438 616091 616521 616944 619186 623444 625320 625711 625914 626184 641886 642556 644189 645196 646872 653594 655482 660002 662602 679001 697909 703930 704951 731473 734484 749925 753205 754224 756491 756803 766022 767585 769487 770493 770663 772190 772893 773582 773850 773890 774563 774707 775246 775276 776531 778297 778820 781173 781459 781615 781924 783205 784080 784092 784729 784776 784922 785145 785161 785392 785657 785909 786406 787047 787120 789481 789846 790469 791504 791679 797756 799553 799592 800604 800936 805497 805832 806445 807219 807619 809009 809381 809415 809482 810998 812418 812585 812831 812891 812894 812896 ] |
||||||||||||||||||||||||||||||
|
14.20 ms (3.83%) |
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 660002 662602 676582 697909 578606 582336 586442 591167 613011 616521 626184 641886 587153 644189 586408 586728 590783 595734 616944 625711 615438 774682 774707 775276 776531 781173 781924 784092 784729 784776 784922 785145 785161 785392 799592 800604 809009 812418 812585 774563 778297 778820 785909 786406 787047 791679 799553 807219 809415 809482 810998 812831 812894 734484 753205 772190 773582 773850 773890 781459 784080 787120 789481 800936 805497 805832 812891 812896 731473 766022 767585 769487 754224 756491 756803 749925 770493 770663 772893 606088 623444 703930 775246 781615 783205 785657 789846 790469 791504 797756 806445 807619 809381 619186 424547 484521 536724 542789 569575 572872 579651 583142 551086 555565 542744 655482 704951 645196 646872 653594 679001 585539 606292 616091 625320 625914 642556 600798 603842 603977 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (0.65%) |
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 424547 484521 536724 542744 542789 551086 555565 569575 572872 578606 579651 582336 583142 585539 586408 586442 586728 587153 590783 591167 595734 600798 603842 603977 606088 606292 613011 615438 616091 616521 616944 619186 623444 625320 625711 625914 626184 641886 642556 644189 645196 646872 653594 655482 660002 662602 679001 697909 703930 704951 731473 734484 749925 753205 754224 756491 756803 766022 767585 769487 770493 770663 772190 772893 773582 773850 773890 774563 774707 775246 775276 776531 778297 778820 781173 781459 781615 781924 783205 784080 784092 784729 784776 784922 785145 785161 785392 785657 785909 786406 787047 787120 789481 789846 790469 791504 791679 797756 799553 799592 800604 800936 805497 805832 806445 807219 807619 809009 809381 809415 809482 810998 812418 812585 812831 812891 812894 812896 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"onlyfans mom"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"онлифанс социальн сет mom"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.41%) |
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.