Query Metrics
7
Database Queries
7
Different statements
195.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.66 ms (84.55%) |
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 13166 27844 39356 117221 123994 178561 314541 389796 393039 393442 395408 396262 396748 397805 398281 402473 402666 406817 409227 411451 413739 419410 420760 420865 425480 425714 429071 429100 429286 429566 430800 431234 432879 436230 444726 446923 447850 461585 462848 463636 464625 465543 469689 474580 476753 486766 489523 491776 492788 494302 494601 499936 509600 514281 517038 517265 528346 536377 541965 542217 550424 559097 559974 560431 561392 561684 564392 564459 565044 565054 565055 566231 569122 569388 570711 575610 580230 580704 590794 594049 594481 597079 598962 604350 604690 607211 614096 614718 618398 618921 620281 626746 634029 640776 651606 652913 660721 668524 672469 672579 678620 679380 689665 692068 698972 699608 702954 709781 709994 711899 713027 717899 719058 721118 722499 722909 746157 774607 775492 802314 ] |
||||||||||||||||||||||||||||||
|
19.78 ms (10.10%) |
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 402666 461585 431234 494302 489523 492788 494601 39356 402473 413739 746157 491776 420760 476753 672469 436230 123994 178561 395408 393039 393442 314541 27844 13166 117221 389796 396262 396748 397805 398281 406817 420865 425480 432879 429071 429100 409227 429286 411451 419410 430800 425714 429566 444726 446923 486766 447850 463636 469689 474580 462848 509600 499936 514281 517038 517265 536377 528346 464625 465543 550424 564392 575610 564459 565054 569388 570711 580230 541965 542217 559974 561392 565044 565055 566231 569122 580704 651606 652913 660721 698972 699608 709781 711899 717899 719058 721118 679380 689665 722909 668524 672579 678620 692068 702954 709994 713027 722499 559097 560431 561684 590794 604690 626746 597079 598962 618398 634029 594049 604350 614096 618921 640776 594481 607211 614718 620281 775492 802314 774607 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.60%) |
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 13166 27844 39356 117221 123994 178561 314541 389796 393039 393442 395408 396262 396748 397805 398281 402473 402666 406817 409227 411451 413739 419410 420760 420865 425480 425714 429071 429100 429286 429566 430800 431234 432879 436230 444726 446923 447850 461585 462848 463636 464625 465543 469689 474580 476753 486766 489523 491776 492788 494302 494601 499936 509600 514281 517038 517265 528346 536377 541965 542217 550424 559097 559974 560431 561392 561684 564392 564459 565044 565054 565055 566231 569122 569388 570711 575610 580230 580704 590794 594049 594481 597079 598962 604350 604690 607211 614096 614718 618398 618921 620281 626746 634029 640776 651606 652913 660721 668524 672469 672579 678620 679380 689665 692068 698972 699608 702954 709781 709994 711899 713027 717899 719058 721118 722499 722909 746157 774607 775492 802314 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen blonde"
]
|
||||||||||||||||||||||||||||||
|
1.60 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.