Query Metrics
7
Database Queries
7
Different statements
148.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.04 ms (85.46%) |
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 30967 384015 392401 393810 410292 424541 425928 457744 487896 489728 526954 530257 538163 539626 551221 552988 564660 566270 581739 585157 585595 587982 590029 590328 592149 596944 597903 599318 607153 608545 609107 610422 616604 620938 621548 627690 630345 641153 642996 646999 647119 647607 652278 653009 657737 662076 668085 668099 668133 668331 668944 673187 673908 680597 685432 686321 695882 696198 702639 705139 711358 712409 712582 714799 722709 724027 732147 733671 734277 734330 734401 736436 737126 737240 737334 737425 737856 740173 740763 743196 748263 755780 761484 761634 761883 765063 766062 775416 776042 779289 779733 780764 780883 782307 783887 784267 784292 784735 787252 787498 789273 789922 791235 791246 791538 791895 794909 795089 798834 799659 801580 804872 804902 806965 807505 809121 809976 819870 822981 ] |
||||||||||||||||||||||||||||||
|
11.72 ms (7.89%) |
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 722709 807505 392401 30967 424541 822981 538163 539626 526954 552988 551221 566270 646999 657737 668944 673908 599318 630345 779289 809976 779733 782307 795089 732147 737334 789922 740763 733671 737240 737425 787498 393810 712409 425928 647607 695882 712582 705139 647119 668133 641153 587982 607153 801580 780764 784292 734330 743196 766062 791895 734401 736436 761883 627690 776042 780883 789273 791235 410292 809121 680597 702639 714799 662076 581739 590328 787252 791538 798834 761484 794909 734277 775416 457744 384015 819870 489728 487896 530257 652278 668085 673187 696198 711358 668331 653009 668099 685432 686321 564660 592149 597903 608545 609107 610422 621548 585157 585595 590029 616604 596944 620938 642996 783887 784267 804872 784735 791246 806965 724027 761634 799659 804902 737856 740173 748263 765063 755780 737126 762399 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (2.09%) |
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 30967 384015 392401 393810 410292 424541 425928 457744 487896 489728 526954 530257 538163 539626 551221 552988 564660 566270 581739 585157 585595 587982 590029 590328 592149 596944 597903 599318 607153 608545 609107 610422 616604 620938 621548 627690 630345 641153 642996 646999 647119 647607 652278 653009 657737 662076 668085 668099 668133 668331 668944 673187 673908 680597 685432 686321 695882 696198 702639 705139 711358 712409 712582 714799 722709 724027 732147 733671 734277 734330 734401 736436 737126 737240 737334 737425 737856 740173 740763 743196 748263 755780 761484 761634 761883 765063 766062 775416 776042 779289 779733 780764 780883 782307 783887 784267 784292 784735 787252 787498 789273 789922 791235 791246 791538 791895 794909 795089 798834 799659 801580 804872 804902 806965 807505 809121 809976 819870 822981 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real sex teens"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real секс teens"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real секс teens"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.04%) |
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.