Query Metrics
7
Database Queries
7
Different statements
156.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.89 ms (85.63%) |
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 215337 308096 345974 382503 384266 397152 459822 512648 520609 531679 535549 537577 549913 557464 573104 574961 581008 583744 589508 604482 618510 624462 639966 640116 646041 650970 657787 660302 665749 679234 696281 704551 714249 718606 722162 732015 732903 735973 736909 739747 740850 743640 744769 745860 748085 748095 748122 749579 749982 752484 752852 754360 754482 754613 755228 755889 756847 757970 758019 758571 763470 764130 765955 771914 773791 777430 777460 778016 780180 780660 781113 781121 782779 783113 784926 785304 787739 795223 796000 796761 797527 801425 802399 805452 810368 811099 812338 816666 817085 817557 818431 818844 819066 819209 819229 819755 819778 819803 819828 820591 821769 822802 822883 823354 823560 823999 824134 825059 825342 825784 825923 826418 827085 827354 827556 827930 827989 828028 828725 828777 ] |
||||||||||||||||||||||||||||||
|
12.25 ms (7.83%) |
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 784926 744769 754482 758571 811099 748122 732015 752852 752484 755889 773791 764130 810368 345974 397152 819755 819066 822802 823999 817085 819229 535549 581008 557464 574961 660302 679234 657787 696281 549913 589508 604482 778016 739747 735973 736909 757970 732903 749579 754360 763470 740850 748095 755228 743640 754613 756847 618510 714249 777430 783113 801425 805452 308096 384266 512648 382503 818844 820591 826418 819209 821769 819778 819828 825784 823354 825059 827085 828725 520609 537577 531679 573104 583744 665749 646041 650970 718606 722162 639966 624462 795223 796000 802399 777460 781113 782779 812338 785304 787739 796761 797527 748085 749982 745860 765955 771914 758019 640116 704551 780180 780660 781121 215337 817557 816666 819803 827354 827556 822883 824134 818431 823560 825342 825923 827989 827930 828028 828777 459822 ] |
||||||||||||||||||||||||||||||
|
3.75 ms (2.40%) |
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 215337 308096 345974 382503 384266 397152 459822 512648 520609 531679 535549 537577 549913 557464 573104 574961 581008 583744 589508 604482 618510 624462 639966 640116 646041 650970 657787 660302 665749 679234 696281 704551 714249 718606 722162 732015 732903 735973 736909 739747 740850 743640 744769 745860 748085 748095 748122 749579 749982 752484 752852 754360 754482 754613 755228 755889 756847 757970 758019 758571 763470 764130 765955 771914 773791 777430 777460 778016 780180 780660 781113 781121 782779 783113 784926 785304 787739 795223 796000 796761 797527 801425 802399 805452 810368 811099 812338 816666 817085 817557 818431 818844 819066 819209 819229 819755 819778 819803 819828 820591 821769 822802 822883 823354 823560 823999 824134 825059 825342 825784 825923 826418 827085 827354 827556 827930 827989 828028 828725 828777 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot hot girl"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot hot девушк"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot hot девушк"
]
|
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.