Query Metrics
7
Database Queries
7
Different statements
183.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.71 ms (81.74%) |
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 4446 6694 6965 13428 24931 91345 95700 108127 154123 160352 182118 213118 233486 276780 358837 365910 383443 384147 385034 385992 386791 386935 388770 388957 389785 390218 390508 391756 394661 397861 398973 401465 407809 411187 411971 415591 416032 417015 417835 418051 420178 421823 421835 421840 421897 421913 422165 422207 423920 423929 424096 424121 424875 425861 426515 428566 429741 432644 435651 441122 441131 442978 443691 443810 444255 444502 444797 446637 446695 446757 448932 453377 455496 456208 464214 464247 464254 468181 468337 468344 468367 469120 470923 473446 476379 477691 479054 479253 481501 482219 482773 485511 489357 490030 492176 493223 493749 497236 504482 510879 517271 559857 570972 604290 668509 695186 708161 717689 718040 720105 721451 758128 769131 776121 791883 791924 795722 802144 825979 ] |
||||||||||||||||||||||||||||||
|
23.49 ms (12.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 802144 6694 91345 444797 468344 276780 6965 358837 365910 383443 389785 443691 470923 213118 108127 4446 428566 559857 721451 776121 791883 795722 769131 758128 764595 791924 154123 160352 825979 407809 397861 444255 95700 385034 182118 24931 13428 388957 386935 390508 415591 441131 411971 425861 426515 441122 429741 432644 482773 446637 446695 476379 481501 482219 497236 604290 390218 411187 421823 421840 422165 422207 423929 469120 388770 401465 443810 477691 479054 479253 420178 421835 421897 421913 424096 424121 444502 455496 385992 418051 423920 448932 456208 416032 417835 424875 435651 446757 464247 468181 485511 489357 504482 386791 384147 233486 394661 391756 398973 417015 442978 492176 453377 490030 493749 464214 464254 468337 473446 493223 510879 517271 468367 570972 668509 708161 718040 720105 695186 717689 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.36%) |
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 4446 6694 6965 13428 24931 91345 95700 108127 154123 160352 182118 213118 233486 276780 358837 365910 383443 384147 385034 385992 386791 386935 388770 388957 389785 390218 390508 391756 394661 397861 398973 401465 407809 411187 411971 415591 416032 417015 417835 418051 420178 421823 421835 421840 421897 421913 422165 422207 423920 423929 424096 424121 424875 425861 426515 428566 429741 432644 435651 441122 441131 442978 443691 443810 444255 444502 444797 446637 446695 446757 448932 453377 455496 456208 464214 464247 464254 468181 468337 468344 468367 469120 470923 473446 476379 477691 479054 479253 481501 482219 482773 485511 489357 490030 492176 493223 493749 497236 504482 510879 517271 559857 570972 604290 668509 695186 708161 717689 718040 720105 721451 758128 769131 776121 791883 791924 795722 802144 825979 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мама с тетей"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.82%) |
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.