Query Metrics
7
Database Queries
7
Different statements
149.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.42 ms (83.35%) |
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 6651 7051 7329 32999 66907 95586 102892 183634 187723 188009 229361 233512 237362 285923 319863 325867 366010 377323 382439 382802 385138 385314 385999 386189 386212 387856 388200 388888 390525 391077 391635 391656 393580 395714 396110 397075 397288 397412 397867 397901 398387 398545 398557 398885 400486 400592 400820 401189 401491 402226 402700 405749 406587 408245 408532 411215 411468 411615 412273 414319 415300 415786 416969 417808 418058 418072 418837 420853 420886 421618 421849 424296 424556 425279 428512 432304 439791 440263 440963 441419 441453 441530 443695 443735 443901 443905 444942 447335 448524 457228 458704 459061 459843 460773 461318 465915 466198 466244 468399 470424 475901 484342 487338 487389 489881 492346 496524 503499 521816 521885 555912 563127 573918 603807 717469 723230 728240 728445 788284 789552 ] |
||||||||||||||||||||||||||||||
|
15.66 ms (10.49%) |
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 487338 382439 441453 397412 391635 459061 728445 183634 603807 397867 468399 325867 402700 460773 7051 388888 401491 417808 789552 385138 386212 391656 385999 385314 393580 412273 366010 444942 377323 391077 397075 398387 421618 408532 458704 448524 398885 418058 400486 470424 395714 421849 411468 439791 420886 466198 443905 102892 6651 388200 441419 440263 492346 461318 424296 319863 32999 398545 496524 573918 555912 563127 788284 387856 443695 424556 466244 484342 285923 400592 401189 406587 416969 521816 475901 411215 428512 400820 382802 717469 95586 420853 418837 408245 521885 386189 397901 411615 415786 229361 390525 425279 418072 440963 487389 489881 728240 723230 187723 432304 443735 397288 402226 237362 457228 465915 414319 459843 503499 233512 441530 405749 447335 188009 66907 7329 396110 398557 415300 443901 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.61%) |
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 6651 7051 7329 32999 66907 95586 102892 183634 187723 188009 229361 233512 237362 285923 319863 325867 366010 377323 382439 382802 385138 385314 385999 386189 386212 387856 388200 388888 390525 391077 391635 391656 393580 395714 396110 397075 397288 397412 397867 397901 398387 398545 398557 398885 400486 400592 400820 401189 401491 402226 402700 405749 406587 408245 408532 411215 411468 411615 412273 414319 415300 415786 416969 417808 418058 418072 418837 420853 420886 421618 421849 424296 424556 425279 428512 432304 439791 440263 440963 441419 441453 441530 443695 443735 443901 443905 444942 447335 448524 457228 458704 459061 459843 460773 461318 465915 466198 466244 468399 470424 475901 484342 487338 487389 489881 492346 496524 503499 521816 521885 555912 563127 573918 603807 717469 723230 728240 728445 788284 789552 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"анальный секс парню"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал парен"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.98%) |
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.