Query Metrics
7
Database Queries
7
Different statements
149.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.44 ms (83.14%) |
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 452284 540703 544948 546221 549132 551688 554246 555580 555602 555905 556206 556997 557677 560349 562072 562482 563674 565721 568568 571375 575263 575380 582007 583157 583421 584501 584781 592188 627333 663192 666418 667136 669299 674162 678180 684507 691787 695896 695914 699836 710367 710966 724928 726933 728795 730509 731521 734505 735004 736850 740805 743463 743586 747248 749733 751050 752757 755483 756314 757913 758248 762005 762327 762330 763541 764165 764441 764511 764944 765102 769513 770601 771333 772035 772350 772909 773022 774339 779073 779452 780905 781637 784206 784687 784838 784992 786182 786919 787055 787613 787723 789794 789843 791201 791453 792265 795023 797425 797857 797934 798359 803585 803592 804876 805197 807142 807478 807594 808884 810767 811313 812643 812862 813905 814470 825531 826330 ] |
||||||||||||||||||||||||||||||
|
14.48 ms (9.68%) |
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 780905 781637 791201 792265 807142 807478 812643 734505 747248 751050 757913 762330 764441 770601 772035 772909 784206 784687 784992 786182 787055 787613 787723 795023 797425 797857 797934 798359 804876 807594 808884 811313 812862 743463 749733 762005 762327 765102 773022 774339 724928 726933 736517 756314 758248 764165 764511 769513 771333 772350 736850 743586 752757 728795 730509 731521 735004 740805 755483 763541 764944 769530 627333 697943 699836 710367 710966 779073 779452 784838 786919 789794 789843 791453 803585 803592 805197 810767 452284 592188 826330 825531 813905 814470 540703 544948 546221 551688 554246 555602 555905 568568 582007 583157 556206 562072 563674 565721 575380 584501 584781 549132 555580 556997 557677 560349 562482 571375 575263 583421 663192 666418 667136 669299 674162 678180 684507 691787 695896 695914 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (2.09%) |
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 452284 540703 544948 546221 549132 551688 554246 555580 555602 555905 556206 556997 557677 560349 562072 562482 563674 565721 568568 571375 575263 575380 582007 583157 583421 584501 584781 592188 627333 663192 666418 667136 669299 674162 678180 684507 691787 695896 695914 699836 710367 710966 724928 726933 728795 730509 731521 734505 735004 736850 740805 743463 743586 747248 749733 751050 752757 755483 756314 757913 758248 762005 762327 762330 763541 764165 764441 764511 764944 765102 769513 770601 771333 772035 772350 772909 773022 774339 779073 779452 780905 781637 784206 784687 784838 784992 786182 786919 787055 787613 787723 789794 789843 791201 791453 792265 795023 797425 797857 797934 798359 803585 803592 804876 805197 807142 807478 807594 808884 810767 811313 812643 812862 813905 814470 825531 826330 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"onlyfans cum"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.36%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"онлифанс социальн сет cum"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"онлифанс социальн сет cum"
]
|
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.