Query Metrics
7
Database Queries
7
Different statements
145.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.11 ms (82.37%) |
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 181902 238809 381991 383366 384914 386767 389264 390813 394681 396168 396608 398209 400719 406800 412083 413524 422671 428158 430303 430976 432107 444103 452376 453840 454076 455808 465192 469554 470288 470796 471895 472712 473829 474549 479989 481134 486445 488132 488709 489371 489837 491021 491611 491678 492598 502024 503553 503863 505812 509325 511559 511925 515257 515717 515894 516433 521572 523579 524948 525535 526545 527633 529312 530061 531612 531776 532357 532482 537600 538854 539774 540476 541866 542969 553786 566148 566153 566155 566157 567110 567915 568506 568508 573889 579362 582790 599826 601538 605477 615575 615909 623849 624874 625968 638360 641115 650195 665728 679457 696310 727449 748250 781736 798939 817507 817597 818251 822024 825786 ] |
||||||||||||||||||||||||||||||
|
16.32 ms (11.20%) |
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 601538 453840 579362 582790 623849 599826 400719 515257 541866 825786 181902 394681 396608 491611 502024 537600 539774 567110 573889 566157 650195 665728 679457 638360 381991 383366 444103 525535 481134 625968 817507 470288 515717 605477 822024 238809 398209 422671 817597 474549 473829 531612 527633 553786 624874 727449 748250 384914 386767 488709 505812 479989 452376 471895 531776 538854 489837 542969 567915 615575 413524 455808 389264 469554 503553 641115 532482 390813 428158 454076 529312 523579 503863 511925 568508 566148 470796 516433 524948 526545 488132 566153 491678 515894 430303 432107 781736 486445 566155 615909 491021 492598 818251 696310 489371 412083 532357 530061 472712 798939 511559 521572 406800 509325 396168 465192 568506 540476 430976 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.58%) |
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 181902 238809 381991 383366 384914 386767 389264 390813 394681 396168 396608 398209 400719 406800 412083 413524 422671 428158 430303 430976 432107 444103 452376 453840 454076 455808 465192 469554 470288 470796 471895 472712 473829 474549 479989 481134 486445 488132 488709 489371 489837 491021 491611 491678 492598 502024 503553 503863 505812 509325 511559 511925 515257 515717 515894 516433 521572 523579 524948 525535 526545 527633 529312 530061 531612 531776 532357 532482 537600 538854 539774 540476 541866 542969 553786 566148 566153 566155 566157 567110 567915 568506 568508 573889 579362 582790 599826 601538 605477 615575 615909 623849 624874 625968 638360 641115 650195 665728 679457 696310 727449 748250 781736 798939 817507 817597 818251 822024 825786 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"car young"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вмашин young"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вмашин young"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.05%) |
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.