Query Metrics
7
Database Queries
7
Different statements
198.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.77 ms (88.37%) |
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 384546 384823 386558 404054 432480 477746 529582 542643 543762 544905 548045 549909 549927 552568 564269 566465 569809 572112 574208 577527 596853 598592 600228 601564 601832 602114 617126 631297 633174 635021 636224 642456 645447 647817 648335 652524 664420 673017 675033 675783 681733 687802 693454 699661 701413 701976 704773 705313 713097 714088 716362 717674 718616 723712 724859 724991 725137 725773 731860 736372 737259 737288 737813 740283 740720 743511 743936 744063 744521 746677 748331 748977 753169 753178 753209 753405 754497 758870 758939 760582 760918 763472 768327 769194 769197 772570 773061 773142 777483 778182 778568 779251 779509 780550 782175 783884 785966 786818 786987 788503 790538 791793 795570 797606 800688 800941 801380 811094 817909 818414 819089 821374 824144 825006 825312 825526 826680 827164 828168 ] |
||||||||||||||||||||||||||||||
|
14.44 ms (7.26%) |
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 529582 548045 574208 543762 549927 569809 577527 564269 693454 699661 704773 648335 675033 705313 713097 652524 675783 544905 572112 602114 642456 596853 633174 601832 601564 631297 780550 786818 795570 800941 777483 779509 790538 811094 731860 736372 737259 737288 744063 760582 772570 773061 724991 737813 743936 744521 748331 740283 743511 746677 763472 724859 753405 778182 785966 797606 404054 432480 384546 386558 725137 819089 701976 600228 754497 817909 821374 825006 826137 826680 825526 827164 818414 825312 828168 824144 566465 542643 552568 647817 673017 687802 714088 645447 701413 716362 718616 664420 681733 549909 617126 635021 636224 788503 801380 779251 783884 723712 748977 753169 753178 753209 758939 768327 800688 740720 758870 769194 769197 760918 773142 725773 717674 778568 782175 786987 791793 477746 598592 384823 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.15%) |
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 384546 384823 386558 404054 432480 477746 529582 542643 543762 544905 548045 549909 549927 552568 564269 566465 569809 572112 574208 577527 596853 598592 600228 601564 601832 602114 617126 631297 633174 635021 636224 642456 645447 647817 648335 652524 664420 673017 675033 675783 681733 687802 693454 699661 701413 701976 704773 705313 713097 714088 716362 717674 718616 723712 724859 724991 725137 725773 731860 736372 737259 737288 737813 740283 740720 743511 743936 744063 744521 746677 748331 748977 753169 753178 753209 753405 754497 758870 758939 760582 760918 763472 768327 769194 769197 772570 773061 773142 777483 778182 778568 779251 779509 780550 782175 783884 785966 786818 786987 788503 790538 791793 795570 797606 800688 800941 801380 811094 817909 818414 819089 821374 824144 825006 825312 825526 826680 827164 828168 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot hot girl"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot hot девушк"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.67%) |
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.