Query Metrics
7
Database Queries
7
Different statements
164.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.96 ms (85.46%) |
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 61168 86796 118258 192814 192888 221091 310715 383095 384810 386595 387910 391687 396542 396566 398700 399364 402667 411367 421020 427515 443680 443685 457782 464343 476138 476426 484385 490160 510427 514942 517184 533523 536063 537400 543124 543950 545584 546485 547991 548523 549416 554811 559140 561046 565224 566447 586737 599525 601547 602684 603212 603620 606551 610780 622089 622119 622154 622613 623521 624985 635788 635874 644321 645064 645825 645880 653519 653915 656638 659780 663546 663939 667686 670514 671708 680871 694143 707287 708919 709415 709421 711896 715583 717233 719718 720834 721298 721568 722884 728742 732721 733148 733178 740797 742874 746421 754608 754659 759443 760060 762046 767162 770891 771029 771282 776206 781762 782036 784323 790971 793460 795133 805376 805403 817692 820523 823926 825279 827419 828257 ] |
||||||||||||||||||||||||||||||
|
13.67 ms (8.29%) |
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 767162 586737 443680 310715 828257 721568 622613 722884 411367 601547 384810 623521 599525 644321 443685 383095 827419 510427 754659 490160 221091 653915 771029 708919 795133 825279 565224 717233 399364 667686 602684 781762 805376 402667 86796 728742 118258 603620 663546 721298 421020 762046 464343 517184 476426 776206 192888 386595 546485 711896 61168 709415 537400 476138 457782 387910 547991 566447 645825 680871 707287 709421 645064 656638 549416 635874 606551 793460 782036 784323 759443 740797 719718 805403 733148 543124 514942 715583 645880 635788 760060 770891 484385 746421 733178 536063 663939 622089 622119 732721 603212 742874 396542 396566 533523 754608 543950 670514 671708 391687 559140 398700 823926 545584 554811 548523 561046 659780 653519 610780 624985 427515 192814 820523 817692 694143 720834 622154 771282 790971 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.51%) |
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 61168 86796 118258 192814 192888 221091 310715 383095 384810 386595 387910 391687 396542 396566 398700 399364 402667 411367 421020 427515 443680 443685 457782 464343 476138 476426 484385 490160 510427 514942 517184 533523 536063 537400 543124 543950 545584 546485 547991 548523 549416 554811 559140 561046 565224 566447 586737 599525 601547 602684 603212 603620 606551 610780 622089 622119 622154 622613 623521 624985 635788 635874 644321 645064 645825 645880 653519 653915 656638 659780 663546 663939 667686 670514 671708 680871 694143 707287 708919 709415 709421 711896 715583 717233 719718 720834 721298 721568 722884 728742 732721 733148 733178 740797 742874 746421 754608 754659 759443 760060 762046 767162 770891 771029 771282 776206 781762 782036 784323 790971 793460 795133 805376 805403 817692 820523 823926 825279 827419 828257 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bondage blowjob mmf"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бдсм минет оральн секс мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.08%) |
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.