Query Metrics
8
Database Queries
8
Different statements
212.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.48 ms (85.43%) |
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 198191 225519 384911 388202 395278 395642 395664 396519 398446 398862 402217 402735 413258 433216 434874 439281 439931 441073 441567 447137 447987 448756 450251 454532 454628 456567 457955 457978 461742 475250 478644 494409 503448 521145 529061 529116 532727 535006 536262 544858 548992 561012 572752 574969 575518 575606 579681 582708 587191 590165 590806 591841 594226 594389 595392 595446 595467 597071 598544 598754 600104 600118 612718 614253 620922 623968 629598 631612 641950 649198 650230 651974 654881 655184 656663 660349 663231 666871 670988 671652 674966 674980 680161 682942 683877 690322 694492 695156 695264 696966 709693 717235 718693 718719 722615 725144 728226 737150 740243 744907 749990 750316 753333 754182 757367 758528 760931 760963 761778 767070 777080 779737 785582 791782 795684 800554 800799 811925 828429 828442 ] |
||||||||||||||||||||||||||||||
|
17.59 ms (8.28%) |
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 579681 655184 660349 671652 651974 670988 690322 654881 683877 591841 595467 779737 754182 760931 753333 749990 718719 791782 395642 395278 548992 695264 663231 629598 595446 600104 718693 674980 641950 447987 439931 457978 544858 682942 225519 475250 722615 590165 594226 620922 725144 760963 384911 441567 448756 461742 454532 503448 572752 649198 623968 777080 757367 402735 398862 413258 456567 494409 828429 674966 535006 536262 529116 395664 612718 800554 728226 439281 447137 198191 402217 582708 396519 398446 529061 561012 650230 694492 717235 575606 590806 598544 598754 785582 795684 750316 758528 744907 761778 696966 737150 388202 433216 434874 450251 454628 631612 587191 595392 597071 600118 800799 457955 521145 478644 594389 709693 575518 574969 656663 614253 811925 740243 767070 666871 828442 532727 695156 441073 680161 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (1.48%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01ƾF[Ñr\x7FØ\x07À\x11lCù\x06"
]
|
||||||||||||||||||||||||||||||
|
2.36 ms (1.11%) |
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 198191 225519 384911 388202 395278 395642 395664 396519 398446 398862 402217 402735 413258 433216 434874 439281 439931 441073 441567 447137 447987 448756 450251 454532 454628 456567 457955 457978 461742 475250 478644 494409 503448 521145 529061 529116 532727 535006 536262 544858 548992 561012 572752 574969 575518 575606 579681 582708 587191 590165 590806 591841 594226 594389 595392 595446 595467 597071 598544 598754 600104 600118 612718 614253 620922 623968 629598 631612 641950 649198 650230 651974 654881 655184 656663 660349 663231 666871 670988 671652 674966 674980 680161 682942 683877 690322 694492 695156 695264 696966 709693 717235 718693 718719 722615 725144 728226 737150 740243 744907 749990 750316 753333 754182 757367 758528 760931 760963 761778 767070 777080 779737 785582 791782 795684 800554 800799 811925 828429 828442 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass teen"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп teen"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп teen"
]
|
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.