Query Metrics
7
Database Queries
7
Different statements
602.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
578.27 ms (95.96%) |
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 7161 278428 357604 384911 393355 395454 403076 410402 413307 413982 414297 414421 414708 424817 425205 426105 441688 445577 445832 446703 449911 452191 453734 453760 457827 463102 463960 468424 468790 471541 472216 480114 480564 480664 481916 487584 487823 489278 493610 493754 506639 510496 511166 511185 514081 515721 517314 517624 517814 519808 520610 521182 522514 523891 524241 525168 525820 525990 526311 526340 528830 533595 533681 535429 537502 540587 543244 543500 554088 559491 564232 571114 577230 602067 621427 624419 625942 630043 630163 634191 637567 638503 642745 643406 645464 646137 655475 659701 676159 677971 680323 691542 699824 705796 708813 717150 720064 723754 724339 735419 737148 737219 737392 738458 738987 744348 750712 752154 752485 761051 761718 761728 765096 773062 784852 806159 808081 810424 815376 ] |
||||||||||||||||||||||||||||||
|
14.70 ms (2.44%) |
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 506639 523891 526311 520610 525820 510496 511166 511185 522514 487823 472216 493754 521182 517624 528830 445577 453734 543500 659701 395454 414297 403076 646137 717150 624419 737392 808081 765096 723754 737148 724339 737219 738987 724582 708813 810424 7161 533681 699824 630043 637567 735419 468790 564232 571114 554088 655475 705796 680323 691542 720064 677971 559491 602067 642745 625942 638503 621427 643406 784852 761051 744348 752485 761728 630163 634191 806159 815376 537502 645464 413307 481916 533595 750712 752154 489278 384911 278428 410402 425205 413982 414708 676159 457827 468424 463960 480564 445832 446703 449911 540587 514081 517814 519808 414421 441688 453760 463102 393355 452191 471541 480114 480664 517314 526340 525990 524241 493610 577230 424817 357604 738458 773062 525168 515721 543244 761718 487584 426105 535429 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (0.40%) |
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 7161 278428 357604 384911 393355 395454 403076 410402 413307 413982 414297 414421 414708 424817 425205 426105 441688 445577 445832 446703 449911 452191 453734 453760 457827 463102 463960 468424 468790 471541 472216 480114 480564 480664 481916 487584 487823 489278 493610 493754 506639 510496 511166 511185 514081 515721 517314 517624 517814 519808 520610 521182 522514 523891 524241 525168 525820 525990 526311 526340 528830 533595 533681 535429 537502 540587 543244 543500 554088 559491 564232 571114 577230 602067 621427 624419 625942 630043 630163 634191 637567 638503 642745 643406 645464 646137 655475 659701 676159 677971 680323 691542 699824 705796 708813 717150 720064 723754 724339 735419 737148 737219 737392 738458 738987 744348 750712 752154 752485 761051 761718 761728 765096 773062 784852 806159 808081 810424 815376 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big dick ass"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большой большие член жоп"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.25%) |
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.