Query Metrics
7
Database Queries
7
Different statements
187.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.92 ms (87.33%) |
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 27423 104921 233618 256371 307352 385119 398797 404054 512186 538556 539205 540281 540284 543153 551694 566730 576603 588074 588279 594596 599470 604947 611133 624446 627531 628340 629010 654829 655345 655699 656081 657337 657713 658400 658413 659151 659531 659757 659795 665749 670453 670783 671769 673334 674326 681805 682099 686999 689308 701202 702476 704374 704864 704874 708338 712794 713021 713279 716026 716472 719006 722433 731860 732132 734161 734681 736163 739614 740228 740784 742458 742467 747491 748331 752186 752932 754531 754975 755244 755287 755888 758622 759039 760480 764676 766793 769194 770834 772651 776814 777665 778258 778730 781629 782092 782100 783131 784861 788912 790438 791135 791334 792458 792725 797633 804762 805327 805748 806633 808939 810141 811096 816215 816844 817335 817784 820787 820796 821602 826997 ] |
||||||||||||||||||||||||||||||
|
12.98 ms (6.92%) |
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 654829 674326 689308 682099 704864 713279 594596 808939 731860 770834 797633 748331 754531 754975 629010 704374 713021 792725 404054 307352 820796 817784 665749 719006 673334 702476 734161 739614 760480 781629 256371 539205 540281 540284 659531 670783 681805 658413 671769 708338 566730 604947 791135 792458 811096 782100 740784 752932 772651 788912 791334 806633 810141 755287 27423 816844 820787 816215 512186 538556 551694 658400 659757 704874 716472 655345 655699 656081 657713 659795 712794 657337 659151 670453 588279 588074 628340 777665 784861 776814 778730 758622 782092 805327 736163 740228 742458 742467 752186 755888 759039 766793 764676 747491 755244 627531 701202 722433 805748 233618 398797 385119 104921 826997 543153 686999 611133 624446 778258 790438 804762 734681 783131 769194 732132 716026 817335 576603 599470 821602 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (1.80%) |
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 27423 104921 233618 256371 307352 385119 398797 404054 512186 538556 539205 540281 540284 543153 551694 566730 576603 588074 588279 594596 599470 604947 611133 624446 627531 628340 629010 654829 655345 655699 656081 657337 657713 658400 658413 659151 659531 659757 659795 665749 670453 670783 671769 673334 674326 681805 682099 686999 689308 701202 702476 704374 704864 704874 708338 712794 713021 713279 716026 716472 719006 722433 731860 732132 734161 734681 736163 739614 740228 740784 742458 742467 747491 748331 752186 752932 754531 754975 755244 755287 755888 758622 759039 760480 764676 766793 769194 770834 772651 776814 777665 778258 778730 781629 782092 782100 783131 784861 788912 790438 791135 791334 792458 792725 797633 804762 805327 805748 806633 808939 810141 811096 816215 816844 817335 817784 820787 820796 821602 826997 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"babe girl"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"babe девушк"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"babe девушк"
]
|
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.