Query Metrics
7
Database Queries
7
Different statements
1008.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
822.89 ms (81.57%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
164.96 ms (16.35%) |
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 605560 610954 612621 627341 724447 725237 726075 726428 738522 758200 761951 763232 763322 763661 763832 763892 764515 764696 765062 765117 765145 765279 765385 765942 767332 767538 767606 767629 767751 767878 767903 768182 768445 769188 769210 769243 769338 769349 769877 770455 771512 771801 772256 772401 772445 773414 773502 773526 773682 773918 776221 777542 777628 777675 778821 778969 781036 781156 781612 783706 783736 783800 785246 785889 786085 786518 786712 786719 786997 787037 787449 787473 787487 787889 788330 790609 791009 791728 792118 792451 793349 793396 794266 794289 794784 794922 795641 795993 795996 796053 796348 796765 796796 796977 797209 797363 797887 798113 798533 798719 799142 799511 799894 799976 800333 800723 801699 802863 803274 803475 804544 804739 805214 806082 807298 808148 808856 810083 ] |
||||||||||||||||||||||||||||||
|
12.30 ms (1.22%) |
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 777542 777675 778821 781156 781612 786712 786719 787037 787473 787487 791728 792451 795996 796053 796348 797363 799894 799976 800333 803475 804739 805214 776221 777628 778969 781036 783706 783736 785246 785889 786518 787889 788330 791009 792118 794784 795641 795993 796765 797887 798113 798533 798719 801699 802863 807298 763232 763322 765279 767538 767629 769188 771512 772256 772445 773414 773526 783800 786085 786997 787449 790609 793349 793396 794266 794289 794922 796796 796977 797209 799142 799511 800723 803274 804544 806082 808148 808856 810083 724447 761951 765117 765942 767751 767878 767903 769210 771801 772401 725237 738522 758200 763892 765062 765145 768182 768323 768445 769338 769877 773918 763661 763832 765385 767332 767606 769243 769349 771846 726075 726428 764515 764696 770455 773502 773682 605560 610954 612621 627341 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (0.29%) |
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 605560 610954 612621 627341 724447 725237 726075 726428 738522 758200 761951 763232 763322 763661 763832 763892 764515 764696 765062 765117 765145 765279 765385 765942 767332 767538 767606 767629 767751 767878 767903 768182 768445 769188 769210 769243 769338 769349 769877 770455 771512 771801 772256 772401 772445 773414 773502 773526 773682 773918 776221 777542 777628 777675 778821 778969 781036 781156 781612 783706 783736 783800 785246 785889 786085 786518 786712 786719 786997 787037 787449 787473 787487 787889 788330 790609 791009 791728 792118 792451 793349 793396 794266 794289 794784 794922 795641 795993 795996 796053 796348 796765 796796 796977 797209 797363 797887 798113 798533 798719 799142 799511 799894 799976 800333 800723 801699 802863 803274 803475 804544 804739 805214 806082 807298 808148 808856 810083 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum pov"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum пов"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.