Query Metrics
7
Database Queries
7
Different statements
247.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
221.36 ms (89.33%) |
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 90718 341596 383599 389994 390766 391437 391559 405699 411132 419455 427112 429106 433110 434442 437088 439257 439264 445265 452825 456226 459163 461456 468527 473004 478092 483252 485234 486179 492169 493192 500341 503453 507376 509218 509997 510754 511002 511359 512509 512954 513502 514772 514940 516319 517217 517928 518918 524759 526152 526199 526895 526951 527237 528413 529342 530948 532643 535025 537042 541673 541871 542194 544478 545375 547241 551913 559377 560902 562482 562508 562790 563553 565122 566079 571445 574446 576649 576692 576721 577384 578406 580262 581254 582282 582810 583384 588228 588934 591341 596526 596748 597490 597692 598199 598513 599711 600531 601141 601996 602312 603386 604939 605414 605745 607233 613489 614441 615009 618868 621125 622938 628332 628397 645920 649134 659361 662382 680207 800718 814175 ] |
||||||||||||||||||||||||||||||
|
15.21 ms (6.14%) |
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 559377 601996 456226 591341 434442 514940 518918 578406 598513 614441 603386 468527 516319 560902 576721 576649 618868 605414 596748 513502 405699 574446 509218 512954 529342 571445 562508 433110 437088 473004 588228 507376 580262 390766 628397 485234 500341 577384 605745 662382 604939 517217 461456 511002 459163 526152 528413 545375 581254 800718 588934 814175 582810 565122 391559 512509 517928 486179 613489 527237 583384 389994 503453 493192 526951 649134 596526 511359 563553 526895 535025 514772 509997 566079 544478 445265 597692 439257 429106 510754 532643 680207 622938 537042 576692 562482 659361 391437 90718 411132 439264 427112 483252 597490 341596 542194 547241 628332 526199 599711 562790 541673 600531 530948 621125 478092 524759 419455 452825 551913 541871 383599 645920 601141 607233 615009 582282 602312 598199 492169 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (1.37%) |
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 90718 341596 383599 389994 390766 391437 391559 405699 411132 419455 427112 429106 433110 434442 437088 439257 439264 445265 452825 456226 459163 461456 468527 473004 478092 483252 485234 486179 492169 493192 500341 503453 507376 509218 509997 510754 511002 511359 512509 512954 513502 514772 514940 516319 517217 517928 518918 524759 526152 526199 526895 526951 527237 528413 529342 530948 532643 535025 537042 541673 541871 542194 544478 545375 547241 551913 559377 560902 562482 562508 562790 563553 565122 566079 571445 574446 576649 576692 576721 577384 578406 580262 581254 582282 582810 583384 588228 588934 591341 596526 596748 597490 597692 598199 598513 599711 600531 601141 601996 602312 603386 604939 605414 605745 607233 613489 614441 615009 618868 621125 622938 628332 628397 645920 649134 659361 662382 680207 800718 814175 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"палец анал"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"палец в попк"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.63%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.55%) |
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.