Query Metrics
7
Database Queries
7
Different statements
157.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.55 ms (82.39%) |
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 390139 391861 397905 432324 438536 444911 455366 458999 470260 472362 475871 476535 483878 484014 488134 489994 492978 495968 497858 497993 499527 499750 500037 501969 502260 502852 504558 504665 505083 505762 506112 506719 508255 509250 509607 509614 511848 512647 512760 513276 516360 517247 517362 518091 519394 519434 521991 522305 522334 522583 522956 523943 524215 524576 525294 525489 525571 525581 527300 527618 527894 528490 529523 537819 538199 539356 542940 544043 546529 552151 555092 561247 561419 562298 563679 569433 570004 570269 574000 575694 575796 585895 591236 594608 595384 596997 613301 614682 620659 622796 623991 624081 626182 628661 630296 641026 642237 643573 653234 655539 664470 671245 672489 676438 677848 681522 686585 689798 692073 693327 696070 696769 697135 703589 711655 716195 716378 775538 813593 813612 ] |
||||||||||||||||||||||||||||||
|
17.48 ms (11.12%) |
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 455366 472362 475871 476535 509250 509614 512647 513276 516360 521991 523943 527618 528490 537819 489994 495968 499527 502852 504665 505083 506112 511848 517362 518091 522305 525294 527894 483878 492978 499750 500037 501969 502260 508255 512760 517247 519434 522583 522956 524576 525571 525581 527300 529523 484014 488134 497858 497993 504558 505762 506719 509607 519394 524215 538199 539356 397905 391861 390139 438536 432324 444911 813593 813612 458999 470260 522334 525489 575796 546529 561247 569433 570004 542940 544043 552151 561419 570269 575694 653234 655539 664470 676438 677848 696769 681522 692073 696070 671245 672489 686585 689798 693327 697135 703589 711655 716195 716378 555092 562298 563679 574000 594608 614682 620659 628661 642237 591236 626182 643573 585895 613301 630296 595384 596997 622796 623991 624081 641026 775538 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.98%) |
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 390139 391861 397905 432324 438536 444911 455366 458999 470260 472362 475871 476535 483878 484014 488134 489994 492978 495968 497858 497993 499527 499750 500037 501969 502260 502852 504558 504665 505083 505762 506112 506719 508255 509250 509607 509614 511848 512647 512760 513276 516360 517247 517362 518091 519394 519434 521991 522305 522334 522583 522956 523943 524215 524576 525294 525489 525571 525581 527300 527618 527894 528490 529523 537819 538199 539356 542940 544043 546529 552151 555092 561247 561419 562298 563679 569433 570004 570269 574000 575694 575796 585895 591236 594608 595384 596997 613301 614682 620659 622796 623991 624081 626182 628661 630296 641026 642237 643573 653234 655539 664470 671245 672489 676438 677848 681522 686585 689798 692073 693327 696070 696769 697135 703589 711655 716195 716378 775538 813593 813612 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русскый рот"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск рот"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.