Query Metrics
7
Database Queries
7
Different statements
155.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.31 ms (78.71%) |
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 393585 400638 402678 405921 409767 414651 415145 417880 419245 419677 419694 421288 423980 425523 427494 428424 429713 432131 432791 443162 443216 443392 443780 445835 446863 448327 449142 451265 451521 452040 453159 453229 454599 457500 459457 460040 465976 466212 466973 467036 479700 479779 480742 481663 492682 493544 494233 498620 501290 511774 515076 516979 520511 521049 521790 523562 523663 528265 534313 534787 537922 541337 544790 555394 557812 559058 560080 576681 576699 577357 580424 580756 583247 585740 586917 600381 604093 606583 606816 619604 620154 623364 624799 624802 646219 649566 659437 673051 675936 684996 695183 720258 722512 748210 748253 750060 766911 789494 790034 792663 795437 798677 806157 806323 807557 807936 814568 814861 814883 814945 815002 815170 815252 815427 815851 816260 819823 822692 824791 827420 ] |
||||||||||||||||||||||||||||||
|
24.19 ms (15.57%) |
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 819823 492682 405921 414651 453159 467036 443780 480742 393585 457500 466212 460040 494233 432131 425523 528265 400638 402678 443162 415145 419245 419677 421288 443216 443392 409767 417880 419694 427494 815002 822692 824791 815170 827420 814861 814883 815252 814568 814945 815427 815851 816260 452040 459457 451265 453229 454599 479700 445835 466973 479779 481663 501290 521049 521790 534313 537922 498620 515076 523562 523663 511774 516979 520511 534787 465976 493544 576699 580424 560080 583247 541337 544790 555394 576681 577357 675936 684996 695183 720258 646219 649566 659437 673051 557812 559058 580756 600381 606583 624799 624802 585740 604093 606816 619604 620154 586917 790034 792663 807557 789494 806157 748210 795437 748253 766911 750060 623364 722512 798677 806323 807936 429713 432791 448327 449142 451521 423980 428424 446863 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.55%) |
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 393585 400638 402678 405921 409767 414651 415145 417880 419245 419677 419694 421288 423980 425523 427494 428424 429713 432131 432791 443162 443216 443392 443780 445835 446863 448327 449142 451265 451521 452040 453159 453229 454599 457500 459457 460040 465976 466212 466973 467036 479700 479779 480742 481663 492682 493544 494233 498620 501290 511774 515076 516979 520511 521049 521790 523562 523663 528265 534313 534787 537922 541337 544790 555394 557812 559058 560080 576681 576699 577357 580424 580756 583247 585740 586917 600381 604093 606583 606816 619604 620154 623364 624799 624802 646219 649566 659437 673051 675936 684996 695183 720258 722512 748210 748253 750060 766911 789494 790034 792663 795437 798677 806157 806323 807557 807936 814568 814861 814883 814945 815002 815170 815252 815427 815851 816260 819823 822692 824791 827420 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анилингус волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"анилингус волосатая ж…"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.18 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.