Query Metrics
7
Database Queries
7
Different statements
157.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.63 ms (83.71%) |
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 16691 34645 53437 57971 105333 150289 185011 197599 260041 308297 310706 314397 321414 346150 358857 361382 383598 384562 385515 386368 386636 387486 390241 390723 392547 392959 393728 396095 396859 397835 397845 397905 402793 416384 417682 420065 422243 424609 426263 436829 438590 443271 443801 450612 451309 456478 457912 476844 480835 486096 487995 501040 502596 504831 506306 511818 514101 520283 520888 523168 524971 538162 549065 559898 560304 571475 573616 577603 582056 583439 594980 595326 595639 595679 595688 598666 602177 603941 606102 607574 612414 616765 620940 624986 625279 626844 627320 650642 650994 652219 659250 670750 676415 680746 685220 693234 698081 704584 709581 733810 741567 744340 745966 750525 753966 761595 768554 778480 780589 790605 793782 800129 803904 814521 814582 817383 817711 818270 819657 827189 ] |
||||||||||||||||||||||||||||||
|
14.04 ms (8.93%) |
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 577603 652219 680746 670750 606102 595639 612414 624986 616765 768554 607574 625279 390723 422243 443271 476844 436829 397905 450612 393728 402793 443801 456478 501040 502596 511818 487995 520283 520888 524971 514101 523168 504831 386368 385515 383598 105333 392547 387486 417682 817383 818270 819657 827189 814582 486096 704584 594980 595679 595326 793782 790605 741567 744340 150289 57971 384562 397835 314397 420065 598666 197599 185011 392959 260041 308297 321414 361382 310706 346150 358857 34645 53437 390241 396095 424609 438590 817711 814521 457912 451309 480835 506306 538162 583439 571475 582056 549065 559898 560304 573616 659250 676415 650994 685220 693234 650642 698081 602177 620940 626844 603941 595688 778480 803904 753966 800129 733810 745966 750525 761595 627320 709581 780589 386636 16691 396859 397845 416384 426263 ] |
||||||||||||||||||||||||||||||
|
3.52 ms (2.24%) |
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 16691 34645 53437 57971 105333 150289 185011 197599 260041 308297 310706 314397 321414 346150 358857 361382 383598 384562 385515 386368 386636 387486 390241 390723 392547 392959 393728 396095 396859 397835 397845 397905 402793 416384 417682 420065 422243 424609 426263 436829 438590 443271 443801 450612 451309 456478 457912 476844 480835 486096 487995 501040 502596 504831 506306 511818 514101 520283 520888 523168 524971 538162 549065 559898 560304 571475 573616 577603 582056 583439 594980 595326 595639 595679 595688 598666 602177 603941 606102 607574 612414 616765 620940 624986 625279 626844 627320 650642 650994 652219 659250 670750 676415 680746 685220 693234 698081 704584 709581 733810 741567 744340 745966 750525 753966 761595 768554 778480 780589 790605 793782 800129 803904 814521 814582 817383 817711 818270 819657 827189 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"поз"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пози"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"поз"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.12%) |
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.