Query Metrics
7
Database Queries
7
Different statements
171.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.87 ms (85.07%) |
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 383547 388350 396847 397258 399001 404395 412419 414940 416367 419574 423243 428616 428977 429261 433610 434306 443164 445599 447358 452444 454725 457313 466696 467794 468756 470734 471007 472720 473252 473300 477959 482550 484635 485363 490125 491590 492024 497140 499715 500680 503054 505326 505353 509448 510648 512136 515803 521210 526114 533100 543241 545246 547642 550356 550750 551948 554307 556382 557228 557579 558357 558367 559412 559880 560672 565468 565483 566711 568051 572725 573973 574989 576536 577553 581294 583625 595645 598455 601317 603371 603458 605643 606345 616409 622626 623555 624212 626755 627622 659314 665484 671819 671837 680934 683559 692720 692913 701790 702862 706668 720133 723583 724461 730073 730319 730556 735518 737242 738965 739957 743256 748679 764258 806226 817883 819122 822181 824783 825051 825664 ] |
||||||||||||||||||||||||||||||
|
14.88 ms (8.67%) |
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 416367 616409 554307 577553 606345 434306 557228 574989 680934 576536 605643 806226 735518 748679 526114 573973 477959 473300 824783 482550 543241 566711 720133 622626 737242 743256 764258 559412 414940 470734 472720 825664 490125 565483 583625 547642 692913 702862 671819 627622 626755 730319 724461 730073 701790 396847 665484 428977 429261 454725 500680 505353 467794 445599 466696 473252 491590 497140 428616 817883 572725 558357 550750 452444 515803 551948 399001 819122 533100 659314 692720 683559 706668 556382 559880 603371 595645 738965 512136 484635 383547 443164 457313 545246 388350 404395 468756 412419 423243 492024 560672 471007 505326 485363 499715 433610 822181 723583 825051 558367 581294 568051 671837 598455 624212 739957 623555 419574 503054 601317 509448 397258 447358 521210 550356 557579 603458 730556 510648 565468 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.91%) |
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 383547 388350 396847 397258 399001 404395 412419 414940 416367 419574 423243 428616 428977 429261 433610 434306 443164 445599 447358 452444 454725 457313 466696 467794 468756 470734 471007 472720 473252 473300 477959 482550 484635 485363 490125 491590 492024 497140 499715 500680 503054 505326 505353 509448 510648 512136 515803 521210 526114 533100 543241 545246 547642 550356 550750 551948 554307 556382 557228 557579 558357 558367 559412 559880 560672 565468 565483 566711 568051 572725 573973 574989 576536 577553 581294 583625 595645 598455 601317 603371 603458 605643 606345 616409 622626 623555 624212 626755 627622 659314 665484 671819 671837 680934 683559 692720 692913 701790 702862 706668 720133 723583 724461 730073 730319 730556 735518 737242 738965 739957 743256 748679 764258 806226 817883 819122 822181 824783 825051 825664 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny hairy sex"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые волосатая секс"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.97%) |
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.