Query Metrics
7
Database Queries
7
Different statements
159.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.00 ms (85.26%) |
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 183634 187775 187786 187789 188282 188373 188390 188437 233269 233667 239599 311237 358365 358466 358596 359011 368335 382405 382434 382937 384279 386044 387026 388713 388714 388719 388766 389223 389639 389729 390561 391287 392030 392054 392489 394211 395271 395927 397870 397882 398553 398959 404441 406067 410237 411408 411629 451488 453096 457991 465390 465949 466020 466231 466986 470201 472905 488362 547605 554322 560397 560430 563127 588077 591046 614476 614519 621314 648199 665219 666111 668684 668881 713635 716077 716586 717711 720341 720591 721377 721449 721463 721706 722240 726556 728240 728305 730352 732258 735863 736386 744993 746168 759807 759818 759929 774144 774766 777186 781649 781652 781686 781702 781731 781747 782154 782186 785848 788565 789292 789539 790955 794705 817208 818593 823915 824023 824263 824937 826317 ] |
||||||||||||||||||||||||||||||
|
13.73 ms (8.61%) |
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 188437 465949 397870 359011 382405 554322 790955 389639 394211 411408 187789 188390 823915 721377 721449 728305 736386 187775 457991 466986 563127 591046 451488 466231 387026 759807 781747 789292 716586 774766 382937 239599 721706 781649 774144 732258 392489 397882 560430 818593 188282 668881 404441 390561 547605 588077 187786 398553 388766 391287 392054 472905 358466 389223 735863 785848 358365 233667 406067 824263 824937 666111 720591 794705 759929 782186 744993 746168 777186 392030 395927 368335 311237 716077 781731 728240 453096 382434 358596 466020 470201 488362 395271 824023 665219 721463 720341 614476 614519 781702 788565 717711 722240 781652 781686 233269 388714 398959 183634 411629 817208 668684 560397 789539 782154 188373 386044 384279 713635 826317 648199 726556 388713 410237 389729 465390 621314 388719 730352 759818 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.86%) |
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 183634 187775 187786 187789 188282 188373 188390 188437 233269 233667 239599 311237 358365 358466 358596 359011 368335 382405 382434 382937 384279 386044 387026 388713 388714 388719 388766 389223 389639 389729 390561 391287 392030 392054 392489 394211 395271 395927 397870 397882 398553 398959 404441 406067 410237 411408 411629 451488 453096 457991 465390 465949 466020 466231 466986 470201 472905 488362 547605 554322 560397 560430 563127 588077 591046 614476 614519 621314 648199 665219 666111 668684 668881 713635 716077 716586 717711 720341 720591 721377 721449 721463 721706 722240 726556 728240 728305 730352 732258 735863 736386 744993 746168 759807 759818 759929 774144 774766 777186 781649 781652 781686 781702 781731 781747 782154 782186 785848 788565 789292 789539 790955 794705 817208 818593 823915 824023 824263 824937 826317 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck mature"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс mature"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс mature"
]
|
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.