Query Metrics
7
Database Queries
7
Different statements
398.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.34 ms (52.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"extreme gape anal"
]
|
||||||||||||||||||||||||||||||
|
166.63 ms (41.78%) |
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 89135 117755 118590 130060 182232 382410 384117 384397 387337 387720 396119 398940 401204 408613 411211 414337 416571 416597 416616 416682 420120 429600 429958 432274 439020 441081 441113 441120 441125 441354 443091 446095 448880 449068 452547 455080 455083 456190 456226 459198 460001 465618 468664 469250 470473 480470 481418 483762 491114 497692 510024 512072 512781 512935 512941 514258 518187 521559 525603 529795 529799 531250 531336 531871 531880 532530 534119 534557 539239 540685 545404 545449 547473 547852 559355 569656 600340 603830 614192 614966 619102 628416 636958 639731 641761 649218 656944 658789 660411 662850 666869 666968 669030 669054 670372 719500 723094 727180 739237 742353 752659 752664 752665 754207 766941 776059 780541 780650 782091 783364 793438 794310 796880 799786 800282 800318 801313 801606 803243 824915 ] |
||||||||||||||||||||||||||||||
|
15.48 ms (3.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 483762 398940 414337 603830 569656 619102 384397 752665 752664 416616 801606 441120 780650 600340 130060 455080 480470 512781 628416 636958 512941 793438 649218 666968 782091 669054 89135 387337 531336 540685 656944 547852 641761 799786 780541 801313 794310 800318 752659 723094 796880 800282 408613 824915 531871 545449 614192 766941 742353 118590 117755 382410 739237 384117 182232 420120 432274 429600 411211 416571 441354 468664 614966 776059 441081 439020 456226 459198 429958 497692 491114 783364 539239 547473 545404 639731 396119 416682 510024 719500 803243 754207 387720 401204 416597 559355 669030 660411 727180 456190 470473 481418 441125 443091 441113 465618 449068 452547 446095 448880 455083 469250 512072 529795 531250 534119 512935 529799 525603 514258 518187 521559 531880 532530 534557 460001 666869 670372 658789 662850 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (0.76%) |
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 89135 117755 118590 130060 182232 382410 384117 384397 387337 387720 396119 398940 401204 408613 411211 414337 416571 416597 416616 416682 420120 429600 429958 432274 439020 441081 441113 441120 441125 441354 443091 446095 448880 449068 452547 455080 455083 456190 456226 459198 460001 465618 468664 469250 470473 480470 481418 483762 491114 497692 510024 512072 512781 512935 512941 514258 518187 521559 525603 529795 529799 531250 531336 531871 531880 532530 534119 534557 539239 540685 545404 545449 547473 547852 559355 569656 600340 603830 614192 614966 619102 628416 636958 639731 641761 649218 656944 658789 660411 662850 666869 666968 669030 669054 670372 719500 723094 727180 739237 742353 752659 752664 752665 754207 766941 776059 780541 780650 782091 783364 793438 794310 796880 799786 800282 800318 801313 801606 803243 824915 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор большая большие дырк анал"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.