Query Metrics
7
Database Queries
7
Different statements
537.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
300.82 ms (55.95%) |
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 16974 162863 168687 375092 383926 384196 384494 385039 389262 392068 393333 395689 396146 398497 399224 399412 399806 401751 402185 404391 405730 407250 407335 407492 408776 408795 409732 410814 411443 413999 419056 419066 420651 426138 427513 429583 437403 438911 439470 441334 441424 445136 446250 447834 447970 448321 449990 451292 453699 453897 455073 455783 456536 456635 458583 458711 459092 460962 461180 461676 462065 462960 463735 466422 470334 472349 474199 476313 477569 479200 485425 492145 494888 497466 503536 506826 508035 510901 514747 518177 519847 524231 527279 528336 528566 528762 531265 533118 538951 539098 540603 547629 551522 551540 551599 552956 558780 559928 561476 565114 567595 580267 582435 585319 585864 588083 589678 604885 627056 648958 653786 665332 674369 674637 675801 678926 757713 796300 802333 813316 ] |
||||||||||||||||||||||||||||||
|
226.61 ms (42.15%) |
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 458583 446250 447970 528762 462065 407335 384494 459092 506826 396146 399412 401751 405730 413999 419056 466422 510901 533118 460962 653786 398497 474199 449990 407492 427513 461676 476313 463735 531265 518177 462960 675801 561476 567595 580267 588083 453699 389262 458711 445136 508035 485425 514747 399224 410814 477569 492145 453897 547629 582435 559928 558780 419066 408795 383926 16974 409732 420651 429583 456635 447834 455073 494888 539098 528336 524231 528566 551522 551599 552956 678926 565114 796300 813316 426138 407250 461180 470334 472349 497466 451292 456536 503536 479200 437403 393333 402185 404391 439470 441424 648958 674637 665332 674369 585319 757713 627056 802333 162863 399806 408776 168687 395689 375092 441334 438911 455783 519847 540603 538951 527279 551540 604885 585864 589678 411443 448321 384196 385039 392068 ] |
||||||||||||||||||||||||||||||
|
3.82 ms (0.71%) |
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 16974 162863 168687 375092 383926 384196 384494 385039 389262 392068 393333 395689 396146 398497 399224 399412 399806 401751 402185 404391 405730 407250 407335 407492 408776 408795 409732 410814 411443 413999 419056 419066 420651 426138 427513 429583 437403 438911 439470 441334 441424 445136 446250 447834 447970 448321 449990 451292 453699 453897 455073 455783 456536 456635 458583 458711 459092 460962 461180 461676 462065 462960 463735 466422 470334 472349 474199 476313 477569 479200 485425 492145 494888 497466 503536 506826 508035 510901 514747 518177 519847 524231 527279 528336 528566 528762 531265 533118 538951 539098 540603 547629 551522 551540 551599 552956 558780 559928 561476 565114 567595 580267 582435 585319 585864 588083 589678 604885 627056 648958 653786 665332 674369 674637 675801 678926 757713 796300 802333 813316 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член соск"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"хуй соска"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.27%) |
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.