Query Metrics
7
Database Queries
7
Different statements
159.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.66 ms (82.51%) |
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 81656 95557 130126 314541 361978 384900 385563 393855 395736 396115 397192 399387 399395 399418 401652 402015 409532 415525 428383 430428 431948 444778 445568 456142 456847 470269 470760 471371 474011 477864 484844 484859 484862 488719 490008 491371 491454 491513 497576 512174 512267 512310 515220 522160 523702 523709 530826 532668 538463 540187 542820 542951 547670 548625 548725 548748 550727 551037 554877 554889 562259 575752 576373 578371 591829 600370 603242 612430 615900 633508 641628 642816 644300 653756 672159 672767 673048 675951 679098 679447 681286 686073 692448 693110 693205 695930 698597 699775 700816 705514 708823 714851 718521 719057 721687 722545 723468 727415 741114 741283 741862 748138 748949 750465 754174 758205 775766 775895 776020 778364 791355 794923 797940 804914 817344 817946 818377 818538 823217 827925 ] |
||||||||||||||||||||||||||||||
|
16.53 ms (10.36%) |
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 401652 456142 81656 130126 314541 396115 402015 430428 428383 818377 456847 445568 491454 515220 540187 530826 488719 562259 578371 547670 548748 550727 575752 542951 554889 672767 679447 686073 653756 675951 714851 718521 708823 548625 576373 603242 642816 633508 778364 791355 804914 797940 741862 748138 758205 754174 741114 741283 750465 399387 470760 470269 385563 474011 409532 415525 484862 490008 491371 512267 512310 484844 484859 491513 497576 523702 523709 384900 393855 395736 361978 95557 397192 399395 399418 431948 444778 818538 823217 817344 817946 827925 522160 538463 512174 532668 471371 477864 542820 548725 554877 551037 673048 681286 692448 693205 695930 699775 705514 672159 679098 698597 700816 722545 723468 693110 719057 721687 615900 644300 600370 612430 591829 641628 775766 775895 776020 794923 727415 748949 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (2.08%) |
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 81656 95557 130126 314541 361978 384900 385563 393855 395736 396115 397192 399387 399395 399418 401652 402015 409532 415525 428383 430428 431948 444778 445568 456142 456847 470269 470760 471371 474011 477864 484844 484859 484862 488719 490008 491371 491454 491513 497576 512174 512267 512310 515220 522160 523702 523709 530826 532668 538463 540187 542820 542951 547670 548625 548725 548748 550727 551037 554877 554889 562259 575752 576373 578371 591829 600370 603242 612430 615900 633508 641628 642816 644300 653756 672159 672767 673048 675951 679098 679447 681286 686073 692448 693110 693205 695930 698597 699775 700816 705514 708823 714851 718521 719057 721687 722545 723468 727415 741114 741283 741862 748138 748949 750465 754174 758205 775766 775895 776020 778364 791355 794923 797940 804914 817344 817946 818377 818538 823217 827925 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"group girls"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"group девушк"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"group девушк"
]
|
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.