Query Metrics
7
Database Queries
7
Different statements
221.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
192.14 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 424883 446547 452957 466417 467114 473061 475454 480924 484951 500129 510190 531569 537240 540070 542096 545771 546045 546847 546881 549142 551560 553672 554231 555622 556448 556468 556918 557648 558881 559677 560045 561426 563670 565019 565086 566093 567172 568679 569237 571350 572696 573738 582526 587039 593376 594247 647765 655505 655548 670542 679513 681234 684441 693224 694858 696385 703953 706804 711965 713097 713904 716411 717428 718360 718906 740827 749729 759287 760373 762343 762634 768154 778140 788012 793234 795007 804032 814227 814415 816097 816696 817675 817905 818233 818626 818695 818816 818855 818947 818957 819278 819445 819659 819666 819904 821811 821841 823251 823603 824301 824307 824493 824762 824795 824957 825028 825082 825480 825538 825695 825761 825828 825886 826108 826176 826272 826708 827235 827346 827552 ] |
||||||||||||||||||||||||||||||
|
18.92 ms (8.54%) |
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 740827 749729 716411 795007 804032 424883 467114 452957 537240 531569 540070 484951 553672 554231 560045 568679 571350 546847 557648 561426 567172 569237 582526 542096 546045 546881 549142 551560 556468 558881 559677 565086 572696 573738 556448 556918 563670 565019 566093 587039 594247 593376 475454 480924 466417 473061 446547 500129 510190 824957 824301 816097 717428 778140 788012 793234 762634 760373 762343 759287 768154 814415 817675 818855 818947 818957 819904 821811 824762 825886 826272 825761 826708 814227 816696 818816 823603 827235 827346 827552 818626 818695 819445 819659 823251 824307 824493 825695 825828 826176 817905 818233 819278 819666 821841 824795 825028 825082 825480 826108 825538 555622 545771 681234 684441 703953 706804 711965 713904 718906 655505 655548 670542 693224 713097 718360 647765 679513 694858 696385 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.37%) |
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 424883 446547 452957 466417 467114 473061 475454 480924 484951 500129 510190 531569 537240 540070 542096 545771 546045 546847 546881 549142 551560 553672 554231 555622 556448 556468 556918 557648 558881 559677 560045 561426 563670 565019 565086 566093 567172 568679 569237 571350 572696 573738 582526 587039 593376 594247 647765 655505 655548 670542 679513 681234 684441 693224 694858 696385 703953 706804 711965 713097 713904 716411 717428 718360 718906 740827 749729 759287 760373 762343 762634 768154 778140 788012 793234 795007 804032 814227 814415 816097 816696 817675 817905 818233 818626 818695 818816 818855 818947 818957 819278 819445 819659 819666 819904 821811 821841 823251 823603 824301 824307 824493 824762 824795 824957 825028 825082 825480 825538 825695 825761 825828 825886 826108 826176 826272 826708 827235 827346 827552 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"онлифанс социальн сет"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"onlyfans 2024"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.69%) |
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.