Query Metrics
7
Database Queries
7
Different statements
159.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.97 ms (81.38%) |
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 4324 187818 270104 388847 394738 396345 398964 399422 401062 401167 401202 407856 407903 411044 411351 411884 411986 413097 415548 417232 418880 418996 419622 420293 420534 421048 421838 422158 424871 425979 426701 427237 428697 428709 430707 433965 434885 437333 437352 439661 439731 439824 440598 443142 444139 444620 446522 447956 451221 451787 452362 453091 453548 454421 454429 454444 454471 454968 455749 456383 458728 459403 459956 461136 462095 462876 463978 464136 464336 464858 465383 465453 467106 468366 468941 475039 483375 483385 489288 490455 491781 494282 495264 500013 503400 506274 507090 509941 510839 518141 518780 519133 519342 519579 526737 526966 550234 550641 554451 561082 574430 575272 597134 631615 651102 664800 664820 665204 665292 666095 667286 680824 705781 712672 781764 781853 781869 781998 793591 814294 ] |
||||||||||||||||||||||||||||||
|
19.20 ms (12.02%) |
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 456383 464858 407903 519133 401167 463978 454429 489288 550234 453091 509941 464336 597134 439824 411986 413097 417232 443142 418996 475039 465383 462095 461136 462876 4324 427237 428697 490455 398964 451221 465453 187818 464136 665204 433965 574430 394738 399422 554451 651102 781764 781869 793591 500013 454444 455749 468941 451787 680824 415548 411044 667286 705781 712672 561082 458728 510839 503400 575272 440598 526966 388847 420293 447956 781998 444620 665292 426701 550641 428709 437352 468366 781853 434885 452362 454471 446522 444139 270104 420534 437333 526737 483385 518780 439661 439731 491781 459403 467106 424871 422158 421838 407856 421048 483375 430707 425979 453548 495264 459956 506274 519342 418880 454968 666095 454421 396345 814294 664820 664800 631615 401062 519579 507090 494282 419622 518141 401202 411351 411884 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.72%) |
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 4324 187818 270104 388847 394738 396345 398964 399422 401062 401167 401202 407856 407903 411044 411351 411884 411986 413097 415548 417232 418880 418996 419622 420293 420534 421048 421838 422158 424871 425979 426701 427237 428697 428709 430707 433965 434885 437333 437352 439661 439731 439824 440598 443142 444139 444620 446522 447956 451221 451787 452362 453091 453548 454421 454429 454444 454471 454968 455749 456383 458728 459403 459956 461136 462095 462876 463978 464136 464336 464858 465383 465453 467106 468366 468941 475039 483375 483385 489288 490455 491781 494282 495264 500013 503400 506274 507090 509941 510839 518141 518780 519133 519342 519579 526737 526966 550234 550641 554451 561082 574430 575272 597134 631615 651102 664800 664820 665204 665292 666095 667286 680824 705781 712672 781764 781853 781869 781998 793591 814294 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ебут в полненькую жоп…"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс в полная жоп"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.14%) |
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.