Query Metrics
7
Database Queries
7
Different statements
245.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
222.38 ms (90.53%) |
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 33781 113755 268747 392984 405816 412627 423992 428886 433860 439446 439522 440928 449127 464056 464263 499231 499955 511387 520148 523791 534341 535335 536677 544727 547035 557486 561558 562822 567888 581376 588334 590313 593834 602576 604688 605094 606127 609220 627376 630836 634345 641528 643032 643321 650595 675123 675437 675675 693931 697716 715477 718878 723152 724155 724453 727909 728552 731057 732979 742089 742457 742611 748014 749384 751451 753251 753766 756522 758176 761314 764604 766265 766313 770158 774119 775274 777710 778781 785621 787355 793577 795735 796657 800414 801156 801750 802151 802966 813577 814026 815975 817143 817585 818364 818629 818771 819484 819815 820119 822522 823276 823685 823706 823799 823846 824337 824738 826206 826402 827937 828064 828497 828662 828715 828716 ] |
||||||||||||||||||||||||||||||
|
11.98 ms (4.88%) |
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 823706 823799 693931 439446 567888 33781 392984 113755 828305 499955 562822 602576 605094 547035 802151 764604 675123 405816 511387 523791 464263 561558 609220 770158 440928 464056 449127 412627 813577 820119 823276 817143 499231 697716 557486 818629 826206 815975 650595 630836 593834 606127 801750 787355 753251 766265 751451 761314 715477 826738 823685 822522 828064 828716 828715 814026 536677 590313 643321 641528 778781 785621 727909 731057 753766 766313 724155 758176 728552 742611 627376 793577 795735 423992 588334 742457 675675 634345 428886 826362 581376 535335 439522 433860 604688 819484 818771 824337 827937 520148 749384 742089 675437 775274 818364 268747 718878 756522 777710 796657 534341 544727 643032 774119 724453 819815 826402 823846 824738 828497 723152 801156 802966 748014 732979 800414 823734 817585 828662 828527 ] |
||||||||||||||||||||||||||||||
|
3.83 ms (1.56%) |
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 33781 113755 268747 392984 405816 412627 423992 428886 433860 439446 439522 440928 449127 464056 464263 499231 499955 511387 520148 523791 534341 535335 536677 544727 547035 557486 561558 562822 567888 581376 588334 590313 593834 602576 604688 605094 606127 609220 627376 630836 634345 641528 643032 643321 650595 675123 675437 675675 693931 697716 715477 718878 723152 724155 724453 727909 728552 731057 732979 742089 742457 742611 748014 749384 751451 753251 753766 756522 758176 761314 764604 766265 766313 770158 774119 775274 777710 778781 785621 787355 793577 795735 796657 800414 801156 801750 802151 802966 813577 814026 815975 817143 817585 818364 818629 818771 819484 819815 820119 822522 823276 823685 823706 823799 823846 824337 824738 826206 826402 827937 828064 828497 828662 828715 828716 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf panties"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.70%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.