Query Metrics
7
Database Queries
7
Different statements
166.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.98 ms (87.84%) |
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 30967 116603 392401 436636 438051 440681 447940 458541 464239 466658 495333 526510 526954 527504 538163 541577 545861 550914 552988 564660 566270 572754 585157 587982 590029 622841 624816 625539 625935 627690 632532 632857 632930 634066 638439 642996 647119 652278 660851 664235 668085 668099 668331 668944 669347 685432 691388 695882 696198 698144 702203 703235 703291 705139 710175 712582 713921 715800 717122 724027 731075 734672 736131 737334 740145 741796 743630 743875 744218 745601 745782 747982 749825 751963 755780 757773 761349 763832 764060 765071 767193 768745 771430 771937 772559 777738 777834 780213 780323 782654 783033 783692 783963 785229 786227 786578 787437 787732 788938 789202 789273 789818 789837 791235 791716 793202 793453 795089 796399 799511 800768 800951 803651 804297 804902 808048 810195 818751 818753 819895 ] |
||||||||||||||||||||||||||||||
|
11.19 ms (6.73%) |
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 624816 625935 632532 638439 783692 786227 787732 788938 793453 810195 780213 800768 800951 734672 743630 771430 772559 783033 789818 791716 799511 744218 749825 771937 731075 743875 745601 747982 751963 763832 736131 622841 625539 632930 702203 703291 717122 780323 787437 804297 466658 438051 818753 541577 550914 566270 691388 695882 710175 712582 660851 668331 698144 685432 634066 587982 632857 585157 590029 642996 783963 777738 782654 785229 786578 795089 724027 737334 761349 789202 789837 796399 804902 740145 745782 755780 765071 741796 764060 767193 768745 627690 703235 777834 789273 791235 793202 803651 808048 447940 495333 669347 527504 818751 757773 116603 526510 392401 30967 436636 440681 819895 464239 458541 538163 526954 552988 572754 545861 652278 664235 668085 696198 668944 705139 713921 647119 668099 715800 564660 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.51%) |
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 30967 116603 392401 436636 438051 440681 447940 458541 464239 466658 495333 526510 526954 527504 538163 541577 545861 550914 552988 564660 566270 572754 585157 587982 590029 622841 624816 625539 625935 627690 632532 632857 632930 634066 638439 642996 647119 652278 660851 664235 668085 668099 668331 668944 669347 685432 691388 695882 696198 698144 702203 703235 703291 705139 710175 712582 713921 715800 717122 724027 731075 734672 736131 737334 740145 741796 743630 743875 744218 745601 745782 747982 749825 751963 755780 757773 761349 763832 764060 765071 767193 768745 771430 771937 772559 777738 777834 780213 780323 782654 783033 783692 783963 785229 786227 786578 787437 787732 788938 789202 789273 789818 789837 791235 791716 793202 793453 795089 796399 799511 800768 800951 803651 804297 804902 808048 810195 818751 818753 819895 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real girl"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real девушк"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real девушк"
]
|
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.