Query Metrics
7
Database Queries
7
Different statements
191.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.16 ms (83.12%) |
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 182135 182232 183074 388862 392843 393313 397509 398025 398940 414104 414132 415878 416000 416693 416733 419439 419613 420295 421838 429859 430366 432927 439027 439343 439532 443086 447151 448257 457480 465132 466427 466633 468678 468946 469735 470034 470428 473366 475431 477246 478437 486243 488820 490387 497691 497697 513460 524346 525281 526504 529739 541442 545392 546129 546987 547470 547481 547494 550916 555020 561021 561038 562578 574664 576128 576932 576951 583385 589042 590803 595339 604228 604781 618231 619679 636948 640047 657489 658802 662165 662856 662886 665958 669079 669361 669376 669386 672925 672938 680252 692711 700975 703619 713501 713507 738126 738822 740932 742363 745128 749067 749221 752681 756233 766943 769567 770262 770383 770387 770817 770849 776713 776829 784775 785814 788192 792735 803122 803543 ] |
||||||||||||||||||||||||||||||
|
21.59 ms (11.28%) |
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 776713 769567 803122 388862 398025 475431 524346 672925 703619 662165 657489 662886 546129 604228 636948 756233 770383 513460 182232 414104 416693 416733 415878 419613 465132 468946 473366 478437 457480 470428 526504 497691 497697 466633 469735 547470 574664 576932 700975 590803 398940 421838 183074 529739 488820 692711 419439 432927 447151 497689 547481 541442 583385 545392 547494 561038 576128 669079 669361 669376 669386 561021 619679 595339 604781 443086 430366 477246 416000 470034 448257 546987 429859 439532 414132 770387 555020 439343 439027 490387 397509 525281 420295 468678 392843 576951 182135 393313 486243 466427 550916 562578 658802 662856 665958 672938 680252 713501 713507 589042 776829 785814 784775 788192 738126 740932 752681 803543 749067 749221 766943 770262 770817 770849 738822 742363 745128 618231 640047 792735 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.58%) |
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 182135 182232 183074 388862 392843 393313 397509 398025 398940 414104 414132 415878 416000 416693 416733 419439 419613 420295 421838 429859 430366 432927 439027 439343 439532 443086 447151 448257 457480 465132 466427 466633 468678 468946 469735 470034 470428 473366 475431 477246 478437 486243 488820 490387 497691 497697 513460 524346 525281 526504 529739 541442 545392 546129 546987 547470 547481 547494 550916 555020 561021 561038 562578 574664 576128 576932 576951 583385 589042 590803 595339 604228 604781 618231 619679 636948 640047 657489 658802 662165 662856 662886 665958 669079 669361 669376 669386 672925 672938 680252 692711 700975 703619 713501 713507 738126 738822 740932 742363 745128 749067 749221 752681 756233 766943 769567 770262 770383 770387 770817 770849 776713 776829 784775 785814 788192 792735 803122 803543 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo masturbation anal"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд мастурбац анал"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.84%) |
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.