Query Metrics
7
Database Queries
7
Different statements
150.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.25 ms (83.29%) |
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 381882 381966 385476 387693 389979 390427 390775 396393 396408 398073 398950 400571 406378 406387 413746 418975 418994 419844 422920 423211 428255 432396 432412 432514 432545 432618 433352 433386 433420 435638 445536 451606 451650 452538 454380 455543 457348 458178 458472 464049 464461 465444 465910 468851 469804 470173 472897 478873 479385 480091 483240 484098 488855 488888 489841 489860 490257 491056 496218 498167 498635 500152 502852 502928 505764 508772 509536 513366 513748 515478 515693 518380 518966 519129 521333 523896 531602 531611 544079 545485 545496 546282 546939 546941 546977 552115 552338 553658 557996 558069 560334 562978 564320 564393 564569 573967 580027 582500 583538 585939 593120 597100 604270 617672 618808 619919 623821 672216 695714 695745 695901 696379 696389 696396 737910 741896 742880 753066 768697 814906 ] |
||||||||||||||||||||||||||||||
|
14.39 ms (9.57%) |
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 451650 457348 406378 435638 496218 500152 513748 385476 390775 400571 406387 413746 418994 451606 454380 464049 513366 508772 515693 531602 531611 464461 478873 545485 546977 552115 562978 582500 545496 564393 672216 695901 696389 546282 546939 546941 553658 619919 737910 753066 741896 390427 396393 445536 468851 470173 455543 469804 432514 398950 458472 419844 433420 509536 515478 484098 488855 502852 518380 519129 521333 488888 489860 498635 387693 418975 480091 490257 580027 583538 560334 696379 696396 695714 695745 618808 768697 381966 432545 389979 396408 398073 432412 432396 452538 479385 433352 502928 483240 498167 423211 433386 422920 428255 814906 489841 465444 472897 491056 505764 518966 523896 465910 544079 558069 564320 552338 573967 557996 564569 604270 585939 593120 623821 597100 617672 742880 381882 432618 458178 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (2.10%) |
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 381882 381966 385476 387693 389979 390427 390775 396393 396408 398073 398950 400571 406378 406387 413746 418975 418994 419844 422920 423211 428255 432396 432412 432514 432545 432618 433352 433386 433420 435638 445536 451606 451650 452538 454380 455543 457348 458178 458472 464049 464461 465444 465910 468851 469804 470173 472897 478873 479385 480091 483240 484098 488855 488888 489841 489860 490257 491056 496218 498167 498635 500152 502852 502928 505764 508772 509536 513366 513748 515478 515693 518380 518966 519129 521333 523896 531602 531611 544079 545485 545496 546282 546939 546941 546977 552115 552338 553658 557996 558069 560334 562978 564320 564393 564569 573967 580027 582500 583538 585939 593120 597100 604270 617672 618808 619919 623821 672216 695714 695745 695901 696379 696389 696396 737910 741896 742880 753066 768697 814906 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tights fuck"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"колготк секс"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.09%) |
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.