Query Metrics
7
Database Queries
7
Different statements
163.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.15 ms (85.07%) |
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 398261 398429 403921 417154 418560 421718 422420 428738 434571 444933 451309 452567 452735 452737 452738 455585 490538 493770 497417 510071 512486 540975 541259 549087 549091 559083 575041 579650 581505 586970 591765 593745 598482 611491 617100 618782 619171 619612 620974 625292 625985 628801 629179 631116 631521 634371 634990 639092 648178 656603 661658 664214 669309 682397 684404 698847 707143 712582 715404 717546 719303 720101 720164 720419 720996 726297 726869 728326 729312 734626 735516 735719 737186 738835 739230 739804 740295 741106 744750 748901 749793 750147 751213 755006 757347 759602 760513 761009 761098 761177 761462 762934 763087 763415 765095 765262 765449 767417 769041 769045 769064 771172 775686 777559 777649 779979 781355 783087 784281 788199 791220 791285 794004 794039 794154 800799 805647 809859 816649 816810 ] |
||||||||||||||||||||||||||||||
|
14.18 ms (8.67%) |
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 805647 809859 729312 761098 761462 769045 761009 765095 726297 738835 728326 735719 739230 739804 744750 749793 760513 761177 777649 784281 788199 794039 422420 455585 720164 444933 403921 418560 490538 510071 625985 634371 398429 421718 417154 816810 816649 712582 717546 707143 719303 720419 779979 791285 794004 777559 781355 783087 791220 765262 748901 751213 759602 763087 767417 741106 715404 775686 794154 591765 398261 619171 619612 800799 428738 452567 434571 512486 497417 540975 452738 451309 452735 549087 579650 648178 656603 664214 669309 698847 682397 684404 598482 628801 631116 639092 586970 593745 617100 611491 620974 625292 618782 629179 737186 631521 634990 541259 559083 581505 549091 661658 493770 452737 575041 720101 720996 734626 757347 769041 740295 763415 769064 726869 765449 735516 762934 771172 750147 755006 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.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 398261 398429 403921 417154 418560 421718 422420 428738 434571 444933 451309 452567 452735 452737 452738 455585 490538 493770 497417 510071 512486 540975 541259 549087 549091 559083 575041 579650 581505 586970 591765 593745 598482 611491 617100 618782 619171 619612 620974 625292 625985 628801 629179 631116 631521 634371 634990 639092 648178 656603 661658 664214 669309 682397 684404 698847 707143 712582 715404 717546 719303 720101 720164 720419 720996 726297 726869 728326 729312 734626 735516 735719 737186 738835 739230 739804 740295 741106 744750 748901 749793 750147 751213 755006 757347 759602 760513 761009 761098 761177 761462 762934 763087 763415 765095 765262 765449 767417 769041 769045 769064 771172 775686 777559 777649 779979 781355 783087 784281 788199 791220 791285 794004 794039 794154 800799 805647 809859 816649 816810 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск teen tight"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск teen tight"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur teen tight"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.