Query Metrics
7
Database Queries
7
Different statements
435.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.60 ms (49.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young red"
]
|
||||||||||||||||||||||||||||||
|
193.60 ms (44.46%) |
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 94308 233224 328446 383273 385026 388647 388739 395565 395704 395924 397917 401804 407722 407727 411626 411727 411729 426558 443800 452369 461428 469484 470538 474843 476679 480439 484556 487315 491503 504272 508162 515170 515175 517014 519469 524322 528456 528851 529602 530143 530328 530537 533613 537845 542467 542957 550024 554321 558013 560577 560699 563137 565430 567719 576655 583542 599496 601952 602625 602942 602947 603587 608354 609274 614518 618404 622794 627726 630840 631970 649940 651887 651945 659396 665444 665487 666780 673608 682199 693299 693956 724702 725369 727924 728244 742507 746340 776845 778699 781733 781761 782155 782159 782194 782246 784669 786462 788293 788879 790207 790493 792637 798681 801864 802431 802453 803091 803093 803398 806381 807324 809313 816536 816755 817010 818208 818651 819621 820306 820715 ] |
||||||||||||||||||||||||||||||
|
18.07 ms (4.15%) |
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 480439 484556 524322 487315 491503 515170 515175 517014 519469 383273 385026 395565 94308 397917 401804 411727 820306 818651 819621 816536 820715 452369 537845 474843 542467 651945 665487 649940 560699 565430 618404 801864 807324 790207 802431 802453 782159 784669 786462 724702 728244 742507 746340 782155 782246 792637 809313 233224 443800 461428 528456 533613 395924 395704 328446 388739 388647 411626 411729 426558 407727 407722 816755 817010 818208 469484 470538 476679 530143 529602 530328 530537 528851 504272 508162 567719 583542 542957 550024 554321 576655 673608 682199 693299 693956 651887 659396 665444 666780 558013 560577 563137 609274 599496 601952 602625 602942 603587 608354 622794 627726 631970 630840 602947 614518 781733 788879 798681 803398 806381 776845 778699 781761 782194 788293 790493 803091 803093 725369 727924 ] |
||||||||||||||||||||||||||||||
|
3.19 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 94308 233224 328446 383273 385026 388647 388739 395565 395704 395924 397917 401804 407722 407727 411626 411727 411729 426558 443800 452369 461428 469484 470538 474843 476679 480439 484556 487315 491503 504272 508162 515170 515175 517014 519469 524322 528456 528851 529602 530143 530328 530537 533613 537845 542467 542957 550024 554321 558013 560577 560699 563137 565430 567719 576655 583542 599496 601952 602625 602942 602947 603587 608354 609274 614518 618404 622794 627726 630840 631970 649940 651887 651945 659396 665444 665487 666780 673608 682199 693299 693956 724702 725369 727924 728244 742507 746340 776845 778699 781733 781761 782155 782159 782194 782246 784669 786462 788293 788879 790207 790493 792637 798681 801864 802431 802453 803091 803093 803398 806381 807324 809313 816536 816755 817010 818208 818651 819621 820306 820715 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.18 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young red"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young red"
]
|
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.