Query Metrics
7
Database Queries
7
Different statements
165.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.98 ms (87.78%) |
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 69842 160525 288510 512777 515321 529725 530299 532177 533215 534510 536574 538075 540606 543284 549202 561544 563962 565472 568797 587945 595044 597049 613338 619332 626100 629979 630093 634599 635793 638505 639165 641219 641888 646359 648002 648660 648872 649338 651673 651830 652762 664506 664617 669553 672802 679578 683281 691535 694038 695054 695076 700894 702240 704412 704595 704616 708064 710599 713019 713862 719962 726397 731134 731141 734005 735841 739706 742267 743794 745995 746600 748439 749272 761444 763297 764362 766976 769203 769389 773145 775631 777535 780180 780617 781035 782631 786987 787195 787269 787741 790633 792450 792459 792482 792495 792968 793154 793731 793935 795105 795797 799787 802079 802099 811799 811809 813439 816165 816706 817387 818560 818735 824973 825111 826191 826240 826933 828337 828850 ] |
||||||||||||||||||||||||||||||
|
10.51 ms (6.36%) |
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 793731 69842 813439 533215 561544 565472 648660 694038 704616 719962 626100 639165 782631 731134 811809 595044 630093 745995 775631 795797 826240 780180 828337 726397 826191 695076 766976 824973 816706 826933 816165 787741 799787 792968 761444 792450 763297 777535 787195 731141 818560 792459 792495 802099 748439 767894 795105 288510 651830 664617 700894 587945 634599 811799 743794 629979 828850 664506 793935 538075 540606 549202 543284 648872 683281 695054 597049 641219 735841 787269 792482 613338 734005 818735 793154 773145 749272 532177 536574 529725 764362 530299 708064 638505 512777 534510 651673 635793 769203 739706 619332 817387 825111 780617 781035 790633 769389 742267 786987 802079 160525 746600 641888 515321 568797 563962 669553 679578 702240 652762 672802 691535 704412 704595 710599 713019 713862 646359 648002 649338 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.68%) |
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 69842 160525 288510 512777 515321 529725 530299 532177 533215 534510 536574 538075 540606 543284 549202 561544 563962 565472 568797 587945 595044 597049 613338 619332 626100 629979 630093 634599 635793 638505 639165 641219 641888 646359 648002 648660 648872 649338 651673 651830 652762 664506 664617 669553 672802 679578 683281 691535 694038 695054 695076 700894 702240 704412 704595 704616 708064 710599 713019 713862 719962 726397 731134 731141 734005 735841 739706 742267 743794 745995 746600 748439 749272 761444 763297 764362 766976 769203 769389 773145 775631 777535 780180 780617 781035 782631 786987 787195 787269 787741 790633 792450 792459 792482 792495 792968 793154 793731 793935 795105 795797 799787 802079 802099 811799 811809 813439 816165 816706 817387 818560 818735 824973 825111 826191 826240 826933 828337 828850 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк член любительск"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"handjob amateur"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.82%) |
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.