Query Metrics
7
Database Queries
7
Different statements
389.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.26 ms (54.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"japanese girl"
]
|
||||||||||||||||||||||||||||||
|
156.69 ms (40.18%) |
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 70745 273182 384472 387304 392423 415036 429546 473060 478425 491452 499485 512178 512180 512193 512213 512220 519956 521230 522193 523399 523560 528593 533129 533136 550721 550776 551002 551972 552898 552917 552930 552944 554415 556398 556409 558423 558426 558427 558430 559849 559853 559855 559856 559863 559866 559873 559896 559897 564595 565475 565483 566003 572725 572732 574642 575276 576536 576991 582908 583298 586623 588390 590949 590958 590960 591849 593431 596394 598515 600806 603191 603458 610669 613857 619427 619431 619433 620943 622336 622337 622615 622626 622643 622646 622654 623568 634877 637737 640685 643028 650945 660979 673041 675827 693148 694193 694199 709649 711290 712164 713474 721756 722426 736172 742126 742469 742486 742925 746624 747055 749551 755824 761271 771601 772085 772105 788141 792763 805776 810369 ] |
||||||||||||||||||||||||||||||
|
12.90 ms (3.31%) |
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 788141 746624 622337 622626 551972 575276 564595 805776 551002 558430 559849 693148 622643 747055 772105 792763 713474 415036 473060 523399 528593 556398 590949 619433 593431 598515 576536 70745 565483 736172 712164 694199 675827 761271 772085 711290 273182 709649 622336 622646 552917 613857 610669 392423 552898 512220 512180 521230 499485 491452 574642 583298 556409 582908 550776 558426 559855 559873 600806 637737 640685 576991 478425 533136 554415 591849 512178 558423 559896 694193 673041 634877 619427 810369 742126 749551 742925 623568 722426 512193 558427 559856 590958 590960 603191 387304 429546 586623 771601 512213 519956 533129 523560 565475 572732 550721 566003 559866 559897 643028 620943 552944 559853 660979 622615 522193 552930 603458 755824 742486 384472 559863 572725 650945 588390 596394 619431 622654 742469 721756 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (0.73%) |
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 70745 273182 384472 387304 392423 415036 429546 473060 478425 491452 499485 512178 512180 512193 512213 512220 519956 521230 522193 523399 523560 528593 533129 533136 550721 550776 551002 551972 552898 552917 552930 552944 554415 556398 556409 558423 558426 558427 558430 559849 559853 559855 559856 559863 559866 559873 559896 559897 564595 565475 565483 566003 572725 572732 574642 575276 576536 576991 582908 583298 586623 588390 590949 590958 590960 591849 593431 596394 598515 600806 603191 603458 610669 613857 619427 619431 619433 620943 622336 622337 622615 622626 622643 622646 622654 623568 634877 637737 640685 643028 650945 660979 673041 675827 693148 694193 694199 709649 711290 712164 713474 721756 722426 736172 742126 742469 742486 742925 746624 747055 749551 755824 761271 771601 772085 772105 788141 792763 805776 810369 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"японк азиатк девушк"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.