Query Metrics
7
Database Queries
7
Different statements
188.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.34 ms (86.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 82252 387846 404330 415524 423646 428826 458753 462782 466704 471378 477881 495980 511422 516230 518238 523484 525092 526888 528965 529025 529190 532898 535733 536125 538197 538213 538218 538232 538376 538400 538401 542525 543839 546603 551236 558496 558947 564631 564633 566318 571633 571649 573000 573023 573102 573419 573583 573596 573623 573653 573656 573669 573711 573716 573838 573841 573845 573846 573861 573876 573892 573896 573897 573901 573956 573969 574830 574848 574902 575160 575474 575495 575757 576059 576081 576084 576695 581594 591658 594942 598815 601163 601840 605950 606500 606680 613217 621716 629288 632918 634526 635902 636821 637662 653494 662043 664545 666331 669218 696227 697474 705434 714757 715397 720105 723674 735502 745527 747771 747785 762065 766419 777973 789283 798063 800201 801894 802165 803831 809121 ] |
||||||||||||||||||||||||||||||
|
14.08 ms (7.48%) |
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 576081 605950 629288 637662 594942 632918 591658 601163 601840 606500 613217 634526 636821 789283 802165 803831 798063 800201 809121 745527 747771 723674 735502 747785 766419 762065 621716 635902 777973 801894 387846 466704 415524 423646 462782 458753 528965 538232 529025 538218 538400 523484 535733 538197 538376 538401 495980 538213 532898 576695 542525 669218 606680 471378 477881 428826 404330 511422 526888 518238 525092 516230 82252 536125 529190 571649 573596 573669 573841 575495 575757 546603 558496 564633 573102 573711 573845 573896 573956 573969 574848 575160 581594 543839 558947 566318 571633 573716 573838 573846 573861 573892 573901 574830 576084 666331 705434 714757 720105 653494 664545 696227 697474 715397 662043 551236 564631 573000 573023 573419 573583 573623 573653 573656 573876 573897 574902 575474 576059 598815 ] |
||||||||||||||||||||||||||||||
|
3.43 ms (1.82%) |
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 82252 387846 404330 415524 423646 428826 458753 462782 466704 471378 477881 495980 511422 516230 518238 523484 525092 526888 528965 529025 529190 532898 535733 536125 538197 538213 538218 538232 538376 538400 538401 542525 543839 546603 551236 558496 558947 564631 564633 566318 571633 571649 573000 573023 573102 573419 573583 573596 573623 573653 573656 573669 573711 573716 573838 573841 573845 573846 573861 573876 573892 573896 573897 573901 573956 573969 574830 574848 574902 575160 575474 575495 575757 576059 576081 576084 576695 581594 591658 594942 598815 601163 601840 605950 606500 606680 613217 621716 629288 632918 634526 635902 636821 637662 653494 662043 664545 666331 669218 696227 697474 705434 714757 715397 720105 723674 735502 745527 747771 747785 762065 766419 777973 789283 798063 800201 801894 802165 803831 809121 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"porn beauty"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"porn beauty"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"porn beauty"
]
|
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.