Query Metrics
7
Database Queries
7
Different statements
176.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.70 ms (85.06%) |
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 389683 406861 429121 437560 438276 438396 438648 440986 441892 445088 454519 457744 461300 461658 487205 489155 490853 493994 498332 501322 509054 510637 513854 515512 516692 527523 527526 528541 528965 529003 539557 552000 552263 553708 558048 561435 561442 564750 572670 577698 607964 613440 618461 618816 620974 631117 637998 639882 647605 658837 659324 670623 671092 678699 680749 691170 694619 696241 697296 698352 700452 706523 707488 709937 713335 719383 719640 725378 727564 728463 731232 733151 733176 735839 739459 740803 740897 741064 743933 744834 747637 748334 756277 756295 758420 759608 762369 764889 765456 767354 767983 768060 769686 770810 770943 773313 777830 781515 785029 785362 786432 790944 791301 791405 791600 791684 792988 794467 795120 797773 800975 804783 805643 809729 811130 814090 819628 ] |
||||||||||||||||||||||||||||||
|
16.10 ms (9.15%) |
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 781515 785029 791684 794467 725378 744834 759608 762013 764889 728463 739459 766177 767983 768060 770943 733151 741064 756295 769686 756277 758420 613440 637998 698352 707488 790944 457744 389683 406861 438396 437560 814090 489155 552000 577698 561442 670623 678699 700452 709937 713335 658837 696241 618816 620974 800975 811130 791301 731232 740897 770810 772131 785362 797773 809729 733176 747637 765456 773313 740803 727564 748334 762369 607964 639882 777830 791600 438276 440986 513854 490853 510637 694619 706523 804783 719383 454519 516692 461658 553708 552263 647605 659324 671092 680749 558048 618461 795120 735839 528965 515512 429121 487205 529003 527523 527526 498332 509054 561435 564750 572670 691170 697296 767354 786432 743933 631117 719640 791405 792988 805643 438648 441892 445088 819628 501322 539557 528541 461300 493994 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.77%) |
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 389683 406861 429121 437560 438276 438396 438648 440986 441892 445088 454519 457744 461300 461658 487205 489155 490853 493994 498332 501322 509054 510637 513854 515512 516692 527523 527526 528541 528965 529003 539557 552000 552263 553708 558048 561435 561442 564750 572670 577698 607964 613440 618461 618816 620974 631117 637998 639882 647605 658837 659324 670623 671092 678699 680749 691170 694619 696241 697296 698352 700452 706523 707488 709937 713335 719383 719640 725378 727564 728463 731232 733151 733176 735839 739459 740803 740897 741064 743933 744834 747637 748334 756277 756295 758420 759608 762369 764889 765456 767354 767983 768060 769686 770810 770943 773313 777830 781515 785029 785362 786432 790944 791301 791405 791600 791684 792988 794467 795120 797773 800975 804783 805643 809729 811130 814090 819628 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real девушк"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real girls"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real девушк"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.