Query Metrics
7
Database Queries
7
Different statements
151.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.60 ms (83.12%) |
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 540061 540075 540113 540121 540136 540140 540148 540326 540675 541741 541803 542180 542397 542450 542498 542719 544229 547406 553695 554709 554714 554717 554723 554733 554734 555261 555406 555421 555773 558910 558948 561025 562036 563977 567515 567725 575868 576580 577010 580984 582505 583057 583536 584987 593028 596972 599902 605080 605179 605248 606230 607312 607676 607714 621713 627233 628387 628535 630105 630519 631439 631898 632282 632635 634145 634810 637080 637163 640739 640856 641985 643656 646760 647844 649707 661591 664562 666045 666453 666914 667450 669538 670272 672324 676112 678135 679577 680118 680121 680172 680192 680778 690200 690215 695835 700919 743996 749025 752667 754477 758235 766348 775212 780884 790112 793466 797224 797230 801406 803691 803700 810526 812225 812230 812245 814165 814224 814318 819807 825968 ] |
||||||||||||||||||||||||||||||
|
14.18 ms (9.38%) |
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 628387 637080 670272 766348 607312 797230 540136 680118 580984 583536 542498 554723 561025 803700 803691 634810 567725 634145 576580 542719 562036 680172 627233 605179 540148 540061 555421 680778 700919 631898 797224 825968 628535 553695 667450 582505 593028 631439 812225 754477 812245 540326 814318 544229 554714 679577 554717 607676 641985 637163 630105 661591 666045 640856 819807 540140 690215 758235 632282 583057 664562 596972 775212 801406 646760 780884 541803 577010 647844 607714 810526 599902 676112 678135 554709 812230 743996 555261 555406 540121 558948 584987 541741 680192 680121 643656 752667 814165 814224 669538 690200 749025 640739 632635 567515 542397 555773 695835 672324 621713 793466 554733 605080 630519 605248 790112 540075 540113 540675 575868 542180 542450 554734 558910 563977 666453 666914 649707 547406 606230 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (2.17%) |
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 540061 540075 540113 540121 540136 540140 540148 540326 540675 541741 541803 542180 542397 542450 542498 542719 544229 547406 553695 554709 554714 554717 554723 554733 554734 555261 555406 555421 555773 558910 558948 561025 562036 563977 567515 567725 575868 576580 577010 580984 582505 583057 583536 584987 593028 596972 599902 605080 605179 605248 606230 607312 607676 607714 621713 627233 628387 628535 630105 630519 631439 631898 632282 632635 634145 634810 637080 637163 640739 640856 641985 643656 646760 647844 649707 661591 664562 666045 666453 666914 667450 669538 670272 672324 676112 678135 679577 680118 680121 680172 680192 680778 690200 690215 695835 700919 743996 749025 752667 754477 758235 766348 775212 780884 790112 793466 797224 797230 801406 803691 803700 810526 812225 812230 812245 814165 814224 814318 819807 825968 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"piss girls"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"писсинг девушк"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"писсинг девушк"
]
|
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.