Query Metrics
7
Database Queries
7
Different statements
186.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.90 ms (84.71%) |
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 8713 38933 39142 75811 147148 163762 312919 350700 355294 382034 382728 383294 386686 386859 389122 390974 392765 393430 395142 396322 396441 397036 414736 415554 417043 418426 418438 419272 422106 423945 426389 427181 429504 430486 432412 432414 432426 432485 432493 432527 433234 433716 433904 433983 434220 434848 437161 438017 438020 441310 443522 443985 444607 446199 446812 447164 447252 450181 450363 453259 453269 455799 457027 457167 458999 461709 461842 465387 469402 471449 471748 479450 480522 481567 482896 483283 483724 485043 486361 486480 488541 489047 494241 494319 495881 497857 498735 501896 506891 506942 507018 511752 514757 517245 518817 524904 526234 527400 543284 543290 569935 578847 583406 592843 653790 698224 698235 726108 730687 739555 768418 783113 787195 788001 791016 792278 801860 808866 813045 820261 ] |
||||||||||||||||||||||||||||||
|
19.04 ms (10.21%) |
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 443522 583406 393430 788001 791016 423945 438017 395142 698224 514757 483724 350700 396441 433904 392765 453269 527400 414736 506942 8713 417043 455799 432527 147148 430486 426389 469402 446199 479450 480522 461842 432493 461709 501896 498735 453259 432412 163762 517245 447164 592843 38933 389122 482896 518817 465387 486361 507018 698235 578847 382034 730687 75811 443985 415554 438020 312919 457167 386686 429504 432414 481567 355294 427181 450181 437161 506891 483283 39142 418438 543290 422106 433234 383294 458999 419272 433716 526234 524904 488541 494319 446812 808866 801860 787195 396322 447252 485043 444607 494241 390974 653790 768418 432485 433983 489047 457027 434220 432426 397036 386859 569935 441310 471748 497857 418426 495881 382728 486480 471449 450363 511752 739555 726108 783113 813045 434848 820261 543284 792278 ] |
||||||||||||||||||||||||||||||
|
2.60 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 8713 38933 39142 75811 147148 163762 312919 350700 355294 382034 382728 383294 386686 386859 389122 390974 392765 393430 395142 396322 396441 397036 414736 415554 417043 418426 418438 419272 422106 423945 426389 427181 429504 430486 432412 432414 432426 432485 432493 432527 433234 433716 433904 433983 434220 434848 437161 438017 438020 441310 443522 443985 444607 446199 446812 447164 447252 450181 450363 453259 453269 455799 457027 457167 458999 461709 461842 465387 469402 471449 471748 479450 480522 481567 482896 483283 483724 485043 486361 486480 488541 489047 494241 494319 495881 497857 498735 501896 506891 506942 507018 511752 514757 517245 518817 524904 526234 527400 543284 543290 569935 578847 583406 592843 653790 698224 698235 726108 730687 739555 768418 783113 787195 788001 791016 792278 801860 808866 813045 820261 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"handjob boy"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк член парен"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.71%) |
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.