Query Metrics
7
Database Queries
7
Different statements
218.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
196.91 ms (90.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 3522 271756 385600 388365 391667 391759 392181 396150 396254 396305 397166 397950 398314 398632 398746 408507 409701 412885 417267 424072 424087 427076 427850 429450 437767 437901 437911 443271 446239 451216 455597 459781 463722 469382 469388 472670 477063 481131 482888 489259 506339 506591 511852 511901 514632 516606 516998 552438 554521 554934 555121 558187 558949 559169 582709 587783 600581 600938 605001 606297 613878 620211 620240 627697 644396 648497 648612 656495 663325 666404 671236 675677 677511 694139 704952 710208 712525 713177 715774 727969 729657 733938 734515 738324 739632 744494 747220 748696 763146 763889 767553 768403 778734 779563 779599 784426 786921 787754 787806 789846 793360 794297 798259 799378 799419 799826 804775 805628 809329 811806 813556 816110 816805 817011 817019 819772 824114 825379 826066 826559 ] |
||||||||||||||||||||||||||||||
|
13.24 ms (6.06%) |
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 744494 472670 388365 437911 463722 469388 506591 514632 552438 656495 675677 694139 704952 713177 666404 587783 606297 789846 446239 427076 516606 671236 799826 437901 627697 767553 768403 729657 727969 811806 516998 506339 799419 511852 3522 391667 427850 469382 554934 558187 644396 779599 392181 554521 738324 763146 424072 398746 763889 712525 409701 600581 477063 824114 620240 489259 396305 398314 825379 819772 798259 805628 558949 817019 816805 817011 559169 677511 648497 648612 787806 779563 809329 715774 778734 437767 424087 397166 482888 443271 459781 271756 455597 804775 605001 398632 396150 408507 787754 391759 385600 733938 794297 620211 417267 739632 412885 663325 710208 816110 397950 793360 734515 826559 600938 481131 511901 613878 555121 582709 784426 786921 747220 748696 799378 826066 429450 396254 813556 451216 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.18%) |
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 3522 271756 385600 388365 391667 391759 392181 396150 396254 396305 397166 397950 398314 398632 398746 408507 409701 412885 417267 424072 424087 427076 427850 429450 437767 437901 437911 443271 446239 451216 455597 459781 463722 469382 469388 472670 477063 481131 482888 489259 506339 506591 511852 511901 514632 516606 516998 552438 554521 554934 555121 558187 558949 559169 582709 587783 600581 600938 605001 606297 613878 620211 620240 627697 644396 648497 648612 656495 663325 666404 671236 675677 677511 694139 704952 710208 712525 713177 715774 727969 729657 733938 734515 738324 739632 744494 747220 748696 763146 763889 767553 768403 778734 779563 779599 784426 786921 787754 787806 789846 793360 794297 798259 799378 799419 799826 804775 805628 809329 811806 813556 816110 816805 817011 817019 819772 824114 825379 826066 826559 ] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"deepthroat wife"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"глубокийминет минет оральн секс жен"
]
|
||||||||||||||||||||||||||||||
|
1.25 ms (0.57%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.21 ms (0.55%) |
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.