Query Metrics
7
Database Queries
7
Different statements
149.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.10 ms (82.19%) |
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 386535 386771 387858 387973 391934 392903 395922 396673 397918 399416 399909 400638 401101 401928 401989 403654 405702 406377 406391 407532 407753 409166 411353 411513 411580 413464 414104 414201 414317 415753 415873 415965 416561 416632 416644 416914 417006 417090 418345 418640 418741 418757 418923 418989 419146 419836 420392 420586 421073 421100 421153 421536 422182 422233 422349 422642 422666 422909 423042 423382 423481 423941 424486 425154 425170 425181 425849 426354 426680 427273 427737 428643 429441 429445 431501 433716 433885 435350 435999 437803 437968 438226 438411 438742 439499 440664 441237 441355 442271 442847 443064 443131 443198 443412 443945 443998 444103 444115 444213 444326 444732 445106 445256 445411 445747 445963 446750 447449 447588 448578 448646 449186 449206 450666 451008 451693 452206 452285 453580 454468 ] |
||||||||||||||||||||||||||||||
|
17.63 ms (11.77%) |
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 399416 399909 409166 415873 416914 419836 423382 433885 447449 411513 437968 442271 444115 445747 386771 387858 397918 407532 414317 417006 418640 425181 438226 414104 414201 416632 418345 418741 421100 426354 431501 444732 445106 443064 443198 443412 444326 418923 422909 443131 415753 419146 423042 440664 445963 448578 453580 448646 451008 407753 413464 420586 424486 425849 427737 429445 438411 451693 395922 396673 401101 417090 418757 422642 425170 427273 447588 452285 416644 422666 423941 433716 442847 444103 444213 445411 386535 387973 405702 411580 422182 426680 435999 443998 422349 445256 449186 392903 400638 401989 406377 406391 403654 418989 421536 429441 439499 411353 416561 423481 425154 437803 441237 441355 435350 415965 421153 438742 446750 449206 454468 450666 452206 420392 421073 422233 443945 391934 401928 428643 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.79%) |
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 386535 386771 387858 387973 391934 392903 395922 396673 397918 399416 399909 400638 401101 401928 401989 403654 405702 406377 406391 407532 407753 409166 411353 411513 411580 413464 414104 414201 414317 415753 415873 415965 416561 416632 416644 416914 417006 417090 418345 418640 418741 418757 418923 418989 419146 419836 420392 420586 421073 421100 421153 421536 422182 422233 422349 422642 422666 422909 423042 423382 423481 423941 424486 425154 425170 425181 425849 426354 426680 427273 427737 428643 429441 429445 431501 433716 433885 435350 435999 437803 437968 438226 438411 438742 439499 440664 441237 441355 442271 442847 443064 443131 443198 443412 443945 443998 444103 444115 444213 444326 444732 445106 445256 445411 445747 445963 446750 447449 447588 448578 448646 449186 449206 450666 451008 451693 452206 452285 453580 454468 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"блядью"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бляд"
]
|
||||||||||||||||||||||||||||||
|
1.21 ms (0.81%) |
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.