Query Metrics
7
Database Queries
7
Different statements
194.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.68 ms (86.86%) |
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 3371 4282 149612 388204 411564 428577 495893 505178 514161 516061 533919 535791 538135 541173 542116 543703 545019 554608 559533 560713 566821 567440 576251 578925 582001 588795 588957 590455 590848 592589 595022 610590 615586 624583 631219 636625 638479 638524 645472 655505 667820 668022 668584 672858 674470 674606 678765 685159 685165 688393 688765 688866 689810 689822 689984 691431 692122 694138 696293 698130 700200 703953 705008 705009 705104 705154 707879 717864 718625 718906 720266 731142 732941 775407 775644 778205 779719 780291 780656 781120 782764 785556 787262 787573 789056 789567 789804 790317 792295 792305 792334 793317 793806 794732 795624 795842 797711 801674 803647 803874 803940 804523 804895 808939 813727 813875 816155 816600 818048 818109 818816 818881 824635 825028 825431 825698 827198 827596 828801 ] |
||||||||||||||||||||||||||||||
|
16.30 ms (8.39%) |
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 787262 803874 732941 731142 610590 705154 149612 4282 3371 388204 411564 428577 816155 818048 825698 813875 816600 818109 818816 827198 827596 824635 813727 818881 825028 825431 828801 514161 516061 538135 495893 533919 535791 505178 545019 560713 566821 567440 576251 541173 542116 543703 582001 672858 674470 674606 688765 694138 698130 703953 717864 718906 720266 645472 655505 685159 688393 688866 689810 691431 705008 705009 705104 667820 668022 668584 678765 685165 689822 689984 692122 696293 700200 707879 718625 554608 559533 578925 588957 617264 636625 638479 588795 590848 592589 595022 624583 631219 590455 615586 638524 779719 780291 780656 785556 789056 789804 792305 792334 793806 795624 795842 803647 775407 775644 778205 781120 782764 787573 789567 790317 792295 793317 794732 797711 801674 803940 804523 804895 808939 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.29%) |
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 3371 4282 149612 388204 411564 428577 495893 505178 514161 516061 533919 535791 538135 541173 542116 543703 545019 554608 559533 560713 566821 567440 576251 578925 582001 588795 588957 590455 590848 592589 595022 610590 615586 624583 631219 636625 638479 638524 645472 655505 667820 668022 668584 672858 674470 674606 678765 685159 685165 688393 688765 688866 689810 689822 689984 691431 692122 694138 696293 698130 700200 703953 705008 705009 705104 705154 707879 717864 718625 718906 720266 731142 732941 775407 775644 778205 779719 780291 780656 781120 782764 785556 787262 787573 789056 789567 789804 790317 792295 792305 792334 793317 793806 794732 795624 795842 797711 801674 803647 803874 803940 804523 804895 808939 813727 813875 816155 816600 818048 818109 818816 818881 824635 825028 825431 825698 827198 827596 828801 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife webcam"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.