Query Metrics
7
Database Queries
7
Different statements
187.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.97 ms (86.17%) |
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 20907 23065 82217 91146 167822 184909 213604 317820 383415 385480 387830 393868 397477 397678 402503 406578 410265 412749 412952 413732 418540 419140 419143 419585 420250 422506 422920 427449 428913 429544 429949 435618 444822 445765 447928 452533 456639 457407 460474 460952 471168 476162 485046 491454 492410 505927 512186 530928 536003 540313 550639 550771 551002 551950 551978 552002 552034 552903 552910 554305 554435 556390 556418 557844 559849 559876 559928 565483 575344 576536 584093 587898 595056 597263 613857 619414 622588 622625 633482 639266 647643 658173 673044 693148 696318 701753 707727 712181 712222 712235 713474 713533 717274 722426 722438 729857 730549 730569 730581 730655 730659 736172 737109 739451 742478 745986 747055 747120 748672 753212 762110 763322 766626 788257 792763 795708 806678 810018 810416 826299 ] |
||||||||||||||||||||||||||||||
|
15.30 ms (8.14%) |
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 730549 419585 552903 658173 554305 806678 23065 619414 402503 739451 445765 576536 559849 639266 766626 613857 447928 435618 213604 397477 622625 91146 551950 742478 712222 713533 633482 730581 747120 745986 383415 595056 748672 412749 385480 552910 717274 701753 476162 587898 492410 647643 536003 622588 730569 730655 696318 551002 712181 693148 730659 747055 792763 713474 184909 512186 491454 406578 393868 530928 763322 559928 412952 826299 584093 810018 729857 505927 552034 556390 554435 722438 387830 422920 552002 317820 413732 550639 551978 410265 452533 20907 82217 460952 762110 753212 737109 712235 419140 565483 736172 707727 444822 429544 460474 556418 456639 673044 795708 422506 788257 419143 597263 722426 457407 420250 167822 429949 471168 559876 427449 418540 428913 540313 810416 485046 575344 550771 557844 397678 ] |
||||||||||||||||||||||||||||||
|
3.50 ms (1.86%) |
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 20907 23065 82217 91146 167822 184909 213604 317820 383415 385480 387830 393868 397477 397678 402503 406578 410265 412749 412952 413732 418540 419140 419143 419585 420250 422506 422920 427449 428913 429544 429949 435618 444822 445765 447928 452533 456639 457407 460474 460952 471168 476162 485046 491454 492410 505927 512186 530928 536003 540313 550639 550771 551002 551950 551978 552002 552034 552903 552910 554305 554435 556390 556418 557844 559849 559876 559928 565483 575344 576536 584093 587898 595056 597263 613857 619414 622588 622625 633482 639266 647643 658173 673044 693148 696318 701753 707727 712181 712222 712235 713474 713533 717274 722426 722438 729857 730549 730569 730581 730655 730659 736172 737109 739451 742478 745986 747055 747120 748672 753212 762110 763322 766626 788257 792763 795708 806678 810018 810416 826299 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian girl fuck"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк девушк секс"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.82%) |
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.