Query Metrics
7
Database Queries
7
Different statements
151.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.60 ms (83.15%) |
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 414129 424541 427544 437413 452364 455745 461867 481238 487896 489728 490976 498332 527523 527526 529003 530257 539626 541045 564557 585343 592149 596944 599318 606176 607153 610422 610517 613580 617074 619797 621548 622855 623226 625503 627111 627253 631598 634541 636951 637882 642509 645696 646999 647607 653009 657737 668133 673187 673908 675494 677265 681961 686321 692378 705726 707604 710066 711358 714855 715136 723819 723963 724048 724887 727882 732147 732584 732984 733671 735654 736436 737240 739773 740173 740763 756263 757713 760241 760551 761883 763589 764443 765084 766062 767354 767381 768227 768725 770982 772056 777327 778637 779733 780764 780883 782307 783887 784267 785794 786432 787379 787605 788007 788359 789437 789922 791306 791405 792479 792988 793461 794009 795895 801580 807419 808849 813016 814283 819870 822981 ] |
||||||||||||||||||||||||||||||
|
13.76 ms (9.11%) |
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 739773 787605 768725 763589 724887 765084 772056 627111 777327 788359 794009 414129 437413 427544 490976 461867 452364 645696 692378 564557 619797 622855 610517 636951 634541 788007 807419 789437 813016 724048 727882 787379 455745 481238 529003 527523 527526 498332 767354 786432 791405 792988 424541 822981 814283 819870 489728 487896 539626 530257 541045 646999 647607 673187 711358 657737 677265 653009 668133 673908 675494 681961 686321 705726 707604 592149 625503 606176 607153 610422 621548 631598 642509 599318 585343 596944 627253 637882 778637 783887 784267 792479 801580 779733 780764 782307 791306 793461 723819 732147 757713 760241 766062 767381 785794 789922 795895 808849 735654 740173 740763 723963 732984 733671 736436 764443 768227 732584 737240 756263 760551 761883 770982 613580 617074 623226 710066 714855 715136 780883 ] |
||||||||||||||||||||||||||||||
|
4.36 ms (2.89%) |
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 414129 424541 427544 437413 452364 455745 461867 481238 487896 489728 490976 498332 527523 527526 529003 530257 539626 541045 564557 585343 592149 596944 599318 606176 607153 610422 610517 613580 617074 619797 621548 622855 623226 625503 627111 627253 631598 634541 636951 637882 642509 645696 646999 647607 653009 657737 668133 673187 673908 675494 677265 681961 686321 692378 705726 707604 710066 711358 714855 715136 723819 723963 724048 724887 727882 732147 732584 732984 733671 735654 736436 737240 739773 740173 740763 756263 757713 760241 760551 761883 763589 764443 765084 766062 767354 767381 768227 768725 770982 772056 777327 778637 779733 780764 780883 782307 783887 784267 785794 786432 787379 787605 788007 788359 789437 789922 791306 791405 792479 792988 793461 794009 795895 801580 807419 808849 813016 814283 819870 822981 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real teen girl"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real молодая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real молодая девушк"
]
|
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.