Query Metrics
7
Database Queries
7
Different statements
233.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.50 ms (88.92%) |
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 542101 542238 547979 550786 555403 555451 563268 563958 567048 568755 577610 581542 583453 583523 584295 586377 589652 591975 593887 597173 597448 599814 602048 615950 617573 617889 626398 627332 628570 629639 632793 634969 635825 639406 639850 640254 641322 647030 647530 651768 653066 654911 662150 664446 666058 667363 668111 668651 672836 675561 677250 684888 688173 689530 689877 693084 694401 696137 696960 698748 699185 699304 700947 701773 703927 708730 716125 718029 719987 720541 720558 725412 728568 736187 736333 736334 737891 738426 739301 774872 774926 775627 775658 776018 777836 777869 777884 782773 784886 785649 785653 786091 786394 788659 789797 791593 792237 792253 792451 793793 795063 795411 796408 801067 801806 801813 801818 801820 801999 803368 803487 804345 804709 806809 806925 808602 810095 810170 811024 812509 ] |
||||||||||||||||||||||||||||||
|
14.67 ms (6.29%) |
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 555403 555451 563958 567048 568755 542101 542238 547979 550786 563268 577610 581542 583453 583523 653066 654911 662150 664446 666058 684888 689530 694401 696137 699304 700947 701773 716125 718029 647530 677250 689877 696960 703927 708730 719987 647030 651768 667363 668111 668651 672836 675561 688173 693084 698748 699185 720541 720558 584295 586377 597173 615950 617889 640254 599814 602048 626398 634969 639406 639850 589652 591975 597448 617573 632793 635825 593887 627332 628570 629639 641322 774872 774926 775627 775658 784886 785653 788659 792237 792253 792451 793793 795063 795411 801067 801806 801813 801818 801820 801999 803368 803487 806809 806925 810170 776018 777836 777869 777884 782773 785649 786091 786394 789797 791593 796408 804345 804709 808602 810095 811024 812509 725412 728568 736187 736333 736334 737891 738426 739301 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.27%) |
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 542101 542238 547979 550786 555403 555451 563268 563958 567048 568755 577610 581542 583453 583523 584295 586377 589652 591975 593887 597173 597448 599814 602048 615950 617573 617889 626398 627332 628570 629639 632793 634969 635825 639406 639850 640254 641322 647030 647530 651768 653066 654911 662150 664446 666058 667363 668111 668651 672836 675561 677250 684888 688173 689530 689877 693084 694401 696137 696960 698748 699185 699304 700947 701773 703927 708730 716125 718029 719987 720541 720558 725412 728568 736187 736333 736334 737891 738426 739301 774872 774926 775627 775658 776018 777836 777869 777884 782773 784886 785649 785653 786091 786394 788659 789797 791593 792237 792253 792451 793793 795063 795411 796408 801067 801806 801813 801818 801820 801999 803368 803487 804345 804709 806809 806925 808602 810095 810170 811024 812509 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife orgasm"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен orgasm"
]
|
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.