Query Metrics
7
Database Queries
7
Different statements
365.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.40 ms (58.32%) |
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 325595 384238 399520 401343 404059 408415 414710 415360 418421 418484 423260 425939 428018 432157 443150 443308 444935 445052 445363 451595 458397 463262 463954 464275 465805 465823 469921 470633 470839 472439 472912 474626 475089 475166 477216 482966 483135 484127 484851 484984 488302 489548 495035 500077 506445 511523 513304 513326 515189 515224 519725 529564 538203 540912 550439 560439 560583 560619 564602 565100 567149 567670 569659 569660 569672 574794 575151 575514 575729 575819 576352 576380 577320 579279 585942 587527 594929 596543 596669 598013 606731 609144 614962 617722 618887 622682 653523 665496 680156 683598 701498 736920 744316 813685 814082 814141 814513 819585 819598 820563 820617 820814 820838 821200 821369 821843 821858 821868 822024 822142 822828 822855 822948 823238 823300 823479 824090 825491 825629 827233 ] |
||||||||||||||||||||||||||||||
|
129.05 ms (35.27%) |
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 325595 384238 399520 401343 404059 408415 414710 415360 418421 418484 423260 425939 428018 432157 443150 443308 444935 445052 445363 451595 458397 463262 463954 464275 465805 465823 469921 470633 470839 472439 472912 474626 475089 475166 477216 482966 483135 484127 484851 484984 488302 489548 495035 500077 506445 511523 513304 513326 515189 515224 519725 529564 538203 540912 550439 560439 560583 560619 564602 565100 567149 567670 569659 569660 569672 574794 575151 575514 575729 575819 576352 576380 577320 579279 585942 587527 594929 596543 596669 598013 606731 609144 614962 617722 618887 622682 653523 665496 680156 683598 701498 736920 744316 813685 814082 814141 814513 819585 819598 820563 820617 820814 820838 821200 821369 821843 821858 821868 822024 822142 822828 822855 822948 823238 823300 823479 824090 825491 825629 827233 ] |
||||||||||||||||||||||||||||||
|
16.29 ms (4.45%) |
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 665496 560619 574794 576352 577320 579279 585942 596669 587527 594929 598013 606731 596543 736920 463262 475089 443308 474626 399520 428018 443150 445363 469921 401343 470633 477216 458397 513304 529564 482966 488302 511523 513326 483135 484984 519725 538203 444935 432157 418484 565100 567670 575151 575514 575729 550439 569659 575819 576380 560439 567149 653523 701498 683598 680156 560583 564602 569660 569672 609144 617722 618887 744316 622682 404059 415360 445052 465805 465823 418421 414710 472439 475166 451595 463954 464275 470839 472912 500077 489548 506445 484127 515224 484851 495035 515189 540912 614962 384238 325595 423260 425939 408415 813685 814082 814513 819585 820617 821868 822828 823300 824090 825629 819598 820814 820838 821369 821843 822024 825491 827233 814141 820563 821200 821858 822142 822855 822948 823238 823479 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"shaved young"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бритая young"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бритая young"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.42%) |
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.