Query Metrics
7
Database Queries
7
Different statements
199.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.70 ms (87.62%) |
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 187843 391170 391472 400812 400826 401200 401916 411332 411344 411371 421890 422199 422205 422342 424421 424428 424433 424455 428837 439521 439550 439574 439607 439696 440598 440993 443764 443791 444000 446894 448409 449428 451473 454175 464327 465075 465952 465955 466011 466242 466251 466272 466599 466872 467034 468076 470196 470202 470290 470527 470968 473139 473253 474652 474654 474686 474696 484558 484585 484651 484668 484678 484681 484692 484705 484730 484737 484748 484750 487362 489379 490202 490904 491463 491644 494516 497368 506056 509810 515969 519157 523019 526775 534208 536676 539010 539951 545755 546947 555912 560441 564542 567337 570708 590503 595458 597227 598505 598890 604018 612799 619513 636273 636274 646838 659409 662423 701498 710524 717708 733870 733879 739535 742143 762669 775819 796507 807340 821829 821851 ] |
||||||||||||||||||||||||||||||
|
15.73 ms (7.89%) |
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 187843 598505 391472 509810 411332 560441 612799 474686 411371 439696 473139 484748 484750 484730 539010 539951 564542 546947 567337 597227 598890 604018 733879 422199 439521 424428 465955 466599 474652 424421 466872 470196 440598 465075 428837 470527 489379 490202 515969 484558 484705 491644 494516 470290 523019 484692 796507 717708 821851 534208 701498 590503 636274 636273 807340 742143 775819 400826 473253 400812 444000 391170 451473 465952 466242 466272 490904 491463 484678 619513 443764 468076 401916 448409 466011 470202 422342 424433 474696 484651 484737 484668 662423 659409 646838 710524 733870 443791 401200 467034 470968 424455 439574 439607 449428 422205 497368 484585 519157 526775 545755 421890 821829 570708 739535 411344 762669 484681 555912 595458 536676 440993 464327 439550 466251 474654 446894 454175 506056 487362 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.23%) |
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 187843 391170 391472 400812 400826 401200 401916 411332 411344 411371 421890 422199 422205 422342 424421 424428 424433 424455 428837 439521 439550 439574 439607 439696 440598 440993 443764 443791 444000 446894 448409 449428 451473 454175 464327 465075 465952 465955 466011 466242 466251 466272 466599 466872 467034 468076 470196 470202 470290 470527 470968 473139 473253 474652 474654 474686 474696 484558 484585 484651 484668 484678 484681 484692 484705 484730 484737 484748 484750 487362 489379 490202 490904 491463 491644 494516 497368 506056 509810 515969 519157 523019 526775 534208 536676 539010 539951 545755 546947 555912 560441 564542 567337 570708 590503 595458 597227 598505 598890 604018 612799 619513 636273 636274 646838 659409 662423 701498 710524 717708 733870 733879 739535 742143 762669 775819 796507 807340 821829 821851 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal old russian"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал old русск"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал old русск"
]
|
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.