Query Metrics
7
Database Queries
7
Different statements
388.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.65 ms (54.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black hair"
]
|
||||||||||||||||||||||||||||||
|
156.32 ms (40.28%) |
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 27757 32874 37057 151163 386013 389317 390129 390318 413999 416951 417884 419413 432505 445043 459323 459325 464344 465474 468047 517181 519182 529887 530397 530557 533308 535816 536309 543894 544694 545359 552951 560304 571015 586021 597600 601096 603198 604588 605145 618285 623844 623964 624329 639315 642377 644246 661539 673767 686034 689161 696237 713820 716223 716581 721407 722534 726634 734049 735810 735848 735951 737674 737720 741306 741634 744261 744339 744468 744993 754923 755318 755592 756382 756510 759602 763152 764139 764175 768944 772755 774058 780625 780710 782861 783048 783935 785691 786749 786759 787885 789094 790815 791752 793243 797105 797387 803836 806121 806220 806460 806984 806992 807697 809956 811574 813799 814661 814667 817786 818281 822189 822559 822878 823332 824787 824900 824938 825899 826177 828758 ] |
||||||||||||||||||||||||||||||
|
13.50 ms (3.48%) |
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 713820 716223 721407 661539 689161 603198 624329 639315 605145 623964 642377 644246 586021 597600 601096 623844 786759 789094 806984 811574 780625 782861 785691 786749 790815 806992 809956 735810 737720 744339 744468 755592 783935 791752 797105 797387 803836 806121 806460 807697 735848 741306 755318 763152 741634 744993 754923 764139 764175 735951 737674 744261 756510 759602 726634 734049 756382 768944 772755 774058 604588 618285 716581 722534 780710 783048 787885 793243 806220 386013 390318 432505 416951 529887 390129 389317 151163 27757 37057 32874 413999 445043 417884 419413 822189 822559 824787 824938 826177 817786 813799 814661 818281 822878 823332 814667 824900 825899 828758 468047 459323 459325 465474 517181 519182 530397 530557 536309 533308 535816 464344 544694 552951 543894 571015 545359 560304 673767 686034 696237 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (0.83%) |
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 27757 32874 37057 151163 386013 389317 390129 390318 413999 416951 417884 419413 432505 445043 459323 459325 464344 465474 468047 517181 519182 529887 530397 530557 533308 535816 536309 543894 544694 545359 552951 560304 571015 586021 597600 601096 603198 604588 605145 618285 623844 623964 624329 639315 642377 644246 661539 673767 686034 689161 696237 713820 716223 716581 721407 722534 726634 734049 735810 735848 735951 737674 737720 741306 741634 744261 744339 744468 744993 754923 755318 755592 756382 756510 759602 763152 764139 764175 768944 772755 774058 780625 780710 782861 783048 783935 785691 786749 786759 787885 789094 790815 791752 793243 797105 797387 803836 806121 806220 806460 806984 806992 807697 809956 811574 813799 814661 814667 817786 818281 822189 822559 822878 823332 824787 824900 824938 825899 826177 828758 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black hair"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black 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.