Query Metrics
7
Database Queries
7
Different statements
219.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
193.82 ms (88.32%) |
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 366321 381776 384560 391561 395667 395892 397475 400426 404633 429342 447490 456201 463809 463873 463937 466987 468772 472248 491286 492067 494692 515140 516615 518472 519472 520312 521588 529117 529152 531090 544784 562626 563618 565249 565255 570074 574897 583654 595853 598057 598067 598723 603077 605610 606178 624464 628388 628409 628441 637023 637134 641006 648583 657070 663882 664808 666868 667268 670394 671619 678806 680154 682494 682511 684197 685948 693075 694075 696977 696978 696995 697374 701010 701846 702164 702439 702927 707276 707312 708457 714428 715228 715920 716161 720400 720506 722738 722889 722915 727656 731994 739007 742197 744303 744329 748128 752722 759575 759639 760991 761005 763887 767223 768120 771168 774178 779704 784600 786769 799948 806324 807536 809652 810838 812351 813659 814123 818220 821667 827642 ] |
||||||||||||||||||||||||||||||
|
14.45 ms (6.59%) |
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 468772 694075 671619 595853 759639 397475 515140 693075 702927 521588 366321 814123 813659 818220 827642 529152 563618 670394 678806 682511 715228 720400 685948 696978 701846 624464 628441 605610 810838 727656 759575 767223 807536 809652 744303 739007 768120 771168 606178 715920 786769 395667 395892 400426 447490 680154 598067 516615 381776 722738 742197 463937 544784 565255 702164 648583 637134 598057 637023 628388 628409 603077 472248 519472 518472 731994 779704 714428 707312 744329 748128 774178 583654 598723 384560 492067 491286 494692 697374 720506 701010 570074 404633 664808 682494 702439 707276 708457 657070 684197 784600 641006 716161 391561 821667 667268 696977 663882 812351 752722 760991 763887 799948 666868 529117 696995 722915 761005 722889 429342 456201 466987 520312 531090 562626 565249 574897 806324 463809 463873 ] |
||||||||||||||||||||||||||||||
|
3.23 ms (1.47%) |
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 366321 381776 384560 391561 395667 395892 397475 400426 404633 429342 447490 456201 463809 463873 463937 466987 468772 472248 491286 492067 494692 515140 516615 518472 519472 520312 521588 529117 529152 531090 544784 562626 563618 565249 565255 570074 574897 583654 595853 598057 598067 598723 603077 605610 606178 624464 628388 628409 628441 637023 637134 641006 648583 657070 663882 664808 666868 667268 670394 671619 678806 680154 682494 682511 684197 685948 693075 694075 696977 696978 696995 697374 701010 701846 702164 702439 702927 707276 707312 708457 714428 715228 715920 716161 720400 720506 722738 722889 722915 727656 731994 739007 742197 744303 744329 748128 752722 759575 759639 760991 761005 763887 767223 768120 771168 774178 779704 784600 786769 799948 806324 807536 809652 810838 812351 813659 814123 818220 821667 827642 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс teen young"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck teen young"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс teen young"
]
|
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.