Query Metrics
7
Database Queries
7
Different statements
174.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.83 ms (82.77%) |
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 96872 327421 383335 383439 385318 391477 395738 398528 402963 411897 417217 421954 422235 424797 425131 430348 438324 439667 442661 443842 443941 445199 450099 450198 454887 455411 462424 464443 464861 465329 466872 467426 468828 470389 470632 472910 476332 479985 484485 484970 486588 489721 490191 490394 490679 491962 493118 494437 502814 502882 503481 504459 505814 506760 509292 511529 512607 514736 515416 517567 518006 518877 519251 521355 521741 523019 523908 524934 525017 525089 526421 526646 530726 533331 538282 539495 542597 545060 545372 546966 549217 549238 550467 552817 563540 579557 580993 602018 615728 616996 617167 620320 628332 634138 652010 668949 688333 700812 709540 714166 717943 718461 724678 726940 731156 733365 734090 743813 745980 755173 761169 764186 782989 792904 793835 796155 797340 802065 802434 804524 ] |
||||||||||||||||||||||||||||||
|
21.17 ms (12.10%) |
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 422235 464443 796155 411897 438324 96872 518877 688333 530726 472910 398528 505814 443842 494437 542597 430348 503481 490679 563540 439667 443941 465329 417217 450099 782989 709540 402963 620320 602018 518006 391477 462424 761169 764186 395738 484485 519251 524934 425131 476332 652010 484970 634138 517567 525089 455411 579557 792904 383439 468828 525017 526421 489721 668949 552817 486588 442661 539495 580993 745980 755173 504459 424797 464861 514736 327421 515416 545372 523908 454887 802065 726940 797340 445199 538282 717943 724678 731156 466872 502814 526646 521355 421954 615728 470632 512607 470389 549238 743813 628332 546966 523019 700812 617167 493118 550467 714166 718461 549217 802434 734090 733365 616996 383335 450198 533331 793835 804524 502882 545060 385318 490394 490191 511529 506760 491962 509292 521741 467426 479985 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.33%) |
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 96872 327421 383335 383439 385318 391477 395738 398528 402963 411897 417217 421954 422235 424797 425131 430348 438324 439667 442661 443842 443941 445199 450099 450198 454887 455411 462424 464443 464861 465329 466872 467426 468828 470389 470632 472910 476332 479985 484485 484970 486588 489721 490191 490394 490679 491962 493118 494437 502814 502882 503481 504459 505814 506760 509292 511529 512607 514736 515416 517567 518006 518877 519251 521355 521741 523019 523908 524934 525017 525089 526421 526646 530726 533331 538282 539495 542597 545060 545372 546966 549217 549238 550467 552817 563540 579557 580993 602018 615728 616996 617167 620320 628332 634138 652010 668949 688333 700812 709540 714166 717943 718461 724678 726940 731156 733365 734090 743813 745980 755173 761169 764186 782989 792904 793835 796155 797340 802065 802434 804524 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"зрелых ебут в рот"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зрелая женщин секс в рот"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.77%) |
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.