Query Metrics
7
Database Queries
7
Different statements
165.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.59 ms (85.53%) |
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 413376 413398 413406 414090 414350 414675 415758 415855 417787 418101 418138 423663 426259 434286 434307 434330 434332 434338 434344 437605 437791 438464 439112 443103 443635 447828 447844 449208 451064 452430 455312 458770 459342 462231 465054 465143 467946 471357 476773 479351 482704 486763 486779 491290 493258 494867 499791 500912 504731 510334 514115 514231 514404 515952 521424 521429 521656 522152 528057 530387 532739 534381 540348 542549 545117 545648 545677 549514 550672 550887 551631 552249 557570 559111 560402 560424 560879 560947 561863 562777 568998 570721 570978 582503 584158 587228 593815 596370 596693 599852 606549 609027 613530 617418 623736 624340 625177 625660 644276 651062 657804 665929 666475 680242 682417 693781 755079 762303 764909 776209 777924 786023 796678 798685 799960 806584 806688 807142 807594 ] |
||||||||||||||||||||||||||||||
|
15.09 ms (9.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 545677 657804 682417 777924 806584 807142 762303 786023 807594 796678 437791 414090 434330 582503 651062 666475 693781 665929 551631 552249 625660 798685 799960 418138 439112 459342 465143 510334 522152 528057 504731 521656 494867 570721 545117 596370 613530 437605 560424 560947 606549 434332 462231 434344 479351 521424 418101 438464 413406 423663 415758 467946 540348 570978 550672 550887 593815 625177 413398 413376 434338 493258 521429 568998 449208 455312 680242 776209 764909 415855 426259 458770 452430 491290 515952 534381 549514 560879 609027 447828 447844 451064 486763 514231 514404 596693 644276 414675 560402 584158 755079 806688 434286 443635 562777 414350 465054 500912 530387 545648 561863 617418 587228 599852 623736 807580 434307 443103 532739 514115 486779 417787 482704 559111 471357 499791 624340 542549 476773 557570 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.39%) |
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 413376 413398 413406 414090 414350 414675 415758 415855 417787 418101 418138 423663 426259 434286 434307 434330 434332 434338 434344 437605 437791 438464 439112 443103 443635 447828 447844 449208 451064 452430 455312 458770 459342 462231 465054 465143 467946 471357 476773 479351 482704 486763 486779 491290 493258 494867 499791 500912 504731 510334 514115 514231 514404 515952 521424 521429 521656 522152 528057 530387 532739 534381 540348 542549 545117 545648 545677 549514 550672 550887 551631 552249 557570 559111 560402 560424 560879 560947 561863 562777 568998 570721 570978 582503 584158 587228 593815 596370 596693 599852 606549 609027 613530 617418 623736 624340 625177 625660 644276 651062 657804 665929 666475 680242 682417 693781 755079 762303 764909 776209 777924 786023 796678 798685 799960 806584 806688 807142 807594 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"machine sperm"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"machine сперм"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"machine сперм"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.