Query Metrics
7
Database Queries
7
Different statements
157.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.42 ms (83.24%) |
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 412429 416086 425748 432742 436005 436392 438708 444134 447275 447902 451223 456960 457069 457964 458244 458432 459684 461554 462352 463146 467208 468963 470317 472608 473789 475015 476519 476521 476595 476972 477121 478337 478402 478725 479207 480993 487153 488196 488201 488618 489614 489792 492501 492775 496301 497047 497197 500923 503117 503317 505189 505423 505932 506118 507428 510567 510616 510721 512992 515781 521528 522458 524706 525960 527175 531543 539289 542046 542052 544042 544104 544564 548704 550826 552146 552782 553957 559677 560478 566911 566970 567091 570087 580685 582872 582932 584162 586558 592093 592143 592975 595546 598965 599045 599297 601910 603669 604052 606297 607040 617122 618101 621267 635689 638605 639190 650528 659501 665366 665415 675492 697010 719837 745827 758024 758099 758381 778297 787544 794774 ] |
||||||||||||||||||||||||||||||
|
17.57 ms (11.13%) |
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 598965 638605 599297 621267 607040 592143 606297 758024 639190 473789 416086 476595 477121 510721 488196 505423 472608 458432 478402 515781 542052 544042 544564 552146 553957 552782 580685 542046 544104 559677 659501 719837 617122 618101 595546 592093 758099 412429 478725 480993 438708 459684 468963 478337 505189 489614 492501 436005 447275 456960 447902 457964 497047 525960 531543 521528 539289 496301 548704 582872 582932 650528 665415 675492 560478 570087 599045 603669 604052 586558 758381 787544 462352 463146 475015 479207 432742 436392 470317 461554 522458 488201 489792 507428 527175 458244 505932 500923 566970 567091 550826 584162 665366 566911 592975 601910 635689 778297 794774 745827 697010 457069 476519 425748 444134 476972 476521 503117 487153 510567 488618 503317 510616 524706 512992 451223 467208 492775 506118 497197 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.56%) |
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 412429 416086 425748 432742 436005 436392 438708 444134 447275 447902 451223 456960 457069 457964 458244 458432 459684 461554 462352 463146 467208 468963 470317 472608 473789 475015 476519 476521 476595 476972 477121 478337 478402 478725 479207 480993 487153 488196 488201 488618 489614 489792 492501 492775 496301 497047 497197 500923 503117 503317 505189 505423 505932 506118 507428 510567 510616 510721 512992 515781 521528 522458 524706 525960 527175 531543 539289 542046 542052 544042 544104 544564 548704 550826 552146 552782 553957 559677 560478 566911 566970 567091 570087 580685 582872 582932 584162 586558 592093 592143 592975 595546 598965 599045 599297 601910 603669 604052 606297 607040 617122 618101 621267 635689 638605 639190 650528 659501 665366 665415 675492 697010 719837 745827 758024 758099 758381 778297 787544 794774 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"stranger секс"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stranger fuck"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"stranger секс"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.89%) |
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.