Query Metrics
7
Database Queries
7
Different statements
186.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.35 ms (86.34%) |
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 287540 382960 397648 399701 404490 405243 414759 434672 436149 437669 437717 438006 438994 444495 444803 449541 452381 478254 480353 483010 484533 487371 489118 496325 499868 500873 505144 507568 512337 512504 516426 520023 524755 528331 529482 532259 532719 534065 535116 540272 548280 550946 558812 559783 562946 566199 572008 580403 582399 586456 588024 588422 595113 597267 599072 610517 610867 611932 612829 613753 613981 614880 631321 640948 655924 662575 669303 679904 686188 697207 698028 700290 705780 717820 720145 720796 721744 725714 729548 733554 733847 733856 733873 733902 740800 747153 747694 750579 757690 757709 760439 761776 773794 774038 774214 775346 777265 780067 783072 783981 785603 786763 788817 788856 788864 789637 790575 798681 801709 804312 805039 809842 810035 810567 812645 813382 814252 814417 819058 826672 ] |
||||||||||||||||||||||||||||||
|
15.26 ms (8.17%) |
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 610867 783072 783981 810567 747694 761776 774038 452381 397648 487371 480353 721744 740800 669303 785603 720796 801709 512504 662575 720145 788864 733902 733847 733873 780067 810035 434672 444495 826672 814252 404490 819058 532719 697207 595113 789637 804312 438994 580403 382960 505144 698028 705780 610517 613981 788856 777265 414759 507568 540272 747153 405243 489118 516426 500873 512337 499868 535116 559783 655924 631321 760439 729548 733856 640948 790575 287540 437717 520023 496325 686188 679904 611932 614880 775346 786763 750579 757690 788817 449541 436149 532259 566199 558812 550946 582399 588422 599072 613753 586456 717820 809842 399701 478254 444803 700290 805039 437669 597267 534065 814417 483010 524755 528331 529482 548280 562946 572008 588024 612829 798681 812645 757709 813382 725714 774214 773794 733554 438006 484533 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.33%) |
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 287540 382960 397648 399701 404490 405243 414759 434672 436149 437669 437717 438006 438994 444495 444803 449541 452381 478254 480353 483010 484533 487371 489118 496325 499868 500873 505144 507568 512337 512504 516426 520023 524755 528331 529482 532259 532719 534065 535116 540272 548280 550946 558812 559783 562946 566199 572008 580403 582399 586456 588024 588422 595113 597267 599072 610517 610867 611932 612829 613753 613981 614880 631321 640948 655924 662575 669303 679904 686188 697207 698028 700290 705780 717820 720145 720796 721744 725714 729548 733554 733847 733856 733873 733902 740800 747153 747694 750579 757690 757709 760439 761776 773794 774038 774214 775346 777265 780067 783072 783981 785603 786763 788817 788856 788864 789637 790575 798681 801709 804312 805039 809842 810035 810567 812645 813382 814252 814417 819058 826672 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"only girl"
]
|
||||||||||||||||||||||||||||||
|
2.23 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"only девушк"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"only девушк"
]
|
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.