Query Metrics
7
Database Queries
7
Different statements
172.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.80 ms (80.09%) |
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 145660 381933 393091 399639 399652 400195 400243 407809 409784 410781 413296 415917 418098 425968 425993 426005 428322 428354 428860 431481 433592 435613 443335 443581 443622 443639 444101 445712 445908 446152 447951 450184 450310 451523 460448 461606 463739 464627 467712 468120 471653 476729 479863 482602 494401 495673 496810 497891 500226 503418 505631 506141 507290 508141 508947 509309 510206 512376 513102 516503 518089 518176 520226 523082 528550 531542 531900 537349 537508 538544 539645 546842 549130 549739 558804 560229 561558 562509 566032 567386 568928 574369 579284 581438 583614 584403 596459 599173 601113 601316 601825 607662 608667 615004 619232 620569 636449 652644 660739 686207 690828 694056 719014 720289 724484 732347 733480 756398 771673 772248 779647 779840 784417 800030 800556 807958 808461 809271 811475 812757 ] |
||||||||||||||||||||||||||||||
|
25.03 ms (14.55%) |
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 546842 574369 443581 425993 567386 450310 619232 620569 636449 733480 784417 538544 450184 445712 561558 581438 601825 800030 494401 507290 690828 464627 537508 812757 418098 505631 531900 596459 428354 399639 508947 720289 531542 482602 400243 433592 500226 426005 471653 615004 694056 756398 495673 508141 537349 724484 566032 516503 393091 660739 807958 447951 399652 425968 479863 811475 445908 518089 435613 601316 800556 520226 599173 779647 460448 381933 539645 562509 719014 579284 771673 808461 468120 513102 400195 568928 446152 558804 584403 652644 608667 772248 443639 451523 444101 523082 732347 512376 443335 467712 583614 607662 428860 410781 809271 518176 510206 428322 463739 461606 413296 496810 431481 506141 549130 549739 509309 497891 560229 779840 145660 407809 503418 476729 601113 409784 528550 686207 443622 415917 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.33%) |
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 145660 381933 393091 399639 399652 400195 400243 407809 409784 410781 413296 415917 418098 425968 425993 426005 428322 428354 428860 431481 433592 435613 443335 443581 443622 443639 444101 445712 445908 446152 447951 450184 450310 451523 460448 461606 463739 464627 467712 468120 471653 476729 479863 482602 494401 495673 496810 497891 500226 503418 505631 506141 507290 508141 508947 509309 510206 512376 513102 516503 518089 518176 520226 523082 528550 531542 531900 537349 537508 538544 539645 546842 549130 549739 558804 560229 561558 562509 566032 567386 568928 574369 579284 581438 583614 584403 596459 599173 601113 601316 601825 607662 608667 615004 619232 620569 636449 652644 660739 686207 690828 694056 719014 720289 724484 732347 733480 756398 771673 772248 779647 779840 784417 800030 800556 807958 808461 809271 811475 812757 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex big tit"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс большие tit"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс большие tit"
]
|
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.