Query Metrics
7
Database Queries
7
Different statements
220.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
189.43 ms (85.88%) |
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 395394 413050 416773 417064 419880 421155 423893 424498 425523 428895 431422 439673 441398 442673 446735 447717 449724 450817 456553 458789 464528 467721 470324 470391 470449 471443 471515 471945 472496 474167 476360 477362 482824 483239 483401 483551 483594 484127 484223 484230 486020 488405 488822 492108 496757 498043 499028 500463 502305 503129 505818 506816 507767 509312 511581 511897 513732 515334 515749 515850 517059 517063 517190 518174 519016 519092 519560 520448 520485 520596 520688 521236 522284 522688 523522 523535 523537 523539 525275 527038 528938 531146 532419 536684 555510 561135 567677 568062 570067 570068 575324 575832 578563 580116 581852 585332 591612 603663 604555 606794 608206 611477 615826 617234 620298 621277 625215 626576 636209 669409 671403 677060 677097 682107 684694 718747 720257 720885 808865 ] |
||||||||||||||||||||||||||||||
|
20.93 ms (9.49%) |
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 518174 519092 484230 483551 511581 520596 523539 570068 467721 520448 568062 608206 611477 425523 419880 395394 413050 472496 458789 483401 500463 531146 502305 511897 520485 567677 580116 555510 575832 682107 720257 669409 677097 718747 720885 575324 606794 620298 585332 626576 808865 447717 474167 416773 464528 449724 470324 470391 470449 471945 456553 515850 517059 513476 528938 484127 484223 486020 513732 515334 517063 522284 488822 503129 505818 442673 417064 471443 477362 450817 471515 521236 536684 581852 561135 677060 684694 603663 617234 428895 476360 424498 525275 483594 496757 507767 509312 527038 517190 523535 492108 506816 523522 671403 625215 498043 441398 488405 446735 519016 532419 570067 578563 615826 636209 423893 431422 515749 483239 519560 499028 522688 482824 621277 421155 520688 523537 591612 604555 439673 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (1.43%) |
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 395394 413050 416773 417064 419880 421155 423893 424498 425523 428895 431422 439673 441398 442673 446735 447717 449724 450817 456553 458789 464528 467721 470324 470391 470449 471443 471515 471945 472496 474167 476360 477362 482824 483239 483401 483551 483594 484127 484223 484230 486020 488405 488822 492108 496757 498043 499028 500463 502305 503129 505818 506816 507767 509312 511581 511897 513732 515334 515749 515850 517059 517063 517190 518174 519016 519092 519560 520448 520485 520596 520688 521236 522284 522688 523522 523535 523537 523539 525275 527038 528938 531146 532419 536684 555510 561135 567677 568062 570067 570068 575324 575832 578563 580116 581852 585332 591612 603663 604555 606794 608206 611477 615826 617234 620298 621277 625215 626576 636209 669409 671403 677060 677097 682107 684694 718747 720257 720885 808865 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful friend"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая friend"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.66%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая friend"
]
|
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.