Query Metrics
7
Database Queries
7
Different statements
169.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.34 ms (83.47%) |
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 17190 251363 382884 384325 386593 390894 393456 395170 396172 399190 400927 401124 401296 401778 401922 402340 403050 403053 407320 407851 415298 416303 420600 425939 434167 446267 448516 458031 461096 461098 469910 470257 473314 473797 479324 487370 489430 492601 492610 494557 499891 503955 514574 515138 515226 515234 522845 532766 549256 550629 556849 557304 562109 566981 568579 569683 570066 570075 572563 577794 578470 586378 587297 587936 591418 603145 608042 612106 613471 618873 621043 621686 622216 626752 630187 631601 656779 663359 663411 663882 663930 664302 665238 665498 670476 673607 676467 676469 682510 682538 696964 696970 696972 696977 696981 699480 704841 720429 722665 722672 722919 731091 732167 735602 744326 746081 748136 748634 759565 759591 773620 775616 775784 789283 804530 806031 807772 812115 812129 821798 ] |
||||||||||||||||||||||||||||||
|
17.12 ms (10.11%) |
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 400927 434167 461098 251363 420600 401922 514574 382884 401296 479324 572563 731091 396172 670476 696981 696964 789283 557304 416303 515226 570066 663411 699480 425939 578470 664302 673607 676469 696977 663359 696970 603145 613471 621686 812115 735602 773620 732167 744326 748634 608042 612106 722919 403050 665238 570075 587297 663930 395170 591418 807772 407320 522845 386593 407851 461096 399190 704841 775784 821798 566981 665498 696972 720429 622216 631601 618873 806031 812129 759565 746081 403053 469910 458031 515234 676467 470257 393456 556849 473314 402340 775616 532766 586378 487370 17190 401778 415298 722672 587936 621043 401124 569683 448516 549256 630187 494557 384325 390894 722665 663882 682510 682538 626752 804530 759591 748136 473797 562109 577794 499891 492601 492610 503955 550629 568579 446267 515138 489430 656779 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (1.87%) |
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 17190 251363 382884 384325 386593 390894 393456 395170 396172 399190 400927 401124 401296 401778 401922 402340 403050 403053 407320 407851 415298 416303 420600 425939 434167 446267 448516 458031 461096 461098 469910 470257 473314 473797 479324 487370 489430 492601 492610 494557 499891 503955 514574 515138 515226 515234 522845 532766 549256 550629 556849 557304 562109 566981 568579 569683 570066 570075 572563 577794 578470 586378 587297 587936 591418 603145 608042 612106 613471 618873 621043 621686 622216 626752 630187 631601 656779 663359 663411 663882 663930 664302 665238 665498 670476 673607 676467 676469 682510 682538 696964 696970 696972 696977 696981 699480 704841 720429 722665 722672 722919 731091 732167 735602 744326 746081 748136 748634 759565 759591 773620 775616 775784 789283 804530 806031 807772 812115 812129 821798 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl old man"
]
|
||||||||||||||||||||||||||||||
|
2.16 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк old мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк old мужчин"
]
|
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.