Query Metrics
7
Database Queries
7
Different statements
156.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.98 ms (83.91%) |
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 388176 395526 397023 398831 412288 425523 430071 430570 433463 437330 437835 451013 452391 476909 489102 508996 512531 518403 518858 525354 525557 532110 532133 533469 534221 534845 536333 537386 552287 554522 565789 569835 591281 607557 609238 621721 623762 625435 636011 644027 646525 650683 664980 667660 690547 693256 695760 698187 698312 702904 705467 706339 710578 712707 714216 715270 715416 716262 717683 721575 725350 726620 728150 728642 736776 741323 744201 745256 751516 762174 778054 778465 778469 779421 787417 787965 788161 788319 788933 789737 789860 792310 793171 793499 793536 795430 795742 796576 796578 798926 799936 801723 802696 802818 803294 803762 804112 804218 804495 805679 805700 806181 806343 807366 807398 807476 807480 807499 807866 807946 808552 811263 811693 818802 820181 820761 823632 824563 825036 826160 ] |
||||||||||||||||||||||||||||||
|
13.09 ms (8.39%) |
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 751516 762174 621721 636011 644027 698187 779421 788319 793536 795742 798926 801723 802696 804218 805679 807476 395526 398831 397023 430071 412288 476909 518858 518403 534845 698312 569835 799936 609238 425523 430570 452391 451013 625435 802818 741323 792310 806181 388176 433463 437330 437835 823632 825036 826160 818802 820181 820761 824563 489102 533469 525557 532110 532133 536333 508996 512531 525354 534221 537386 565789 552287 646525 702904 715270 715416 716262 717683 664980 667660 690547 693256 695760 705467 710578 714216 650683 706339 712707 721575 554522 607557 623762 591281 778054 778465 778469 795430 803762 804495 806343 807366 807398 807499 811263 788933 796576 807866 725350 736776 744201 745256 787417 787965 788161 789737 789860 793171 793499 796578 803294 804112 805700 807480 807946 808552 811693 726620 728150 728642 ] |
||||||||||||||||||||||||||||||
|
3.82 ms (2.45%) |
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 388176 395526 397023 398831 412288 425523 430071 430570 433463 437330 437835 451013 452391 476909 489102 508996 512531 518403 518858 525354 525557 532110 532133 533469 534221 534845 536333 537386 552287 554522 565789 569835 591281 607557 609238 621721 623762 625435 636011 644027 646525 650683 664980 667660 690547 693256 695760 698187 698312 702904 705467 706339 710578 712707 714216 715270 715416 716262 717683 721575 725350 726620 728150 728642 736776 741323 744201 745256 751516 762174 778054 778465 778469 779421 787417 787965 788161 788319 788933 789737 789860 792310 793171 793499 793536 795430 795742 796576 796578 798926 799936 801723 802696 802818 803294 803762 804112 804218 804495 805679 805700 806181 806343 807366 807398 807476 807480 807499 807866 807946 808552 811263 811693 818802 820181 820761 823632 824563 825036 826160 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step boobs"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step boobs"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step boobs"
]
|
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.