Query Metrics
7
Database Queries
7
Different statements
163.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.09 ms (83.33%) |
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 161552 337226 382134 389499 393326 416208 418853 422909 423027 423500 425394 425545 438056 439424 442524 443849 445404 447785 454200 454785 455057 459176 459566 463213 464930 465061 465562 466390 467023 468652 469530 469554 469803 471663 472393 472603 474847 475779 476298 476322 477071 480920 484683 488551 489809 490820 491360 492050 496729 497478 499163 499899 500402 500938 505257 505762 509303 511399 517282 518879 523672 525761 537091 538960 540232 541118 541368 550821 552664 559886 561381 564956 564960 566455 567077 568409 568434 574149 576944 577065 608773 610582 612171 615823 617395 619177 619898 620198 627803 629906 636541 636552 650782 671810 674129 710943 719300 722073 722120 730382 744093 752502 764019 764037 773363 784632 793898 794907 795616 797399 802060 802157 802166 805049 808256 808655 809749 810291 819238 820014 ] |
||||||||||||||||||||||||||||||
|
17.17 ms (10.51%) |
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 540232 629906 480920 454785 472393 564956 577065 810291 802157 511399 561381 650782 710943 469803 469554 568434 447785 477071 499163 550821 465061 517282 488551 819238 466390 472603 443849 463213 438056 509303 505762 484683 541368 382134 422909 425394 568409 439424 518879 469530 500402 454200 674129 425545 576944 805049 809749 764019 552664 525761 610582 455057 496729 389499 497478 574149 423027 820014 719300 744093 491360 722120 797399 764037 752502 784632 465562 161552 459566 464930 475779 499899 476298 567077 564960 636541 795616 500938 423500 490820 541118 608773 615823 489809 505257 537091 612171 471663 337226 566455 619898 636552 773363 730382 492050 617395 559886 418853 445404 459176 468652 416208 467023 442524 523672 619177 808655 627803 393326 538960 671810 722073 808256 802060 794907 793898 802166 620198 474847 476322 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.50%) |
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 161552 337226 382134 389499 393326 416208 418853 422909 423027 423500 425394 425545 438056 439424 442524 443849 445404 447785 454200 454785 455057 459176 459566 463213 464930 465061 465562 466390 467023 468652 469530 469554 469803 471663 472393 472603 474847 475779 476298 476322 477071 480920 484683 488551 489809 490820 491360 492050 496729 497478 499163 499899 500402 500938 505257 505762 509303 511399 517282 518879 523672 525761 537091 538960 540232 541118 541368 550821 552664 559886 561381 564956 564960 566455 567077 568409 568434 574149 576944 577065 608773 610582 612171 615823 617395 619177 619898 620198 627803 629906 636541 636552 650782 671810 674129 710943 719300 722073 722120 730382 744093 752502 764019 764037 773363 784632 793898 794907 795616 797399 802060 802157 802166 805049 808256 808655 809749 810291 819238 820014 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stockings fuck compilation"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел секс подборк"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.98%) |
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.