Query Metrics
7
Database Queries
7
Different statements
155.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.40 ms (87.71%) |
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 182110 414082 415755 416693 424574 428729 448604 454943 458867 459203 467110 470052 475431 476198 478029 480428 491183 493715 499388 511014 511866 514868 515270 515488 519309 519350 522167 522703 523761 525351 527914 531850 537447 539741 541277 542704 547858 548158 554858 564501 568210 568500 575973 576517 580873 586005 588854 590778 594183 605208 610923 616013 626196 628106 636651 640975 641190 642048 644036 650727 652878 652881 655458 656173 656875 656931 657528 660577 660579 662049 664193 667052 669543 680791 680797 682397 695604 700681 737140 739390 740357 742318 742327 743748 745107 749084 749202 749268 749680 750565 755006 756825 758276 758807 760609 761646 765569 765612 765625 765684 766087 766381 768261 770265 770400 778721 782071 782453 782836 785574 787514 788210 793280 797339 800473 803092 811706 812054 823224 823333 ] |
||||||||||||||||||||||||||||||
|
10.47 ms (6.73%) |
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 749202 761646 766087 758807 765569 749268 750565 770400 642048 644036 793280 539741 655458 742318 459203 448604 541277 641190 416693 527914 519350 656931 756825 768261 470052 476198 737140 499388 586005 548158 454943 182110 414082 823224 657528 695604 760609 787514 803092 428729 478029 797339 522167 568500 823333 554858 636651 758276 522703 656173 660579 680791 682397 700681 594183 626196 588854 782071 782453 739390 740357 742327 749680 765612 766381 743748 745107 755006 765625 610923 785574 811706 475431 575973 664193 788210 511866 531850 547858 576517 650727 662049 564501 605208 782836 800473 749084 765684 778721 415755 467110 511014 640975 628106 491183 525351 514868 667052 590778 770265 480428 458867 523761 660577 616013 424574 519309 812054 515488 493715 515270 537447 542704 580873 568210 652878 652881 669543 680797 656875 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.60%) |
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 182110 414082 415755 416693 424574 428729 448604 454943 458867 459203 467110 470052 475431 476198 478029 480428 491183 493715 499388 511014 511866 514868 515270 515488 519309 519350 522167 522703 523761 525351 527914 531850 537447 539741 541277 542704 547858 548158 554858 564501 568210 568500 575973 576517 580873 586005 588854 590778 594183 605208 610923 616013 626196 628106 636651 640975 641190 642048 644036 650727 652878 652881 655458 656173 656875 656931 657528 660577 660579 662049 664193 667052 669543 680791 680797 682397 695604 700681 737140 739390 740357 742318 742327 743748 745107 749084 749202 749268 749680 750565 755006 756825 758276 758807 760609 761646 765569 765612 765625 765684 766087 766381 768261 770265 770400 778721 782071 782453 782836 785574 787514 788210 793280 797339 800473 803092 811706 812054 823224 823333 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп анал соло"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass anal solo"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп анал соло"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.84%) |
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.