Query Metrics
7
Database Queries
7
Different statements
183.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.69 ms (86.25%) |
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 33998 383549 384270 384526 385446 388175 392912 395317 395398 395401 395879 397072 398830 403268 417878 418564 424728 424788 424839 424937 451293 457325 457749 460852 462529 463697 466501 469640 473941 477904 485636 507158 511129 518904 520207 521257 521770 527154 543367 543384 546911 551145 555652 555822 562772 566197 569394 585393 590214 592079 592145 594583 602676 606150 607017 617844 626561 636750 641492 646395 654274 660110 673647 676191 678826 680624 701260 708280 709623 712485 712959 714892 715555 716111 718338 718448 718786 721122 721942 726265 726634 726637 733273 733512 734005 736988 737442 739196 742244 751978 761398 761895 764141 767874 771490 771609 774037 775379 777909 779565 783465 784767 786414 787686 788274 792353 793172 796628 803806 805141 809219 810187 810198 812785 815159 816682 820549 821838 825798 ] |
||||||||||||||||||||||||||||||
|
14.20 ms (7.72%) |
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 726634 403268 734005 775379 424937 820549 507158 543384 469640 708280 712485 716111 812785 718338 825798 810198 784767 385446 384526 562772 660110 594583 590214 742244 384270 511129 520207 555652 718786 721122 585393 786414 761895 726265 773429 761398 771490 774037 383549 398830 395317 392912 546911 418564 821838 451293 521770 678826 641492 805141 736988 764141 701260 485636 397072 737442 796628 462529 518904 680624 816682 527154 551145 714892 718448 709623 617844 626561 636750 788274 803806 751978 726637 739196 715555 777909 793172 477904 463697 395398 395401 767874 417878 33998 466501 771609 424788 424839 543367 676191 654274 673647 721942 555822 592145 592079 733273 783465 424728 457325 787686 473941 460852 602676 395879 457749 566197 646395 712959 607017 606150 792353 809219 779565 810187 733512 815159 388175 521257 569394 ] |
||||||||||||||||||||||||||||||
|
3.52 ms (1.91%) |
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 33998 383549 384270 384526 385446 388175 392912 395317 395398 395401 395879 397072 398830 403268 417878 418564 424728 424788 424839 424937 451293 457325 457749 460852 462529 463697 466501 469640 473941 477904 485636 507158 511129 518904 520207 521257 521770 527154 543367 543384 546911 551145 555652 555822 562772 566197 569394 585393 590214 592079 592145 594583 602676 606150 607017 617844 626561 636750 641492 646395 654274 660110 673647 676191 678826 680624 701260 708280 709623 712485 712959 714892 715555 716111 718338 718448 718786 721122 721942 726265 726634 726637 733273 733512 734005 736988 737442 739196 742244 751978 761398 761895 764141 767874 771490 771609 774037 775379 777909 779565 783465 784767 786414 787686 788274 792353 793172 796628 803806 805141 809219 810187 810198 812785 815159 816682 820549 821838 825798 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hotel минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hotel blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hotel минет оральн секс"
]
|
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.