Query Metrics
7
Database Queries
7
Different statements
181.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.15 ms (86.55%) |
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 311853 387422 395839 396317 405494 420326 420327 434379 436480 451539 455222 460776 495886 511199 524172 524313 534983 543381 543968 544252 544642 549089 550283 552274 558838 560459 562387 566445 584819 588143 593645 600544 603307 607024 607639 610620 617000 617590 618208 620425 624998 640727 647099 648984 649622 651420 659206 662411 668976 671000 671004 681107 682291 683484 693364 695773 698885 699317 700871 701296 701463 702088 707155 711013 711103 712714 717062 718964 719423 722876 723900 728642 728686 731315 731358 732592 732850 737537 749940 758035 758309 764922 766762 767318 777903 778145 778413 778763 783664 783677 786781 787089 787302 787406 791409 792277 792419 792571 795613 797090 797361 797794 799709 800012 800258 800751 801056 801074 801325 802882 804188 806049 807938 808258 809362 814717 817272 817463 821891 825949 ] |
||||||||||||||||||||||||||||||
|
14.10 ms (7.76%) |
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 700871 778763 787089 787302 800751 801325 807938 808258 809362 396317 543381 681107 610620 701463 549089 821891 543968 791409 544642 624998 617590 792277 671000 648984 566445 758035 711013 311853 558838 588143 436480 460776 817272 560459 668976 693364 659206 806049 723900 544252 651420 732850 731358 717062 671004 718964 804188 640727 552274 722876 617000 792571 455222 524172 524313 584819 719423 647099 562387 620425 778413 777903 786781 795613 758309 764922 434379 534983 550283 699317 712714 607639 797090 799709 767318 797794 801056 802882 728642 732592 766762 783664 787406 451539 511199 702088 600544 603307 405494 814717 662411 683484 698885 682291 593645 607024 618208 792419 778145 783677 749940 728686 707155 711103 801074 387422 420326 495886 395839 825949 817463 420327 797361 800258 731315 695773 701296 800012 737537 649622 ] |
||||||||||||||||||||||||||||||
|
3.54 ms (1.95%) |
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 311853 387422 395839 396317 405494 420326 420327 434379 436480 451539 455222 460776 495886 511199 524172 524313 534983 543381 543968 544252 544642 549089 550283 552274 558838 560459 562387 566445 584819 588143 593645 600544 603307 607024 607639 610620 617000 617590 618208 620425 624998 640727 647099 648984 649622 651420 659206 662411 668976 671000 671004 681107 682291 683484 693364 695773 698885 699317 700871 701296 701463 702088 707155 711013 711103 712714 717062 718964 719423 722876 723900 728642 728686 731315 731358 732592 732850 737537 749940 758035 758309 764922 766762 767318 777903 778145 778413 778763 783664 783677 786781 787089 787302 787406 791409 792277 792419 792571 795613 797090 797361 797794 799709 800012 800258 800751 801056 801074 801325 802882 804188 806049 807938 808258 809362 814717 817272 817463 821891 825949 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob friend"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс friend"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс friend"
]
|
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.