Query Metrics
7
Database Queries
7
Different statements
204.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.58 ms (88.89%) |
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 3444 24363 131908 290150 387299 394610 396083 397089 397093 398773 402154 404731 417219 417740 426256 466881 469451 469571 471368 489678 495892 504010 509834 523390 528390 528493 533680 541525 542631 548320 548373 557406 558879 559427 562629 562676 568429 568451 568512 569476 569497 569511 577122 583534 584045 588389 590356 591770 594453 601076 601109 602605 602620 606106 606251 606298 606365 606374 606381 606400 606401 606402 606405 606426 606428 606431 606436 606619 606641 607472 613726 616448 618839 630246 637665 638792 649266 654945 660845 661899 666614 708203 709235 709756 710002 710302 714188 717948 721749 723681 729266 742067 746878 750331 755353 760697 761062 761076 766606 769517 769567 774054 786596 794517 794538 794547 795575 796860 800028 801933 804191 807885 810478 810612 814711 817070 817716 817722 818768 824090 ] |
||||||||||||||||||||||||||||||
|
12.06 ms (5.91%) |
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 810478 810612 746878 774054 396083 24363 814711 591770 794538 750331 795575 761062 638792 533680 541525 661899 649266 654945 606428 606431 637665 607472 666614 387299 824090 471368 601076 709235 495892 601109 817722 469571 569511 606251 606381 807885 769517 760697 804191 761076 131908 569476 548320 710002 397093 817070 466881 583534 606426 606402 794547 800028 796860 290150 542631 660845 562629 606619 618839 606365 590356 613726 606374 710302 509834 397089 404731 426256 709756 786596 606641 801933 394610 3444 489678 562676 569497 606400 588389 794517 729266 548373 558879 708203 606436 606106 766606 742067 594453 602620 402154 559427 568512 602605 568429 606298 606401 630246 755353 818768 398773 417740 417219 817716 469451 504010 523390 528390 528493 557406 568451 577122 717948 721749 714188 584045 616448 606405 723681 769567 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.36%) |
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 3444 24363 131908 290150 387299 394610 396083 397089 397093 398773 402154 404731 417219 417740 426256 466881 469451 469571 471368 489678 495892 504010 509834 523390 528390 528493 533680 541525 542631 548320 548373 557406 558879 559427 562629 562676 568429 568451 568512 569476 569497 569511 577122 583534 584045 588389 590356 591770 594453 601076 601109 602605 602620 606106 606251 606298 606365 606374 606381 606400 606401 606402 606405 606426 606428 606431 606436 606619 606641 607472 613726 616448 618839 630246 637665 638792 649266 654945 660845 661899 666614 708203 709235 709756 710002 710302 714188 717948 721749 723681 729266 742067 746878 750331 755353 760697 761062 761076 766606 769517 769567 774054 786596 794517 794538 794547 795575 796860 800028 801933 804191 807885 810478 810612 814711 817070 817716 817722 818768 824090 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"german домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"german homemade"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"german домашн любительск"
]
|
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.