Query Metrics
7
Database Queries
7
Different statements
188.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.12 ms (85.49%) |
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 233488 383987 420267 429762 429898 430081 430357 430504 431962 432131 442398 442830 443103 443636 446633 447803 447851 448034 448987 451804 456690 460412 463764 464623 467613 468433 470527 471165 472784 475194 477339 477470 477554 478832 483536 484636 484818 485597 486685 486706 487746 491473 491664 492273 494276 495397 497866 505398 506195 507241 508156 509810 509879 512447 512538 513155 515329 516141 516752 516763 516765 516769 516776 517033 517464 517847 518003 518206 518558 519108 519572 519985 520037 521738 522130 522871 523567 524948 528791 529855 530053 530487 532912 533844 534334 537584 537595 543868 545785 550093 550097 556774 557941 558601 561136 561140 561142 561814 566135 567347 572005 576219 583670 583722 593863 605636 610692 610786 621962 624290 640770 644691 649542 650380 652263 688369 724823 766146 789862 815275 ] |
||||||||||||||||||||||||||||||
|
17.61 ms (9.34%) |
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 518003 491664 383987 431962 815275 483536 519108 522130 515329 517464 532912 477470 550093 566135 610692 766146 451804 429898 507241 516141 523567 430504 429762 447851 494276 516776 460412 556774 561142 557941 583722 448034 448987 561140 621962 644691 470527 446633 430357 513155 442830 432131 509879 522871 572005 517033 789862 463764 495397 512447 567347 471165 650380 558601 610786 233488 520037 652263 420267 516763 576219 528791 530053 467613 724823 468433 475194 486706 497866 492273 524948 516765 550097 583670 624290 593863 605636 472784 430081 505398 443103 477554 519985 506195 517847 530487 533844 688369 561814 640770 447803 518206 477339 464623 529855 516752 521738 545785 561136 484636 484818 508156 443636 534334 537595 518558 478832 485597 512538 649542 487746 516769 543868 456690 537584 509810 491473 442398 486685 519572 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.57%) |
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 233488 383987 420267 429762 429898 430081 430357 430504 431962 432131 442398 442830 443103 443636 446633 447803 447851 448034 448987 451804 456690 460412 463764 464623 467613 468433 470527 471165 472784 475194 477339 477470 477554 478832 483536 484636 484818 485597 486685 486706 487746 491473 491664 492273 494276 495397 497866 505398 506195 507241 508156 509810 509879 512447 512538 513155 515329 516141 516752 516763 516765 516769 516776 517033 517464 517847 518003 518206 518558 519108 519572 519985 520037 521738 522130 522871 523567 524948 528791 529855 530053 530487 532912 533844 534334 537584 537595 543868 545785 550093 550097 556774 557941 558601 561136 561140 561142 561814 566135 567347 572005 576219 583670 583722 593863 605636 610692 610786 621962 624290 640770 644691 649542 650380 652263 688369 724823 766146 789862 815275 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"threesome bdsm"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс втро бдсм"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.70%) |
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.