Query Metrics
7
Database Queries
7
Different statements
180.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.00 ms (87.73%) |
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 392109 396944 408427 428781 446154 449472 456526 459024 466620 475203 482144 485611 489033 492038 493080 508207 516166 526023 527284 531918 532118 536065 545014 547223 561864 584944 591151 591601 599766 618040 619964 630112 635864 649625 650990 654614 661950 665993 666046 666152 668976 675551 685899 687962 692840 693776 694929 699428 701178 705083 705409 708156 710303 712250 714018 714956 717614 718448 720215 720881 721156 722276 722358 722442 725092 730776 733668 734413 734701 734978 735996 736120 736203 737537 740499 741076 742022 742074 743154 743632 744820 748766 749555 749714 750110 754375 756811 758680 761197 761670 765791 766171 766333 768255 770591 775169 775489 778166 778823 779615 780246 782298 784009 784777 785035 786202 791742 795336 796453 797878 798675 798778 801450 811660 825097 825975 826488 ] |
||||||||||||||||||||||||||||||
|
12.68 ms (7.04%) |
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 701178 705409 710303 712250 492038 527284 392109 778823 449472 526023 536065 693776 650990 665993 545014 584944 619964 798778 739943 778166 475203 428781 561864 396944 826488 825097 824550 825975 485611 531918 466620 482144 547223 649625 661950 692840 718448 722358 675551 714018 717614 722276 722442 666046 666152 708156 714956 591151 635864 782298 786202 796453 775169 797878 798675 811660 725092 742074 758680 785035 791742 734413 736203 744820 761197 766171 734978 740499 743632 750110 754375 768255 733668 736120 742022 743154 748766 749555 765791 730776 734701 735996 737537 749714 756811 761670 766333 770591 630112 720215 720881 721156 775489 779615 780246 784009 784777 795336 801450 459024 446154 408427 456526 493080 516166 668976 685899 687962 694929 618040 705083 654614 699428 591601 599766 754183 741076 489033 508207 532118 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.44%) |
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 392109 396944 408427 428781 446154 449472 456526 459024 466620 475203 482144 485611 489033 492038 493080 508207 516166 526023 527284 531918 532118 536065 545014 547223 561864 584944 591151 591601 599766 618040 619964 630112 635864 649625 650990 654614 661950 665993 666046 666152 668976 675551 685899 687962 692840 693776 694929 699428 701178 705083 705409 708156 710303 712250 714018 714956 717614 718448 720215 720881 721156 722276 722358 722442 725092 730776 733668 734413 734701 734978 735996 736120 736203 737537 740499 741076 742022 742074 743154 743632 744820 748766 749555 749714 750110 754375 756811 758680 761197 761670 765791 766171 766333 768255 770591 775169 775489 778166 778823 779615 780246 782298 784009 784777 785035 786202 791742 795336 796453 797878 798675 798778 801450 811660 825097 825975 826488 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade friend"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск friend"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск friend"
]
|
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.