Query Metrics
7
Database Queries
7
Different statements
195.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.51 ms (85.48%) |
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 385104 386725 386824 396770 397420 404391 411046 420333 424141 425529 428955 433904 435798 442997 445801 446032 448699 454290 464064 470721 476303 477907 483853 485535 486323 489613 501476 504553 508946 509430 509471 518305 530323 530565 530652 530980 532696 541655 542980 547406 548263 549256 549984 550495 554243 554679 558261 559002 561954 569160 569558 570091 574798 575847 575868 576035 576761 581617 584922 589659 594820 596736 596997 599829 605698 609505 615983 629309 635720 636494 654920 660683 662521 668270 680774 684895 688386 688887 689252 691026 693311 694923 694962 695014 700842 701634 706545 706844 712707 716751 717079 717459 721942 726214 732087 736388 739604 740934 744916 748495 758379 762215 768431 771849 776930 781255 793576 797175 797364 800139 802196 804829 805034 810092 811541 813168 813729 813769 813818 ] |
||||||||||||||||||||||||||||||
|
17.60 ms (8.98%) |
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 501476 397420 445801 483853 446032 576035 559002 581617 548263 554243 684895 574798 615983 740934 732087 428955 477907 425529 435798 396770 489613 485535 549256 530565 386824 420333 813818 464064 448699 454290 509471 542980 550495 575847 691026 694923 695014 721942 569558 576761 589659 599829 609505 596997 797175 804829 802196 758379 726214 744916 810092 508946 486323 442997 558261 433904 424141 509430 813769 532696 575868 668270 547406 549984 775142 811541 561954 605698 813729 530980 530652 554679 706545 689252 800139 748495 629309 793576 570091 541655 584922 768431 762215 781255 594820 411046 504553 385104 386725 404391 470721 476303 518305 530323 569160 688887 716751 717459 660683 662521 693311 694962 717079 654920 680774 688386 700842 701634 706844 712707 596736 636494 635720 776930 805034 797364 813168 736388 771849 739604 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (1.68%) |
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 385104 386725 386824 396770 397420 404391 411046 420333 424141 425529 428955 433904 435798 442997 445801 446032 448699 454290 464064 470721 476303 477907 483853 485535 486323 489613 501476 504553 508946 509430 509471 518305 530323 530565 530652 530980 532696 541655 542980 547406 548263 549256 549984 550495 554243 554679 558261 559002 561954 569160 569558 570091 574798 575847 575868 576035 576761 581617 584922 589659 594820 596736 596997 599829 605698 609505 615983 629309 635720 636494 654920 660683 662521 668270 680774 684895 688386 688887 689252 691026 693311 694923 694962 695014 700842 701634 706545 706844 712707 716751 717079 717459 721942 726214 732087 736388 739604 740934 744916 748495 758379 762215 768431 771849 776930 781255 793576 797175 797364 800139 802196 804829 805034 810092 811541 813168 813729 813769 813818 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bathroom girl"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван девушк"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.83%) |
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.