Query Metrics
7
Database Queries
7
Different statements
194.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.37 ms (86.24%) |
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 325984 386166 387515 393326 394154 395825 400954 413418 416652 417491 418534 418866 421369 421423 428851 429384 429909 429961 430366 433123 433202 436132 440016 441111 447519 447987 451594 456567 480260 489888 492351 511862 513313 518466 521182 530026 532727 532882 534596 536266 537958 544835 546417 548723 564303 594343 594375 597457 597815 598539 598674 598760 620901 628089 632302 633316 633637 637128 641562 641569 641950 642781 654086 659414 663181 666562 666875 668372 674328 674980 678125 680161 680172 686712 700674 701012 702981 705809 713022 717895 718696 718702 719937 722522 725149 725173 730692 731683 731830 733845 733905 734281 735990 738826 740704 741548 746314 748547 749012 750691 752592 752677 756082 775563 776286 776956 777575 777950 778393 778836 778850 787563 788248 788497 791532 794702 797390 805230 816933 818377 ] |
||||||||||||||||||||||||||||||
|
16.23 ms (8.36%) |
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 701012 395825 518466 400954 429909 433123 418534 433202 440016 447987 532727 544835 628089 731683 436132 421369 430366 447519 417491 513313 666875 598760 530026 393326 532882 641569 597457 641562 791532 749012 731830 752592 674328 778850 386166 441111 416652 421423 428851 534596 492351 805230 738826 394154 387515 413418 429961 429384 818377 451594 521182 537958 511862 654086 659414 663181 680161 680172 686712 705809 717895 666562 718696 722522 548723 598674 637128 598539 597815 620901 594343 633316 642781 788248 730692 740704 794702 741548 748547 733905 752677 725149 725173 733845 750691 756082 632302 633637 718702 719937 778393 788497 418866 325984 480260 456567 489888 536266 674980 678125 641950 816933 546417 564303 700674 702981 713022 668372 594375 775563 778836 797390 776286 776956 777575 777950 787563 734281 735990 746314 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.62%) |
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 325984 386166 387515 393326 394154 395825 400954 413418 416652 417491 418534 418866 421369 421423 428851 429384 429909 429961 430366 433123 433202 436132 440016 441111 447519 447987 451594 456567 480260 489888 492351 511862 513313 518466 521182 530026 532727 532882 534596 536266 537958 544835 546417 548723 564303 594343 594375 597457 597815 598539 598674 598760 620901 628089 632302 633316 633637 637128 641562 641569 641950 642781 654086 659414 663181 666562 666875 668372 674328 674980 678125 680161 680172 686712 700674 701012 702981 705809 713022 717895 718696 718702 719937 722522 725149 725173 730692 731683 731830 733845 733905 734281 735990 738826 740704 741548 746314 748547 749012 750691 752592 752677 756082 775563 776286 776956 777575 777950 778393 778836 778850 787563 788248 788497 791532 794702 797390 805230 816933 818377 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hole teen"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дырк teen"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дырк teen"
]
|
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.