Query Metrics
7
Database Queries
7
Different statements
166.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.84 ms (86.80%) |
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 392401 397089 398582 401052 404035 407690 409613 415835 421412 422280 424541 424757 458804 461267 468749 469168 479324 485929 495130 502805 509271 510637 525900 527277 530257 533856 551221 577602 585157 593790 596944 599318 603897 606253 607153 609107 612029 617617 621548 621979 635833 641153 652126 652278 660664 662391 668944 669239 670084 673187 673908 678903 685432 693778 694565 705726 711358 713208 714855 715137 715507 716675 717876 719112 731361 733330 733671 734044 736436 737425 749769 755331 756263 759783 768790 768989 779289 779427 780764 780883 781649 782307 784267 784292 786578 787286 787399 787498 789033 789273 790972 791235 793680 793944 795089 801029 803714 804864 804872 805533 807186 808849 809976 813667 814090 814893 814902 815174 815662 815855 816544 816568 817688 818833 819870 822154 822212 822300 822981 823501 ] |
||||||||||||||||||||||||||||||
|
11.56 ms (6.93%) |
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 733330 793944 768790 755331 734044 749769 768989 409613 421412 415835 705726 621979 786578 756263 714855 815662 468749 678903 790972 807186 822212 715507 458804 461267 509271 814090 822300 822154 823501 617617 398582 392401 424541 822981 551221 668944 673908 599318 779289 781649 809976 782307 795089 733671 737425 787498 397089 603897 525900 612029 789033 479324 502805 510637 407690 815174 818833 816544 817688 669239 641153 607153 787286 780764 784292 808849 759783 736436 731361 780883 789273 791235 717876 424757 495130 593790 787399 422280 662391 635833 713208 814902 606253 793680 801029 803714 660664 401052 404035 814893 816568 533856 804864 815855 527277 469168 670084 715137 652126 779427 719112 693778 716675 813667 819870 485929 530257 577602 652278 673187 711358 694565 685432 609107 621548 585157 596944 784267 804872 805533 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.52%) |
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 392401 397089 398582 401052 404035 407690 409613 415835 421412 422280 424541 424757 458804 461267 468749 469168 479324 485929 495130 502805 509271 510637 525900 527277 530257 533856 551221 577602 585157 593790 596944 599318 603897 606253 607153 609107 612029 617617 621548 621979 635833 641153 652126 652278 660664 662391 668944 669239 670084 673187 673908 678903 685432 693778 694565 705726 711358 713208 714855 715137 715507 716675 717876 719112 731361 733330 733671 734044 736436 737425 749769 755331 756263 759783 768790 768989 779289 779427 780764 780883 781649 782307 784267 784292 786578 787286 787399 787498 789033 789273 790972 791235 793680 793944 795089 801029 803714 804864 804872 805533 807186 808849 809976 813667 814090 814893 814902 815174 815662 815855 816544 816568 817688 818833 819870 822154 822212 822300 822981 823501 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс real"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob real"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.11%) |
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.