Query Metrics
7
Database Queries
7
Different statements
181.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.00 ms (88.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 92019 334950 382776 383495 384233 394433 398570 402046 409901 415544 418065 420475 429234 448060 466163 470842 483136 487902 504354 515245 516077 520688 522494 538732 556849 561725 564086 566925 568576 569663 570073 570074 574201 580347 582583 583262 590724 599670 606277 617435 618899 618913 621418 623209 623291 631762 635228 665032 665516 673547 673791 694600 697296 706909 714637 716032 722654 725372 726512 726698 726713 727513 730261 734679 736824 740331 741980 742953 743013 744298 745012 745844 746884 746958 748389 755380 758430 759656 759662 760619 762739 766574 770980 772110 772338 774109 778188 780440 785003 785269 786768 788292 789210 789304 790957 790966 798905 799948 800070 802871 803083 804052 804211 804221 806017 807380 810984 811814 812137 814065 814073 815170 817677 821585 823160 825141 825226 826235 826242 827975 ] |
||||||||||||||||||||||||||||||
|
12.53 ms (6.88%) |
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 556849 618899 618913 631762 786768 806017 740331 762739 772110 785269 746958 772338 745844 755380 736824 798905 799948 802871 92019 516077 334950 418065 815170 673791 706909 583262 590724 599670 623291 760619 726512 726713 790957 394433 826242 817677 825141 814065 825226 515245 665032 722654 665516 694600 574201 789210 789304 788292 804221 807380 725372 734679 743013 766574 774109 803083 759656 759662 742953 744298 714637 778188 780440 804211 398570 566925 570074 538732 504354 568576 716032 748389 487902 520688 384233 429234 470842 569663 570073 402046 415544 522494 582583 580347 673547 810984 382776 420475 448060 466163 409901 826235 827975 483136 561725 564086 697296 606277 635228 621418 785003 800070 726698 758430 804052 811814 730261 741980 727513 770980 745012 746884 617435 623209 790966 812137 383495 823160 814073 821585 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.34%) |
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 92019 334950 382776 383495 384233 394433 398570 402046 409901 415544 418065 420475 429234 448060 466163 470842 483136 487902 504354 515245 516077 520688 522494 538732 556849 561725 564086 566925 568576 569663 570073 570074 574201 580347 582583 583262 590724 599670 606277 617435 618899 618913 621418 623209 623291 631762 635228 665032 665516 673547 673791 694600 697296 706909 714637 716032 722654 725372 726512 726698 726713 727513 730261 734679 736824 740331 741980 742953 743013 744298 745012 745844 746884 746958 748389 755380 758430 759656 759662 760619 762739 766574 770980 772110 772338 774109 778188 780440 785003 785269 786768 788292 789210 789304 790957 790966 798905 799948 800070 802871 803083 804052 804211 804221 806017 807380 810984 811814 812137 814065 814073 815170 817677 821585 823160 825141 825226 826235 826242 827975 ] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old lick pussy"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old лиза pussy"
]
|
||||||||||||||||||||||||||||||
|
1.22 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old лиза pussy"
]
|
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.