Query Metrics
7
Database Queries
7
Different statements
161.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.66 ms (83.52%) |
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 96109 202134 384901 385348 385486 389973 394212 397889 402214 404913 407929 408292 410439 418331 419342 421139 421516 422704 422712 423209 424662 428113 431812 432889 437218 442771 443707 445623 446308 446415 450807 454159 467591 468946 469556 472835 474822 475690 476306 477374 478437 485132 499847 506028 510933 510948 512557 513528 518594 519625 522375 522485 523428 525761 529358 530429 548277 549240 550969 557993 560958 561991 561993 562043 572543 574237 576705 581281 581310 581386 583861 585357 592390 592403 592672 593821 596201 596373 596927 599651 604984 606732 618299 623485 630064 640097 644234 652007 654074 665484 665851 667875 670514 670772 671704 688594 690774 694505 698431 707512 710937 715372 726739 726862 727752 734664 746039 746325 758675 770570 781522 781765 788753 790918 797919 802276 802561 803833 807431 ] |
||||||||||||||||||||||||||||||
|
15.70 ms (9.74%) |
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 670514 671704 690774 694505 707512 715372 665484 665851 670772 688594 698431 710937 593821 596201 644234 585357 599651 640097 807431 781765 788753 790918 797919 802276 726739 734664 758675 803833 726862 727752 746039 746325 770570 772633 630064 781522 802561 422704 384901 202134 389973 423209 410439 418331 419342 421516 428113 432889 442771 450807 467591 445623 468946 478437 446308 499847 529358 525761 522375 469556 475690 550969 562043 583861 560958 581281 557993 574237 576705 581386 652007 654074 667875 548277 561991 561993 572543 581310 592390 606732 592672 596373 596927 618299 623485 604984 431812 385348 385486 394212 408292 437218 402214 96109 443707 446415 472835 404913 421139 424662 454159 522485 512557 523428 485132 506028 519625 474822 513528 407929 422712 518594 592403 397889 476306 477374 510933 510948 530429 549240 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.79%) |
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 96109 202134 384901 385348 385486 389973 394212 397889 402214 404913 407929 408292 410439 418331 419342 421139 421516 422704 422712 423209 424662 428113 431812 432889 437218 442771 443707 445623 446308 446415 450807 454159 467591 468946 469556 472835 474822 475690 476306 477374 478437 485132 499847 506028 510933 510948 512557 513528 518594 519625 522375 522485 523428 525761 529358 530429 548277 549240 550969 557993 560958 561991 561993 562043 572543 574237 576705 581281 581310 581386 583861 585357 592390 592403 592672 593821 596201 596373 596927 599651 604984 606732 618299 623485 630064 640097 644234 652007 654074 665484 665851 667875 670514 670772 671704 688594 690774 694505 698431 707512 710937 715372 726739 726862 727752 734664 746039 746325 758675 770570 781522 781765 788753 790918 797919 802276 802561 803833 807431 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy stockings"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая чулк нижн бел"
]
|
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.