Query Metrics
7
Database Queries
7
Different statements
210.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
188.16 ms (89.42%) |
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 23104 82217 168687 185563 186171 205011 273182 354774 382466 382874 384472 385082 387304 388113 388945 389475 392423 398105 406907 429546 458834 460952 460953 460956 473060 477406 478425 491448 491452 499485 512178 512180 512193 512220 512955 516430 519956 521230 522193 523399 523560 528593 533126 533129 533136 538657 550138 550776 551028 551949 551972 552897 552917 554415 556389 556398 556409 558391 558423 558426 558427 558431 559855 559873 559896 559917 559920 565475 565483 566012 572737 574642 575276 576536 582908 583298 585381 593431 598515 600806 603458 619427 619433 619438 622336 622624 622646 623568 634877 637737 640685 673041 694193 694200 709649 711290 712164 713474 715293 722426 731503 734995 736172 737107 737136 742126 742486 742925 749551 750378 755824 761271 763322 767287 771601 772085 772105 792763 805919 810369 ] |
||||||||||||||||||||||||||||||
|
13.15 ms (6.25%) |
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 761271 772105 792763 772085 750378 622624 711290 713474 205011 737136 771601 387304 458834 168687 429546 354774 392423 23104 473060 512220 516430 538657 523399 512180 521230 533126 499485 528593 460953 491452 558391 574642 583298 551028 551972 556409 575276 556398 582908 550138 550776 551949 552897 558426 558431 559855 559873 600806 619433 593431 598515 637737 585381 640685 382874 273182 491448 512178 522193 558423 565483 566012 559896 559917 559920 694193 715293 673041 694200 709649 576536 622336 634877 603458 619438 619427 731503 763322 810369 736172 742126 749551 755824 742925 734995 742486 622646 623568 712164 722426 805919 737107 406907 82217 384472 385082 185563 186171 388945 388113 398105 460952 460956 477406 382466 389475 767287 478425 512955 519956 533129 533136 512193 523560 552917 554415 572737 556389 558427 565475 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.22%) |
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 23104 82217 168687 185563 186171 205011 273182 354774 382466 382874 384472 385082 387304 388113 388945 389475 392423 398105 406907 429546 458834 460952 460953 460956 473060 477406 478425 491448 491452 499485 512178 512180 512193 512220 512955 516430 519956 521230 522193 523399 523560 528593 533126 533129 533136 538657 550138 550776 551028 551949 551972 552897 552917 554415 556389 556398 556409 558391 558423 558426 558427 558431 559855 559873 559896 559917 559920 565475 565483 566012 572737 574642 575276 576536 582908 583298 585381 593431 598515 600806 603458 619427 619433 619438 622336 622624 622646 623568 634877 637737 640685 673041 694193 694200 709649 711290 712164 713474 715293 722426 731503 734995 736172 737107 737136 742126 742486 742925 749551 750378 755824 761271 763322 767287 771601 772085 772105 792763 805919 810369 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian japanese"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк японк азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.66%) |
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.