Query Metrics
7
Database Queries
7
Different statements
179.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.69 ms (89.35%) |
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 417560 448089 451154 459752 466553 497859 498896 521218 528624 531596 538025 541306 544527 549292 555959 555963 555964 565775 577614 603546 616009 631299 636218 640361 641418 646437 652262 668397 680450 680989 681075 686088 693432 693926 698906 711828 714289 714693 715802 719108 726449 728884 728924 733217 737386 740064 740070 742456 742972 743058 743350 743955 744095 744540 747490 759794 760635 761253 767560 772360 772599 775595 775612 777133 779158 779360 786882 791789 794049 794413 795025 795087 799984 801116 801164 802716 803599 804395 804783 808021 811722 812323 815766 816397 817495 817655 818592 819388 819439 819987 820122 820149 820154 820317 823689 824077 824209 824339 824497 824542 824598 824790 824826 825128 825153 825158 825251 825803 825985 826348 826350 826769 826773 826876 826894 826951 827191 827269 827403 827577 ] |
||||||||||||||||||||||||||||||
|
9.87 ms (5.49%) |
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 794413 640361 680450 743350 544527 555959 497859 555964 531596 616009 541306 819388 538025 747490 804395 804783 801116 742972 698906 711828 824077 808021 646437 565775 826769 827403 775612 824598 824790 521218 498896 801164 779360 740070 743955 715802 820317 826876 820149 826350 825128 826894 824209 825251 636218 744540 555963 827269 786882 760635 631299 823689 825803 825985 817495 824497 818592 819439 819987 826348 652262 668397 714693 775595 799984 795025 795087 726449 777133 820122 577614 803599 728924 417560 815766 824826 825153 825158 826773 826951 827191 827577 816397 528624 686088 693432 719108 549292 779158 811722 812323 740064 742456 761253 794049 759794 772599 737386 728884 767560 791789 680989 681075 743058 641418 459752 451154 693926 714289 802716 772360 733217 744095 603546 448089 466553 817655 820154 824339 824542 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.37%) |
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 417560 448089 451154 459752 466553 497859 498896 521218 528624 531596 538025 541306 544527 549292 555959 555963 555964 565775 577614 603546 616009 631299 636218 640361 641418 646437 652262 668397 680450 680989 681075 686088 693432 693926 698906 711828 714289 714693 715802 719108 726449 728884 728924 733217 737386 740064 740070 742456 742972 743058 743350 743955 744095 744540 747490 759794 760635 761253 767560 772360 772599 775595 775612 777133 779158 779360 786882 791789 794049 794413 795025 795087 799984 801116 801164 802716 803599 804395 804783 808021 811722 812323 815766 816397 817495 817655 818592 819388 819439 819987 820122 820149 820154 820317 823689 824077 824209 824339 824497 824542 824598 824790 824826 825128 825153 825158 825251 825803 825985 826348 826350 826769 826773 826876 826894 826951 827191 827269 827403 827577 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy hair"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy hair"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy 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.