Query Metrics
7
Database Queries
7
Different statements
421.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.91 ms (51.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old жоп секс"
]
|
||||||||||||||||||||||||||||||
|
183.03 ms (43.46%) |
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 359458 382549 395133 395942 407558 454274 457011 468879 474398 494573 516077 525114 535399 551982 563064 563483 567147 568573 569668 572464 579998 591430 593072 593988 596453 599295 617358 617440 626024 627141 628219 641598 645728 663242 663861 663979 664315 665219 665506 665513 665835 667287 667540 667593 667615 668185 668848 669456 670479 670481 674556 683382 710883 717711 719276 721167 721413 721415 722240 724302 725578 727479 731755 731758 732129 741468 745840 754856 755553 757927 758429 758439 772660 772878 773901 774313 775853 781652 781679 781694 781702 781748 781978 784274 787328 788468 788583 789530 789960 789967 790611 798860 798897 801210 802186 804583 805266 807805 808207 808551 808917 812132 815629 816781 817327 817746 818346 818737 818893 820086 820228 820280 820592 823424 824023 824934 825847 827889 827890 ] |
||||||||||||||||||||||||||||||
|
12.11 ms (2.88%) |
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 805266 551982 569668 664315 721167 665506 781978 790611 812132 468879 626024 663242 683382 724302 563483 593988 808917 457011 670479 788468 516077 568573 567147 801210 395133 395942 407558 817327 808551 775853 772660 773901 774313 617440 627141 787328 804583 525114 669456 359458 474398 725578 494573 596453 641598 382549 599295 454274 815629 817746 820228 820592 818893 820280 823424 818346 818737 824023 824934 816781 820086 825847 827889 827890 535399 572464 563064 667593 721413 645728 665219 665513 667287 668185 668848 710883 663861 663979 665835 667540 667615 670481 674556 579998 593072 628219 591430 617358 781748 789967 798860 798897 781694 781702 789530 802186 808207 745840 772878 784274 788583 789960 807805 741468 754856 758429 771786 727479 731758 755553 758439 732129 757927 731755 717711 719276 721415 722240 781652 781679 ] |
||||||||||||||||||||||||||||||
|
5.71 ms (1.36%) |
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 359458 382549 395133 395942 407558 454274 457011 468879 474398 494573 516077 525114 535399 551982 563064 563483 567147 568573 569668 572464 579998 591430 593072 593988 596453 599295 617358 617440 626024 627141 628219 641598 645728 663242 663861 663979 664315 665219 665506 665513 665835 667287 667540 667593 667615 668185 668848 669456 670479 670481 674556 683382 710883 717711 719276 721167 721413 721415 722240 724302 725578 727479 731755 731758 732129 741468 745840 754856 755553 757927 758429 758439 772660 772878 773901 774313 775853 781652 781679 781694 781702 781748 781978 784274 787328 788468 788583 789530 789960 789967 790611 798860 798897 801210 802186 804583 805266 807805 808207 808551 808917 812132 815629 816781 817327 817746 818346 818737 818893 820086 820228 820280 820592 823424 824023 824934 825847 827889 827890 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old ass fuck"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old жоп секс"
]
|
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.