Query Metrics
7
Database Queries
7
Different statements
568.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
421.12 ms (74.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cumshot секс"
]
|
||||||||||||||||||||||||||||||
|
130.15 ms (22.89%) |
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 77381 81818 108221 337061 498745 521712 529389 542158 544004 549401 593881 613840 615894 636500 639299 648741 652529 653042 655503 663309 665077 674258 692704 693795 694437 697733 698811 701380 706063 706659 707626 714141 717085 717117 718853 719152 722135 722180 724567 726444 727914 728810 728871 728893 732692 733158 734491 734657 736720 738543 744362 744564 746277 747251 752511 752846 753988 757887 758759 762873 763191 763843 764662 764934 765369 766329 767487 767629 769913 772371 773375 773378 777565 777621 777962 780084 780112 780281 781528 782674 787061 787412 787588 789508 790131 790662 790904 791009 791822 791825 792274 792462 794577 795975 798747 798927 799893 800039 801501 802268 802309 805561 808783 809869 812213 813903 814329 817032 819414 819454 824079 824081 824093 826004 826224 826583 828008 ] |
||||||||||||||||||||||||||||||
|
9.75 ms (1.71%) |
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 108221 826224 826583 817032 819414 529389 542158 717117 719152 655503 693795 718853 648741 663309 665077 674797 615894 636500 790904 794577 802268 802309 780084 780281 781528 801501 809869 734657 757887 769913 772371 790131 790662 792274 800039 726444 727914 732692 734491 724567 728893 733158 747251 758759 765166 766329 738543 752846 767487 728871 698811 714141 717085 777962 798747 805561 812213 505794 81818 824081 613840 77381 814329 819454 824093 544004 653042 674258 652529 701380 707626 722180 549401 798927 791009 752511 763191 767629 792462 795975 799893 808783 744362 744564 746277 762873 764934 736720 764662 753988 765369 728810 763843 773375 773378 697733 706063 722135 777565 780112 787588 789508 791822 791825 337061 824079 828008 521712 692704 593881 639299 787061 782674 787412 706659 777621 826004 813903 498745 694437 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (0.46%) |
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 77381 81818 108221 337061 498745 521712 529389 542158 544004 549401 593881 613840 615894 636500 639299 648741 652529 653042 655503 663309 665077 674258 692704 693795 694437 697733 698811 701380 706063 706659 707626 714141 717085 717117 718853 719152 722135 722180 724567 726444 727914 728810 728871 728893 732692 733158 734491 734657 736720 738543 744362 744564 746277 747251 752511 752846 753988 757887 758759 762873 763191 763843 764662 764934 765369 766329 767487 767629 769913 772371 773375 773378 777565 777621 777962 780084 780112 780281 781528 782674 787061 787412 787588 789508 790131 790662 790904 791009 791822 791825 792274 792462 794577 795975 798747 798927 799893 800039 801501 802268 802309 805561 808783 809869 812213 813903 814329 817032 819414 819454 824079 824081 824093 826004 826224 826583 828008 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cumshot sex"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cumshot секс"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.28%) |
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.