Query Metrics
7
Database Queries
7
Different statements
137.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.28 ms (84.85%) |
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 434804 445716 449277 451154 455924 466394 468907 516363 527475 527482 535189 536096 542320 548909 561736 572672 577963 581408 583347 583403 587582 588181 588774 590453 593240 598315 615503 615604 617578 617968 621468 624466 626194 633641 637901 639149 640366 641195 648119 648183 660725 668776 677893 680603 685878 694637 702980 704292 714289 718826 719095 721227 723998 725582 728149 728888 728905 728932 730803 732545 733259 734360 734617 737804 738438 744095 744143 744147 744815 744819 744824 744836 744891 745681 747423 747983 748028 748280 749011 749972 750179 750218 752081 752090 752740 753161 757930 760448 767867 767870 780373 781962 782525 784620 785617 786884 786905 786909 792205 792248 792339 792556 793302 793919 794194 794291 794413 801922 802278 804409 804738 804948 804949 805255 806821 810394 811123 812311 814394 826662 ] |
||||||||||||||||||||||||||||||
|
11.63 ms (8.48%) |
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 767870 744891 747983 757930 767867 752081 615503 637901 702980 814394 811123 449277 466394 536096 641195 516363 826662 434804 730803 668776 588181 587582 451154 714289 802278 744095 535189 583403 793919 760448 728932 527475 527482 572672 617968 593240 598315 445716 542320 581408 561736 577963 660725 680603 685878 718826 704292 677893 721227 624466 621468 626194 588774 590453 780373 786905 792205 792339 801922 781962 786884 792248 804409 804948 804949 810394 812311 733259 744815 744819 747423 793302 728888 732545 744824 744836 749011 752740 728905 734360 734617 738438 750218 725582 744143 744147 745681 750179 728149 749972 633641 719095 782525 805255 468907 583347 455924 548909 648183 648119 694637 615604 640366 617578 639149 786909 794194 794291 794413 806821 804738 723998 748028 748280 784620 785617 792556 737804 752090 753161 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.97%) |
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 434804 445716 449277 451154 455924 466394 468907 516363 527475 527482 535189 536096 542320 548909 561736 572672 577963 581408 583347 583403 587582 588181 588774 590453 593240 598315 615503 615604 617578 617968 621468 624466 626194 633641 637901 639149 640366 641195 648119 648183 660725 668776 677893 680603 685878 694637 702980 704292 714289 718826 719095 721227 723998 725582 728149 728888 728905 728932 730803 732545 733259 734360 734617 737804 738438 744095 744143 744147 744815 744819 744824 744836 744891 745681 747423 747983 748028 748280 749011 749972 750179 750218 752081 752090 752740 753161 757930 760448 767867 767870 780373 781962 782525 784620 785617 786884 786905 786909 792205 792248 792339 792556 793302 793919 794194 794291 794413 801922 802278 804409 804738 804948 804949 805255 806821 810394 811123 812311 814394 826662 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vagina pussy"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин pussy"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вагин pussy"
]
|
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.