Query Metrics
7
Database Queries
7
Different statements
188.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.54 ms (85.24%) |
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 13282 187851 188031 211045 305824 366354 381929 382398 382926 387284 388578 388930 389819 390857 391017 392013 392181 392480 395988 397601 397919 398615 401807 402042 405811 407732 417070 417238 417370 418052 418072 418530 420277 421817 425150 426998 427655 427911 428064 428089 429834 432408 432470 433619 437148 439292 439808 441583 441770 441957 442623 445240 447160 452290 454468 454472 454701 454957 455352 456166 456338 459638 460348 460377 460545 463991 467028 468211 468291 468495 469147 472299 473431 473471 475177 475853 477144 483635 485429 496891 500377 502696 503476 506233 509151 509264 514755 515596 519122 527197 532306 549725 579711 580572 584939 588439 591705 626186 642563 645481 646421 715444 720051 728060 728337 738396 738419 742494 742633 749621 759747 769292 781994 789162 795566 795998 796503 803875 806944 811708 ] |
||||||||||||||||||||||||||||||
|
17.14 ms (9.10%) |
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 515596 439292 519122 389819 532306 381929 591705 477144 305824 459638 13282 456166 468291 460377 475177 769292 397919 426998 433619 417370 387284 395988 549725 421817 646421 432470 472299 418052 720051 427911 496891 728060 473471 781994 580572 738419 454468 447160 418530 429834 460348 485429 382398 509264 502696 759747 749621 392480 417238 452290 742633 469147 427655 432408 390857 366354 401807 503476 188031 441583 467028 514755 397601 407732 460545 392013 428089 506233 588439 468495 509151 500377 420277 439808 391017 579711 645481 715444 584939 626186 642563 796503 811708 803875 738396 742494 795566 463991 402042 417070 454472 454701 795998 211045 468211 425150 789162 728337 437148 483635 428064 806944 382926 187851 455352 473431 398615 475853 445240 388578 441770 442623 441957 418072 405811 454957 388930 456338 527197 392181 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.58%) |
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 13282 187851 188031 211045 305824 366354 381929 382398 382926 387284 388578 388930 389819 390857 391017 392013 392181 392480 395988 397601 397919 398615 401807 402042 405811 407732 417070 417238 417370 418052 418072 418530 420277 421817 425150 426998 427655 427911 428064 428089 429834 432408 432470 433619 437148 439292 439808 441583 441770 441957 442623 445240 447160 452290 454468 454472 454701 454957 455352 456166 456338 459638 460348 460377 460545 463991 467028 468211 468291 468495 469147 472299 473431 473471 475177 475853 477144 483635 485429 496891 500377 502696 503476 506233 509151 509264 514755 515596 519122 527197 532306 549725 579711 580572 584939 588439 591705 626186 642563 645481 646421 715444 720051 728060 728337 738396 738419 742494 742633 749621 759747 769292 781994 789162 795566 795998 796503 803875 806944 811708 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"толстую задница раком…"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"толстая жоп рак"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.