Query Metrics
7
Database Queries
7
Different statements
145.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.64 ms (85.44%) |
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 6602 131462 463596 512635 530294 532842 533225 533251 533389 535851 537539 540379 540873 543230 543244 543271 543899 543904 547676 551488 558981 562997 585172 587320 587577 589273 592130 594052 597456 601504 601832 602431 606330 615209 616432 618315 620440 623347 635878 638743 640384 642365 645972 646169 648478 650080 651167 651454 652627 654216 656226 659165 664707 666071 667241 668182 668822 669980 669988 675025 683636 688497 689354 692089 692136 692240 693507 697165 703692 704434 704489 717052 718111 721148 721714 724015 725443 729071 730124 730405 732815 734292 734580 734603 744365 746891 747572 750150 750234 754229 755142 755518 757654 767917 770074 771726 780688 789584 790831 791244 792808 793085 793658 797041 805706 807202 813367 817776 818233 818622 819357 824061 824534 826055 826286 828809 828813 ] |
||||||||||||||||||||||||||||||
|
11.18 ms (7.66%) |
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 463596 512635 530294 533389 535851 532842 533225 543244 543899 543271 562997 704489 547676 618315 594052 587320 780688 789584 790831 793658 797041 807202 813367 805706 724015 754229 770074 623347 6602 822687 828809 828813 721148 551488 693507 721714 601504 635878 597456 606330 734580 747572 767917 757654 771726 683636 793085 587577 131462 824061 540873 826055 817776 819357 824534 818622 818233 826286 540379 533251 537539 543230 543904 558981 648478 667241 669980 675025 689354 692136 645972 646169 650080 651167 651454 656226 658129 659165 668182 668822 688497 692240 703692 704434 652627 654216 664707 666071 669988 692089 697165 717052 718111 616432 640384 589273 602431 620440 639401 585172 592130 601832 642365 615209 638743 791244 792808 729071 755142 725443 730405 734292 746891 730124 732815 734603 744365 750150 750234 755518 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (2.17%) |
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 6602 131462 463596 512635 530294 532842 533225 533251 533389 535851 537539 540379 540873 543230 543244 543271 543899 543904 547676 551488 558981 562997 585172 587320 587577 589273 592130 594052 597456 601504 601832 602431 606330 615209 616432 618315 620440 623347 635878 638743 640384 642365 645972 646169 648478 650080 651167 651454 652627 654216 656226 659165 664707 666071 667241 668182 668822 669980 669988 675025 683636 688497 689354 692089 692136 692240 693507 697165 703692 704434 704489 717052 718111 721148 721714 724015 725443 729071 730124 730405 732815 734292 734580 734603 744365 746891 747572 750150 750234 754229 755142 755518 757654 767917 770074 771726 780688 789584 790831 791244 792808 793085 793658 797041 805706 807202 813367 817776 818233 818622 819357 824061 824534 826055 826286 828809 828813 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"riding жоп большие"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"riding ass big"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"riding жоп большие"
]
|
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.