Query Metrics
7
Database Queries
7
Different statements
415.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.89 ms (49.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
188.40 ms (45.30%) |
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 145053 161528 247896 381758 382637 383341 386324 386472 391048 396574 404565 408201 408354 409113 442620 451723 458579 472606 478028 488952 491402 531418 532699 547443 550017 550328 554843 557878 563910 565741 577183 585044 585319 585357 593798 594871 610573 616614 618329 619449 622122 622602 623859 624212 629623 630125 638398 644030 646946 651150 652252 657755 673053 682166 682467 688254 688594 698286 708785 709973 710576 712188 713561 719911 719917 726739 731758 736092 739265 746001 746106 746325 752499 759755 760148 769989 770570 786658 788426 794569 794587 796440 797333 800234 802276 802696 803173 804177 807431 807442 807470 808016 810001 812551 812558 812631 814048 814179 814611 814613 815372 816038 816213 816266 816394 817054 817100 817851 818822 819253 819309 819690 822279 823749 824279 824280 824531 826225 827954 ] |
||||||||||||||||||||||||||||||
|
12.20 ms (2.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 769989 759755 736092 739265 630125 638398 644030 698286 797333 808016 409113 386324 161528 382637 396574 408354 816038 816266 817851 819253 585044 826225 817100 819309 819690 823749 814179 814611 815372 816394 822279 814613 816213 827954 478028 531418 532699 491402 563910 577183 547443 550017 646946 652252 657755 688254 709973 710576 719911 673053 682166 713561 651150 682467 688594 708785 712188 550328 554843 557878 565741 593798 594871 622122 585357 610573 616614 619449 624212 629623 622602 623859 788426 807431 807442 812631 794569 802276 804177 812558 726739 772851 794587 800234 807470 812551 760148 731758 752499 746106 746001 746325 770570 796440 802696 810001 458579 383341 145053 824531 472606 451723 488952 391048 386472 404565 408201 442620 814048 818822 824279 817054 824280 719917 585319 618329 786658 803173 247896 381758 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (0.63%) |
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 145053 161528 247896 381758 382637 383341 386324 386472 391048 396574 404565 408201 408354 409113 442620 451723 458579 472606 478028 488952 491402 531418 532699 547443 550017 550328 554843 557878 563910 565741 577183 585044 585319 585357 593798 594871 610573 616614 618329 619449 622122 622602 623859 624212 629623 630125 638398 644030 646946 651150 652252 657755 673053 682166 682467 688254 688594 698286 708785 709973 710576 712188 713561 719911 719917 726739 731758 736092 739265 746001 746106 746325 752499 759755 760148 769989 770570 786658 788426 794569 794587 796440 797333 800234 802276 802696 803173 804177 807431 807442 807470 808016 810001 812551 812558 812631 814048 814179 814611 814613 815372 816038 816213 816266 816394 817054 817100 817851 818822 819253 819309 819690 822279 823749 824279 824280 824531 826225 827954 ] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy tits"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.