Query Metrics
7
Database Queries
7
Different statements
173.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.40 ms (81.73%) |
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 390573 391049 397340 399869 400958 401214 402262 402649 405829 406935 409747 414341 414375 414929 415128 419217 419246 420357 422708 423320 423336 424444 425164 425945 425967 427289 427406 429608 431393 431540 432831 435225 439194 439540 441203 442398 443792 445945 448300 448793 449086 449869 451259 452256 453409 454177 454210 454282 454954 454975 457963 460208 460279 462466 462483 463795 463973 464162 464971 466118 466733 466992 467066 468096 469536 470516 471626 471814 471881 472004 473491 473869 475262 476191 477731 478542 479816 482098 482388 486150 486182 486407 487294 488904 493204 495038 495705 506346 509164 510134 518238 520909 521256 525864 526042 533372 537913 554526 559453 559949 573941 577371 578323 583615 586518 592996 598298 598853 607355 624802 633498 639824 642063 722392 731158 742849 776212 784152 807023 815735 ] |
||||||||||||||||||||||||||||||
|
21.50 ms (12.43%) |
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 624802 598298 731158 722392 424444 448300 401214 439194 460279 466992 477731 409747 419217 420357 454177 454282 482098 471814 506346 518238 486150 633498 463973 399869 402262 415128 423320 425967 427289 429608 422708 445945 487294 475262 463795 464971 473491 526042 521256 578323 592996 586518 742849 439540 462466 467066 472004 400958 470516 402649 397340 414375 443792 460208 495705 405829 520909 406935 423336 425945 431393 419246 432831 435225 414929 431540 815735 448793 469536 449086 471881 486407 537913 464162 476191 478542 486182 784152 607355 452256 457963 466118 510134 391049 468096 554526 583615 509164 488904 493204 414341 473869 454975 559453 559949 573941 577371 598853 807023 441203 453409 425164 451259 462483 479816 427406 776212 390573 442398 454954 466733 454210 471626 533372 642063 639824 449869 482388 495038 525864 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.63%) |
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 390573 391049 397340 399869 400958 401214 402262 402649 405829 406935 409747 414341 414375 414929 415128 419217 419246 420357 422708 423320 423336 424444 425164 425945 425967 427289 427406 429608 431393 431540 432831 435225 439194 439540 441203 442398 443792 445945 448300 448793 449086 449869 451259 452256 453409 454177 454210 454282 454954 454975 457963 460208 460279 462466 462483 463795 463973 464162 464971 466118 466733 466992 467066 468096 469536 470516 471626 471814 471881 472004 473491 473869 475262 476191 477731 478542 479816 482098 482388 486150 486182 486407 487294 488904 493204 495038 495705 506346 509164 510134 518238 520909 521256 525864 526042 533372 537913 554526 559453 559949 573941 577371 578323 583615 586518 592996 598298 598853 607355 624802 633498 639824 642063 722392 731158 742849 776212 784152 807023 815735 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge boobs hairy"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные boobs волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромные boobs волосатая"
]
|
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.