Query Metrics
7
Database Queries
7
Different statements
145.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.74 ms (85.96%) |
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 7615 10171 13646 16897 23687 23815 38637 47128 53654 58105 76011 77013 81818 83894 96479 96521 96800 97191 116626 117425 122634 129791 130054 131522 153440 154826 160270 185003 191059 191361 191412 192551 192814 212893 233459 233601 258166 260350 272014 278488 308684 309758 319314 326158 331327 357915 359089 377154 381817 382085 382303 382769 382839 383046 383450 383542 383820 384321 384978 385125 385547 385705 385790 385949 386096 386389 386653 386930 387221 390059 390350 390758 391206 391489 394335 394448 395454 396106 398710 400194 401326 402032 402427 403076 405972 409946 426021 434661 434819 456916 467180 468552 469733 503002 514316 535188 551180 562774 567640 589830 601264 606169 621715 624467 645401 666832 669749 683592 683595 707278 713014 726449 727515 747311 749143 773442 791345 791528 800686 802528 ] |
||||||||||||||||||||||||||||||
|
11.55 ms (7.96%) |
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 791345 382769 402032 23687 191361 390758 129791 38637 383820 131522 385790 192551 385125 331327 606169 319314 398710 212893 96800 116626 551180 385949 13646 258166 76011 154826 357915 749143 382839 309758 96521 802528 377154 382303 400194 16897 567640 727515 535188 383450 359089 386653 386389 562774 683592 624467 395454 394335 81818 191412 747311 185003 233601 308684 713014 387221 469733 385547 390059 383046 130054 7615 260350 23815 403076 589830 97191 382085 726449 58105 383542 384321 326158 192814 669749 384978 394448 434661 122634 381817 409946 514316 645401 272014 386930 83894 233459 707278 47128 53654 503002 426021 467180 621715 385705 390350 391206 278488 153440 402427 405972 666832 800686 391489 683595 791528 773442 396106 386096 401326 160270 10171 117425 191059 96479 77013 434819 468552 456916 601264 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.54%) |
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 7615 10171 13646 16897 23687 23815 38637 47128 53654 58105 76011 77013 81818 83894 96479 96521 96800 97191 116626 117425 122634 129791 130054 131522 153440 154826 160270 185003 191059 191361 191412 192551 192814 212893 233459 233601 258166 260350 272014 278488 308684 309758 319314 326158 331327 357915 359089 377154 381817 382085 382303 382769 382839 383046 383450 383542 383820 384321 384978 385125 385547 385705 385790 385949 386096 386389 386653 386930 387221 390059 390350 390758 391206 391489 394335 394448 395454 396106 398710 400194 401326 402032 402427 403076 405972 409946 426021 434661 434819 456916 467180 468552 469733 503002 514316 535188 551180 562774 567640 589830 601264 606169 621715 624467 645401 666832 669749 683592 683595 707278 713014 726449 727515 747311 749143 773442 791345 791528 800686 802528 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde fuck"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая секс"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.88%) |
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.