Query Metrics
7
Database Queries
7
Different statements
181.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.49 ms (87.33%) |
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 382812 387627 396176 396966 399633 402419 404059 406288 407760 408708 409166 411858 428068 444834 448927 455180 462749 464275 465128 475166 489430 489548 492649 497337 503935 506445 515224 519994 524451 531409 531462 531502 532153 532979 536270 540912 550439 550449 561731 569665 569683 570061 571210 575088 576023 589616 590285 590732 596360 600384 612861 612946 620557 622622 622682 628301 664828 665381 665490 665694 677934 679124 684088 684304 684947 685686 687241 689272 689591 699674 706673 709732 709841 712712 712907 715138 715722 716450 718929 721519 722889 724710 725399 726640 727759 731326 732127 734613 741646 748138 748159 750410 753482 755975 757020 761005 775630 776915 790640 798589 807497 807610 807920 807968 813835 814079 814122 814143 816784 818505 819980 820695 821038 821344 821443 821585 822301 823000 827957 ] |
||||||||||||||||||||||||||||||
|
12.73 ms (7.01%) |
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 712907 741646 750410 732127 748138 748159 753482 726640 628301 709841 715138 798589 396966 409166 444834 497337 489430 402419 387627 396176 399633 406288 821344 813835 821585 820695 821926 823000 821443 519994 531502 532979 532153 536270 524451 531409 665694 677934 718929 684947 689591 699674 706673 590732 612946 807920 790640 757020 734613 755975 727759 715722 776915 382812 550449 569683 571210 684088 689272 665381 569665 612861 724710 761005 722889 465128 462749 503935 550439 807497 622682 404059 408708 455180 475166 464275 489548 506445 515224 540912 492649 576023 575088 561731 665490 570061 596360 731326 411858 428068 407760 819980 822301 814122 814143 818505 816784 814079 821038 827957 448927 531462 679124 684304 709732 712712 716450 685686 664828 687241 721519 590285 589616 600384 620557 622622 775630 807610 725399 807968 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.60%) |
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 382812 387627 396176 396966 399633 402419 404059 406288 407760 408708 409166 411858 428068 444834 448927 455180 462749 464275 465128 475166 489430 489548 492649 497337 503935 506445 515224 519994 524451 531409 531462 531502 532153 532979 536270 540912 550439 550449 561731 569665 569683 570061 571210 575088 576023 589616 590285 590732 596360 600384 612861 612946 620557 622622 622682 628301 664828 665381 665490 665694 677934 679124 684088 684304 684947 685686 687241 689272 689591 699674 706673 709732 709841 712712 712907 715138 715722 716450 718929 721519 722889 724710 725399 726640 727759 731326 732127 734613 741646 748138 748159 750410 753482 755975 757020 761005 775630 776915 790640 798589 807497 807610 807920 807968 813835 814079 814122 814143 816784 818505 819980 820695 821038 821344 821443 821585 822301 823000 827957 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young big pussy"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young большие pussy"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young большие pussy"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.88%) |
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.