Query Metrics
7
Database Queries
7
Different statements
155.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.31 ms (84.27%) |
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 475682 524951 538912 538937 541589 541637 543502 544249 544318 544571 544586 544855 546776 549764 549784 550317 550320 551939 554351 557511 558004 559057 559066 561993 563419 564467 566371 567388 567932 571441 573761 574265 576680 576683 579304 581274 581394 582342 586919 589692 589817 590696 590928 591641 591678 592003 592390 592438 592453 592486 592636 595735 597031 606290 615255 615565 617648 620163 620170 621308 621698 622364 622378 623934 624789 638631 644301 644314 644359 646336 649091 649191 649196 650853 651604 661903 664157 670274 671713 671739 671741 671756 671757 671763 672372 672742 677707 677730 681782 683297 684030 690822 690868 691992 692315 692786 692812 693030 694179 694181 694374 696351 697229 698457 699596 703540 709624 716244 716572 716746 717862 717873 720379 720726 721834 722211 784247 790827 801322 817298 ] |
||||||||||||||||||||||||||||||
|
14.68 ms (9.42%) |
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 716572 716746 721834 790827 801322 524951 621698 582342 817298 475682 538912 538937 543502 544318 544571 544855 549784 581274 541589 541637 544586 550320 557511 559057 563419 564467 573761 576680 576683 544249 551939 554351 558004 559066 566371 567388 567932 571441 574265 581394 649191 661903 664157 671756 671763 672372 672742 677707 690822 694181 699596 717862 646336 649196 650853 670274 671739 690868 691992 693030 694179 696351 698457 709624 716244 717873 720726 649091 651604 671713 671741 671757 677730 681782 683297 684030 692315 692786 692812 694374 697229 703540 720379 722211 546776 549764 550317 561993 579304 591641 592390 592453 592486 595735 622378 589817 590928 592003 615565 622364 624789 644359 591678 592438 592636 615255 617648 620170 621308 623934 644314 586919 589692 590696 597031 606290 620163 638631 644301 784247 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.69%) |
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 475682 524951 538912 538937 541589 541637 543502 544249 544318 544571 544586 544855 546776 549764 549784 550317 550320 551939 554351 557511 558004 559057 559066 561993 563419 564467 566371 567388 567932 571441 573761 574265 576680 576683 579304 581274 581394 582342 586919 589692 589817 590696 590928 591641 591678 592003 592390 592438 592453 592486 592636 595735 597031 606290 615255 615565 617648 620163 620170 621308 621698 622364 622378 623934 624789 638631 644301 644314 644359 646336 649091 649191 649196 650853 651604 661903 664157 670274 671713 671739 671741 671756 671757 671763 672372 672742 677707 677730 681782 683297 684030 690822 690868 691992 692315 692786 692812 693030 694179 694181 694374 696351 697229 698457 699596 703540 709624 716244 716572 716746 717862 717873 720379 720726 721834 722211 784247 790827 801322 817298 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"boobs ретр"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boobs retro"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"boobs ретр"
]
|
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.