Query Metrics
7
Database Queries
7
Different statements
200.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.94 ms (87.61%) |
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 385751 395709 396070 399994 405488 405501 408213 408581 409174 411958 417172 418669 433820 436578 438004 441656 451780 453533 456040 456948 457036 463716 464975 466874 468991 479518 479752 487729 498854 501451 505548 511378 512733 512745 515125 520320 533091 533924 540587 540808 546505 551525 553126 557729 558545 560369 564207 570109 580802 581442 584849 585729 587301 589607 590163 596260 600510 600912 601574 602634 616879 634312 636026 658193 665939 667270 676987 681776 684660 684980 692682 696493 709082 716819 730678 731071 732096 736985 738053 739042 740116 744367 744556 747625 747819 756252 757274 758763 764815 766616 775681 775999 779191 788763 791134 793482 794869 795489 798700 800181 801148 801676 802313 803757 804554 806019 807432 808786 809153 812704 813206 813765 820597 821322 821405 823320 824368 824576 828809 ] |
||||||||||||||||||||||||||||||
|
14.66 ms (7.30%) |
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 505548 558545 676987 585729 596260 636026 600510 812704 501451 828809 684660 441656 512745 801676 456040 479752 634312 766616 570109 809153 515125 793482 601574 824368 463716 487729 512733 692682 551525 731071 824576 520320 546505 681776 764815 788763 408581 667270 730678 409174 798700 740116 795489 823320 665939 590163 747625 385751 399994 533924 802313 732096 744556 580802 757274 395709 533091 560369 587301 600912 794869 800181 807432 821322 821405 553126 584849 739042 736985 540808 658193 772018 813206 758763 775681 779191 803757 716819 808786 744367 405488 820597 457036 511378 616879 791134 738053 433820 438004 396070 498854 540587 468991 696493 602634 747819 479518 411958 813765 557729 684980 775999 801148 436578 417172 453533 456948 564207 589607 709082 464975 466874 804554 756252 581442 408213 418669 405501 806019 451780 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.35%) |
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 385751 395709 396070 399994 405488 405501 408213 408581 409174 411958 417172 418669 433820 436578 438004 441656 451780 453533 456040 456948 457036 463716 464975 466874 468991 479518 479752 487729 498854 501451 505548 511378 512733 512745 515125 520320 533091 533924 540587 540808 546505 551525 553126 557729 558545 560369 564207 570109 580802 581442 584849 585729 587301 589607 590163 596260 600510 600912 601574 602634 616879 634312 636026 658193 665939 667270 676987 681776 684660 684980 692682 696493 709082 716819 730678 731071 732096 736985 738053 739042 740116 744367 744556 747625 747819 756252 757274 758763 764815 766616 775681 775999 779191 788763 791134 793482 794869 795489 798700 800181 801148 801676 802313 803757 804554 806019 807432 808786 809153 812704 813206 813765 820597 821322 821405 823320 824368 824576 828809 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ride on cock"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ride cock"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ride cock"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.81%) |
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.