Query Metrics
7
Database Queries
7
Different statements
161.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.28 ms (82.45%) |
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 79388 137159 369353 380962 382089 383976 387347 389730 391771 397403 410967 418249 418773 424009 425730 426723 427620 438686 440819 441806 449412 463604 464068 465671 466862 468897 470990 477357 478141 479573 484336 485478 485892 490752 495581 495787 496420 505877 507010 507810 511965 511996 513374 520935 521050 526387 529957 537757 539977 540720 541930 546089 553164 554294 554953 557833 558145 562219 563029 563673 564366 565007 565601 567544 571874 572712 573512 579515 583958 585067 585625 588916 589938 590307 603114 605225 607494 620060 641171 642962 643399 649936 656208 677847 694373 699277 700037 701257 704180 707549 716253 718862 723720 730741 734028 747240 750494 764189 767431 768197 768869 770173 775725 778521 779774 781028 785422 786291 788306 791424 793577 795415 796973 798820 801653 803591 805124 805693 812662 812713 ] |
||||||||||||||||||||||||||||||
|
16.06 ms (9.93%) |
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 513374 449412 565007 567544 677847 607494 812662 465671 418773 490752 507810 563029 438686 511965 563673 590307 571874 572712 747240 137159 718862 585625 588916 424009 418249 427620 781028 466862 554294 468897 505877 496420 521050 383976 788306 767431 387347 511996 79388 478141 564366 425730 441806 520935 380962 382089 389730 397403 426723 410967 585067 470990 495581 539977 526387 540720 463604 562219 565601 579515 541930 546089 557833 558145 694373 699277 701257 704180 707549 649936 656208 700037 553164 554953 573512 583958 589938 620060 643399 603114 642962 775725 779774 785422 801653 803591 805124 805693 786291 791424 795415 798820 734028 723720 750494 768869 770173 730741 764189 768197 605225 641171 716253 778521 793577 796973 812713 464068 391771 529957 485478 477357 507010 369353 440819 479573 484336 485892 495787 537757 ] |
||||||||||||||||||||||||||||||
|
4.55 ms (2.82%) |
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 79388 137159 369353 380962 382089 383976 387347 389730 391771 397403 410967 418249 418773 424009 425730 426723 427620 438686 440819 441806 449412 463604 464068 465671 466862 468897 470990 477357 478141 479573 484336 485478 485892 490752 495581 495787 496420 505877 507010 507810 511965 511996 513374 520935 521050 526387 529957 537757 539977 540720 541930 546089 553164 554294 554953 557833 558145 562219 563029 563673 564366 565007 565601 567544 571874 572712 573512 579515 583958 585067 585625 588916 589938 590307 603114 605225 607494 620060 641171 642962 643399 649936 656208 677847 694373 699277 700037 701257 704180 707549 716253 718862 723720 730741 734028 747240 750494 764189 767431 768197 768869 770173 775725 778521 779774 781028 785422 786291 788306 791424 793577 795415 796973 798820 801653 803591 805124 805693 812662 812713 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жену в своем"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен в сво"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен в сво"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.