Query Metrics
7
Database Queries
7
Different statements
432.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
404.62 ms (93.45%) |
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 381777 386531 387973 399522 401300 401866 407454 408831 415540 415582 418958 419856 425544 425968 427262 428095 435613 438060 441417 444475 445072 445081 446321 446577 446716 446997 447878 448104 448313 450809 452786 452896 453375 453574 453861 454089 454428 454432 455120 455343 456098 457645 457839 457955 458981 459630 459847 460279 460651 460810 462816 463217 463347 463869 464036 464314 464429 465079 465224 465290 466150 466891 467728 469002 469013 471190 472505 472578 472933 473156 473851 474720 474825 474870 475368 475483 475811 476302 477104 478805 480058 481959 482098 485158 486809 487547 489272 489987 497402 498363 499187 499862 500635 500710 503317 505156 506346 510478 516838 517922 521778 524373 526799 527169 527884 527904 528054 528845 529424 529864 538665 542682 553096 569447 587489 599299 635977 710872 769575 771005 ] |
||||||||||||||||||||||||||||||
|
17.78 ms (4.11%) |
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 457955 446321 448313 481959 381777 386531 399522 408831 438060 446997 387973 419856 452896 463347 467728 477104 503317 497402 498363 527904 529424 425968 428095 407454 441417 445081 427262 454089 463869 474720 456098 457839 459630 471190 473156 473851 480058 459847 464314 466150 500635 529864 472578 452786 460279 462816 463217 435613 482098 418958 527169 505156 506346 472505 401300 445072 444475 446716 464036 528054 538665 542682 569447 710872 635977 587489 769575 771005 401866 425544 415540 453375 454428 454432 455120 448104 465224 472933 453574 458981 460651 466891 474825 474870 485158 521778 527884 516838 460810 464429 476302 453861 475368 446577 450809 469002 475811 465079 465290 469013 455343 489272 500710 517922 526799 487547 489987 524373 499187 475483 553096 599299 528845 415582 447878 457645 478805 486809 499862 510478 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (0.78%) |
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 381777 386531 387973 399522 401300 401866 407454 408831 415540 415582 418958 419856 425544 425968 427262 428095 435613 438060 441417 444475 445072 445081 446321 446577 446716 446997 447878 448104 448313 450809 452786 452896 453375 453574 453861 454089 454428 454432 455120 455343 456098 457645 457839 457955 458981 459630 459847 460279 460651 460810 462816 463217 463347 463869 464036 464314 464429 465079 465224 465290 466150 466891 467728 469002 469013 471190 472505 472578 472933 473156 473851 474720 474825 474870 475368 475483 475811 476302 477104 478805 480058 481959 482098 485158 486809 487547 489272 489987 497402 498363 499187 499862 500635 500710 503317 505156 506346 510478 516838 517922 521778 524373 526799 527169 527884 527904 528054 528845 529424 529864 538665 542682 553096 569447 587489 599299 635977 710872 769575 771005 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge white tits"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные white сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромные white сиськ"
]
|
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.