Query Metrics
7
Database Queries
7
Different statements
181.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.27 ms (85.65%) |
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 388401 428574 455888 482526 515291 529061 536245 536266 540844 545717 552397 552629 575109 575606 590806 595478 595497 597029 597798 597823 598135 598544 598754 600146 603052 615005 619780 620805 621081 624170 636049 640466 641950 652955 654346 656579 658728 658837 660597 670048 671529 671665 671670 672070 674980 678125 680230 691217 694492 695993 696160 709837 717890 718719 719376 720223 720397 722538 724193 725405 725549 726164 727824 728745 728755 730346 731485 732000 735951 741529 742833 742837 742942 743232 744907 746802 747138 747147 747437 747443 747519 748407 749329 749343 749990 752595 752721 753262 753290 753294 753333 753339 753360 753395 753418 753818 753854 753898 754180 754182 755634 755968 756106 758528 760919 760931 761778 762333 776289 777056 785582 787172 789273 792179 795684 795859 805668 805961 814228 821132 ] |
||||||||||||||||||||||||||||||
|
15.57 ms (8.59%) |
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 753854 754182 760931 748407 755968 760919 724193 728745 728755 732000 735951 742837 747147 753262 753333 753339 753395 753418 727824 731485 743232 747437 749343 749990 753360 756106 615005 709837 718719 787172 789273 388401 455888 536266 545717 575109 674980 678125 641950 428574 814228 540844 821132 515291 536245 529061 482526 552397 552629 656579 658728 670048 671529 671665 720397 652955 658837 660597 672070 694492 696160 717890 719376 720223 654346 671670 680230 691217 695993 722538 575606 597798 597823 603052 636049 640466 595478 595497 600146 619780 620805 590806 598544 621081 597029 598135 598754 624170 776289 795859 805961 777056 785582 792179 795684 725405 742833 746802 747519 752595 753818 754180 755634 758528 762333 805668 726164 741529 744907 747138 752721 753290 753294 761778 730346 747443 749329 753898 725549 742942 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (1.74%) |
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 388401 428574 455888 482526 515291 529061 536245 536266 540844 545717 552397 552629 575109 575606 590806 595478 595497 597029 597798 597823 598135 598544 598754 600146 603052 615005 619780 620805 621081 624170 636049 640466 641950 652955 654346 656579 658728 658837 660597 670048 671529 671665 671670 672070 674980 678125 680230 691217 694492 695993 696160 709837 717890 718719 719376 720223 720397 722538 724193 725405 725549 726164 727824 728745 728755 730346 731485 732000 735951 741529 742833 742837 742942 743232 744907 746802 747138 747147 747437 747443 747519 748407 749329 749343 749990 752595 752721 753262 753290 753294 753333 753339 753360 753395 753418 753818 753854 753898 754180 754182 755634 755968 756106 758528 760919 760931 761778 762333 776289 777056 785582 787172 789273 792179 795684 795859 805668 805961 814228 821132 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen hair"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen no hair"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen hair"
]
|
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.