Query Metrics
7
Database Queries
7
Different statements
158.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.38 ms (87.11%) |
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 117883 149406 373995 391984 393067 393326 396130 411025 414064 416751 416826 421740 424581 428223 428568 429609 432274 433152 433179 433244 440094 441952 445943 446274 448063 450792 453400 459306 461870 465320 471674 473406 477418 478540 480504 487779 489014 497905 500734 503166 506257 509085 512961 520767 520789 521435 523885 529658 544108 544860 547422 554350 555198 555271 557203 564301 566054 592255 594389 599364 605725 623201 631457 632312 632605 637115 648540 648699 652766 665450 666871 666876 670826 671837 690855 693041 693194 700993 713504 714622 715877 718651 720264 724130 727527 727534 728292 728429 731811 734380 737197 739151 740877 745123 756428 758806 759333 761321 765632 769837 788651 794305 794859 800334 805661 808771 814448 814532 814962 815162 815334 815930 816774 817194 817963 819924 826827 826988 827142 827491 ] |
||||||||||||||||||||||||||||||
|
10.87 ms (6.84%) |
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 808771 734380 506257 648699 765632 631457 632312 453400 478540 814532 599364 724130 117883 500734 396130 817963 826827 690855 693041 739151 745123 758806 713504 714622 715877 693194 720264 800334 149406 815334 547422 727534 731811 727527 414064 459306 461870 520789 817194 826988 819924 554350 555271 788651 756428 728292 794305 393326 448063 445943 416826 814962 557203 718651 393067 411025 521435 814448 441952 429609 446274 473406 477418 465320 471674 489014 544108 652766 592255 440094 421740 424581 487779 827142 555198 564301 815162 529658 648540 671837 623201 794859 761321 740877 805661 373995 666871 480504 827491 728429 544860 815930 665450 566054 816774 700993 637115 632605 737197 759333 509085 503166 769837 391984 433244 450792 520767 523885 433179 416751 605725 666876 428568 433152 432274 428223 512961 497905 670826 594389 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (2.06%) |
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 117883 149406 373995 391984 393067 393326 396130 411025 414064 416751 416826 421740 424581 428223 428568 429609 432274 433152 433179 433244 440094 441952 445943 446274 448063 450792 453400 459306 461870 465320 471674 473406 477418 478540 480504 487779 489014 497905 500734 503166 506257 509085 512961 520767 520789 521435 523885 529658 544108 544860 547422 554350 555198 555271 557203 564301 566054 592255 594389 599364 605725 623201 631457 632312 632605 637115 648540 648699 652766 665450 666871 666876 670826 671837 690855 693041 693194 700993 713504 714622 715877 718651 720264 724130 727527 727534 728292 728429 731811 734380 737197 739151 740877 745123 756428 758806 759333 761321 765632 769837 788651 794305 794859 800334 805661 808771 814448 814532 814962 815162 815334 815930 816774 817194 817963 819924 826827 826988 827142 827491 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck ass hole"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс жоп дырк"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.85%) |
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.