Query Metrics
7
Database Queries
7
Different statements
198.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.44 ms (86.33%) |
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 4266 104990 191343 233862 276780 281450 382186 385952 387186 396106 396278 401336 402032 403378 417519 419159 435472 437417 443836 446315 453972 454091 468222 472062 474360 476981 478686 479958 480857 488556 508483 518151 546599 546772 555728 560266 560867 580343 585157 586608 586912 588344 590970 591516 597108 599508 603959 605583 605976 607432 609108 609679 615197 616500 618019 621509 625097 634995 640319 640617 643025 678916 699232 709872 711535 713015 713841 716004 721959 725547 727015 728392 730069 730267 731354 733542 734416 738418 741032 745912 749945 750275 752496 756261 757180 761009 761098 761192 767193 770730 771643 773730 774855 778185 778526 778962 779317 780843 782702 782745 784289 787217 787827 788051 789927 791371 791374 793971 795743 796807 798798 800050 800721 802487 805652 806081 806242 807134 812198 812655 ] |
||||||||||||||||||||||||||||||
|
15.21 ms (7.66%) |
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 716004 580343 597108 605976 609108 615197 590970 591516 618019 625097 640319 585157 599508 603959 605583 616500 634995 586608 588344 621509 640617 643025 778526 779317 789927 795743 805652 807134 812655 774855 778185 778962 780843 782745 791374 800721 725547 741032 752496 761098 770730 773730 784289 788051 798798 802487 728392 730069 730267 731354 756261 757180 761009 738418 734416 745912 767193 771643 727015 733542 749945 750275 761192 609679 699232 709872 711535 713015 713841 721959 782702 787217 787827 791371 793971 796807 800050 806081 806242 812198 385952 387186 396106 401336 402032 233862 276780 281450 4266 104990 191343 453972 437417 382186 403378 443836 435472 419159 454091 478686 518151 474360 546772 560867 546599 555728 560266 678916 586912 607432 446315 468222 480857 396278 476981 479958 417519 472062 508483 488556 ] |
||||||||||||||||||||||||||||||
|
4.36 ms (2.19%) |
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 4266 104990 191343 233862 276780 281450 382186 385952 387186 396106 396278 401336 402032 403378 417519 419159 435472 437417 443836 446315 453972 454091 468222 472062 474360 476981 478686 479958 480857 488556 508483 518151 546599 546772 555728 560266 560867 580343 585157 586608 586912 588344 590970 591516 597108 599508 603959 605583 605976 607432 609108 609679 615197 616500 618019 621509 625097 634995 640319 640617 643025 678916 699232 709872 711535 713015 713841 716004 721959 725547 727015 728392 730069 730267 731354 733542 734416 738418 741032 745912 749945 750275 752496 756261 757180 761009 761098 761192 767193 770730 771643 773730 774855 778185 778526 778962 779317 780843 782702 782745 784289 787217 787827 788051 789927 791371 791374 793971 795743 796807 798798 800050 800721 802487 805652 806081 806242 807134 812198 812655 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doggy hot"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак hot"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рак hot"
]
|
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.