Query Metrics
7
Database Queries
7
Different statements
156.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.03 ms (83.90%) |
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 393775 397766 410864 411635 415836 416128 420586 422071 422476 423120 423540 423937 424227 427155 432394 432466 436427 436933 440139 450145 450171 450544 450657 452370 452657 452663 453835 455189 455579 455854 458033 459453 460544 460561 461198 461262 469655 474939 478307 479343 483867 484977 488807 491017 493846 495483 495999 496230 496881 496902 497193 499149 502239 504703 505077 505378 507000 509330 510088 511841 512232 513474 516606 520201 521530 522578 523055 525122 526308 526369 527549 527655 527742 528176 541378 552350 553663 554847 557034 557400 559319 559618 560852 561314 569928 571504 571703 571713 574170 578827 591900 594023 595001 595751 595978 601237 602701 604080 605841 607154 607359 613543 616816 617139 624481 631684 666971 671685 681370 696450 711074 721967 747036 761258 763522 805274 809647 818701 824918 828672 ] |
||||||||||||||||||||||||||||||
|
14.85 ms (9.51%) |
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 459453 516606 422071 423540 411635 453835 455189 605841 616816 671685 504703 491017 507000 602701 631684 613543 420586 488807 553663 559319 571713 607359 624481 747036 436427 528176 495483 496881 526308 460561 416128 559618 594023 591900 461262 510088 397766 423937 557034 763522 574170 455854 595751 601237 423120 666971 571703 721967 427155 499149 505378 497193 493846 809647 496902 523055 450145 571504 561314 410864 450657 422476 452370 512232 521530 522578 505077 527549 578827 495999 554847 557400 595978 424227 818701 455579 496230 461198 483867 450171 460544 432466 511841 458033 617139 607154 805274 560852 432394 569928 469655 474939 478307 527655 393775 696450 452657 509330 502239 711074 525122 552350 681370 595001 452663 479343 436933 604080 541378 526369 450544 484977 527742 513474 761258 520201 415836 440139 824918 828672 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (1.97%) |
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 393775 397766 410864 411635 415836 416128 420586 422071 422476 423120 423540 423937 424227 427155 432394 432466 436427 436933 440139 450145 450171 450544 450657 452370 452657 452663 453835 455189 455579 455854 458033 459453 460544 460561 461198 461262 469655 474939 478307 479343 483867 484977 488807 491017 493846 495483 495999 496230 496881 496902 497193 499149 502239 504703 505077 505378 507000 509330 510088 511841 512232 513474 516606 520201 521530 522578 523055 525122 526308 526369 527549 527655 527742 528176 541378 552350 553663 554847 557034 557400 559319 559618 560852 561314 569928 571504 571703 571713 574170 578827 591900 594023 595001 595751 595978 601237 602701 604080 605841 607154 607359 613543 616816 617139 624481 631684 666971 671685 681370 696450 711074 721967 747036 761258 763522 805274 809647 818701 824918 828672 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob with cum"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс cum"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс cum"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.04%) |
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.