Query Metrics
7
Database Queries
7
Different statements
194.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.66 ms (88.60%) |
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 401525 401872 468895 539571 541304 543752 551515 552532 556745 559669 572089 572434 579507 585821 586205 590182 597764 615171 623006 631106 634975 637614 648043 651835 652927 654492 654583 654732 655055 655388 656085 656696 657096 657105 657316 657594 658006 658278 658625 667755 677129 677213 679115 679694 683538 691662 692032 692117 694600 695758 705313 710599 710909 711070 716035 716964 716989 717650 718243 719546 720039 720191 722093 725320 729293 729871 732564 733662 734795 736228 736504 736643 742245 747270 747351 748841 754064 754409 761682 763472 766422 766885 768699 771040 771915 777183 778574 780550 780975 782340 782718 782991 784914 785808 788912 790333 792751 797257 797311 799780 800576 810419 814502 816679 817013 819184 819687 822234 824290 824876 825834 825838 826418 826457 826852 827361 827580 827900 827962 ] |
||||||||||||||||||||||||||||||
|
12.25 ms (6.28%) |
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 771915 742245 748841 817013 822234 816679 825838 551515 552532 559669 543752 572434 655055 655388 677129 677213 717650 657316 658006 667755 691662 692117 705313 710599 716964 651835 718243 720039 586205 590182 597764 780550 782340 799780 800576 810419 729293 734795 761682 782991 792751 766885 736504 736643 747351 754064 729871 747270 754409 763472 725320 771040 637614 784914 785808 797257 401872 401525 814502 819687 824290 541304 656696 654583 782718 736228 766422 788912 768699 631106 710909 824876 826418 825834 826457 827580 819184 824210 827900 468895 722093 720191 634975 615171 797311 777183 780975 790333 732564 733662 711070 826852 827962 827361 539571 572089 579507 648043 656085 657096 657105 679115 683538 695758 719546 652927 654492 658625 679694 654732 657594 658278 692032 694600 716035 716989 556745 585821 623006 778574 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.50%) |
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 401525 401872 468895 539571 541304 543752 551515 552532 556745 559669 572089 572434 579507 585821 586205 590182 597764 615171 623006 631106 634975 637614 648043 651835 652927 654492 654583 654732 655055 655388 656085 656696 657096 657105 657316 657594 658006 658278 658625 667755 677129 677213 679115 679694 683538 691662 692032 692117 694600 695758 705313 710599 710909 711070 716035 716964 716989 717650 718243 719546 720039 720191 722093 725320 729293 729871 732564 733662 734795 736228 736504 736643 742245 747270 747351 748841 754064 754409 761682 763472 766422 766885 768699 771040 771915 777183 778574 780550 780975 782340 782718 782991 784914 785808 788912 790333 792751 797257 797311 799780 800576 810419 814502 816679 817013 819184 819687 822234 824290 824876 825834 825838 826418 826457 826852 827361 827580 827900 827962 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hard girls"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hard девушк"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hard девушк"
]
|
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.