Query Metrics
7
Database Queries
7
Different statements
241.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
218.36 ms (90.51%) |
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 446133 447967 451801 453620 453739 457672 460844 462320 462990 463029 464446 465861 467063 467218 467239 467917 469311 469574 470468 474099 474860 479412 481446 482260 485076 493826 494911 500044 503482 505764 505979 506520 506848 508772 510344 511796 511903 511984 512199 512881 515702 516062 517081 519224 519644 519967 520948 521574 522602 523076 524488 525071 525744 527373 527529 528346 529018 533724 533863 538576 545486 546047 549766 551667 551928 552514 552809 553305 553660 553955 554302 555546 555647 556844 557474 559097 559590 559980 560394 560407 560461 561679 564197 565187 565370 565976 566920 567686 569077 569444 569950 569969 570151 570732 576275 579568 579901 580285 580976 581419 587781 591045 592056 598684 599240 599801 613830 614890 618854 619127 664813 664966 665117 666436 675808 681879 682124 689376 702619 712765 ] |
||||||||||||||||||||||||||||||
|
12.55 ms (5.20%) |
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 447967 460844 465861 467917 469311 470468 474860 482260 451801 453620 462990 464446 467218 479412 481446 446133 453739 457672 463029 500044 505979 506848 511903 511984 512199 512881 517081 522602 525071 527373 533863 494911 505764 506520 508772 511796 519967 520948 525744 515702 519224 519644 523076 524488 529018 538576 503482 510344 516062 521574 527529 528346 533724 462320 467063 467239 469574 474099 485076 493826 546047 553955 555546 560394 569077 579901 580285 545486 549766 551928 552809 553305 557474 559980 560461 565976 580976 552514 553660 559590 561679 567686 569444 569950 569969 570151 576275 581419 664966 666436 675808 702619 712765 664813 682124 665117 681879 689376 551667 554302 555647 556844 559097 560407 564197 565187 565370 566920 570732 579568 587781 591045 599801 619127 592056 598684 599240 613830 614890 618854 ] |
||||||||||||||||||||||||||||||
|
3.75 ms (1.55%) |
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 446133 447967 451801 453620 453739 457672 460844 462320 462990 463029 464446 465861 467063 467218 467239 467917 469311 469574 470468 474099 474860 479412 481446 482260 485076 493826 494911 500044 503482 505764 505979 506520 506848 508772 510344 511796 511903 511984 512199 512881 515702 516062 517081 519224 519644 519967 520948 521574 522602 523076 524488 525071 525744 527373 527529 528346 529018 533724 533863 538576 545486 546047 549766 551667 551928 552514 552809 553305 553660 553955 554302 555546 555647 556844 557474 559097 559590 559980 560394 560407 560461 561679 564197 565187 565370 565976 566920 567686 569077 569444 569950 569969 570151 570732 576275 579568 579901 580285 580976 581419 587781 591045 592056 598684 599240 599801 613830 614890 618854 619127 664813 664966 665117 666436 675808 681879 682124 689376 702619 712765 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп юбк"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass skirt"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.67%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.60%) |
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.