Query Metrics
7
Database Queries
7
Different statements
163.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.23 ms (85.33%) |
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 11385 188507 188669 207918 233331 382420 386764 391928 409353 410253 411723 411761 424421 441788 441910 442088 465165 467413 470212 472671 476301 476454 484605 485156 486542 494565 506066 508196 509515 512878 522078 528573 529597 536408 537264 543646 546152 546784 553699 559200 561348 566535 575689 584201 600972 610044 610573 612927 614980 621339 627361 637492 680259 680431 686158 705360 707290 710826 714895 715085 716236 725397 726920 726976 726983 727778 729290 731254 733962 734469 735029 736776 736780 745711 746628 746699 747057 748256 750233 752984 753699 758281 759623 760695 760953 761021 761023 763547 768348 771361 781984 783428 784291 789107 790834 792804 792805 794797 794859 795141 795706 796134 796166 796718 799701 800608 801253 804750 805979 810195 812407 812523 814962 815116 817119 817366 817890 818186 824781 827037 ] |
||||||||||||||||||||||||||||||
|
13.58 ms (8.32%) |
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 465165 553699 566535 680259 561348 781984 789107 799701 810195 792805 795141 795706 805979 733962 734469 771361 760695 761023 747057 784291 790834 382420 386764 512878 537264 506066 707290 714895 716236 621339 637492 800608 763547 727778 731254 610044 614980 794797 411723 233331 522078 411761 486542 748256 627361 817366 817890 824781 485156 470212 584201 710826 610573 794859 812407 792804 729290 804750 812523 736780 759623 745711 752984 768348 761021 424421 207918 409353 827037 815116 508196 529597 546784 543646 686158 680431 705360 715085 546152 575689 612927 796134 801253 725397 736776 753699 796166 726920 726976 726983 746628 760953 735029 746699 750233 783428 796718 188507 391928 11385 441910 472671 536408 509515 559200 600972 758281 467413 476301 476454 484605 528573 188669 410253 441788 442088 814962 817119 818186 494565 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature slut"
]
|
||||||||||||||||||||||||||||||
|
2.32 ms (1.42%) |
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 11385 188507 188669 207918 233331 382420 386764 391928 409353 410253 411723 411761 424421 441788 441910 442088 465165 467413 470212 472671 476301 476454 484605 485156 486542 494565 506066 508196 509515 512878 522078 528573 529597 536408 537264 543646 546152 546784 553699 559200 561348 566535 575689 584201 600972 610044 610573 612927 614980 621339 627361 637492 680259 680431 686158 705360 707290 710826 714895 715085 716236 725397 726920 726976 726983 727778 729290 731254 733962 734469 735029 736776 736780 745711 746628 746699 747057 748256 750233 752984 753699 758281 759623 760695 760953 761021 761023 763547 768348 771361 781984 783428 784291 789107 790834 792804 792805 794797 794859 795141 795706 796134 796166 796718 799701 800608 801253 804750 805979 810195 812407 812523 814962 815116 817119 817366 817890 818186 824781 827037 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature slut"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature slut"
]
|
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.