Query Metrics
7
Database Queries
7
Different statements
168.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.90 ms (82.22%) |
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 385911 391247 393590 397916 400466 400865 401278 415966 416009 416663 417053 417464 418124 418607 419669 419900 420139 421094 421175 421810 421820 421856 422145 422212 423424 425206 426265 427362 427363 428425 428570 428883 431341 432760 432771 434361 435462 439151 439758 441619 441853 442913 443148 443218 443292 444073 444303 444834 445781 447425 447519 447877 448213 448961 450817 451152 451655 452187 452228 452531 452923 453347 454638 454812 455081 456179 457163 457432 457444 458761 459375 459397 460296 462850 462931 463864 464132 466445 469852 470256 470482 470561 473205 474170 474379 478009 478033 478847 478853 482570 484223 484313 488023 492109 493521 493919 496090 496603 497869 500725 500748 500912 502326 510964 516508 519889 521792 523322 538207 555129 555567 559181 567774 571012 584024 584085 600024 601478 647297 706676 ] |
||||||||||||||||||||||||||||||
|
19.43 ms (11.50%) |
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 706676 400865 419669 427362 428883 432760 434361 441619 443148 443292 448213 453347 457444 416663 421810 421856 428425 439758 452923 454812 456179 457432 470256 474170 474379 478033 391247 418607 421175 422145 439151 442913 444073 447519 452187 454638 478009 478853 397916 400466 401278 417464 426265 444303 447425 452531 478847 416009 419900 421820 422212 428570 447877 451655 459375 459397 460296 464132 466445 470482 470561 519889 484223 488023 496090 523322 484313 492109 493919 497869 500725 502326 521792 538207 385911 393590 415966 421094 423424 431341 432771 441853 427363 443218 417053 420139 425206 435462 444834 418124 445781 452228 482570 450817 455081 457163 458761 462931 463864 469852 448961 451152 462850 516508 496603 500912 510964 500748 473205 493521 571012 584024 584085 555129 555567 567774 647297 559181 601478 600024 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.75%) |
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 385911 391247 393590 397916 400466 400865 401278 415966 416009 416663 417053 417464 418124 418607 419669 419900 420139 421094 421175 421810 421820 421856 422145 422212 423424 425206 426265 427362 427363 428425 428570 428883 431341 432760 432771 434361 435462 439151 439758 441619 441853 442913 443148 443218 443292 444073 444303 444834 445781 447425 447519 447877 448213 448961 450817 451152 451655 452187 452228 452531 452923 453347 454638 454812 455081 456179 457163 457432 457444 458761 459375 459397 460296 462850 462931 463864 464132 466445 469852 470256 470482 470561 473205 474170 474379 478009 478033 478847 478853 482570 484223 484313 488023 492109 493521 493919 496090 496603 497869 500725 500748 500912 502326 510964 516508 519889 521792 523322 538207 555129 555567 559181 567774 571012 584024 584085 600024 601478 647297 706676 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"задн"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"задн"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.