Query Metrics
7
Database Queries
7
Different statements
172.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.69 ms (87.50%) |
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 12326 193890 393972 395392 408730 411817 457177 470837 531964 533657 544482 554508 557311 559917 565815 566070 586711 591895 600881 603288 608355 609653 613383 613792 618473 620245 625597 626730 630597 654353 664267 665200 666659 667207 669225 669435 669890 671660 674752 688016 693388 696977 700536 707981 708469 709797 717188 718143 721039 721091 721276 721388 721438 722116 722181 723980 724090 726016 729664 732144 739188 740272 741620 747057 747912 748320 748451 752535 753476 754872 755436 755794 757324 757754 758050 759919 769199 773166 775004 776635 777889 779651 781185 781224 782170 782284 782695 786944 787207 791630 794616 794710 795475 797854 800177 800463 801337 804037 804217 806238 807171 809249 810399 810866 810918 811937 812171 813795 815011 817679 820736 821183 821625 821923 822242 822701 826745 826996 827372 827832 ] |
||||||||||||||||||||||||||||||
|
12.48 ms (7.25%) |
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 722181 600881 757754 193890 813795 821923 654353 669435 718143 688016 591895 782284 810399 810866 804217 807171 781185 669225 671660 693388 696977 723980 800463 782170 809249 815011 817679 826745 826996 827372 820736 821183 821625 822701 827832 544482 557311 559917 708469 721091 665200 666659 674752 667207 709797 717188 722116 586711 613383 608355 776635 787207 791630 781224 794616 800177 806238 726016 739188 752535 769199 794710 724090 748320 755436 740272 741620 753476 773166 732144 754872 747057 748451 757324 758050 603288 721276 721388 777889 795475 801337 804037 812171 411817 393972 620245 797854 12326 822242 531964 707981 779651 721039 408730 554508 613792 782695 729664 669890 759919 395392 747912 664267 470837 533657 565815 609653 775004 457177 566070 700536 721438 626730 618473 625597 630597 786944 755794 810918 811937 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.54%) |
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 12326 193890 393972 395392 408730 411817 457177 470837 531964 533657 544482 554508 557311 559917 565815 566070 586711 591895 600881 603288 608355 609653 613383 613792 618473 620245 625597 626730 630597 654353 664267 665200 666659 667207 669225 669435 669890 671660 674752 688016 693388 696977 700536 707981 708469 709797 717188 718143 721039 721091 721276 721388 721438 722116 722181 723980 724090 726016 729664 732144 739188 740272 741620 747057 747912 748320 748451 752535 753476 754872 755436 755794 757324 757754 758050 759919 769199 773166 775004 776635 777889 779651 781185 781224 782170 782284 782695 786944 787207 791630 794616 794710 795475 797854 800177 800463 801337 804037 804217 806238 807171 809249 810399 810866 810918 811937 812171 813795 815011 817679 820736 821183 821625 821923 822242 822701 826745 826996 827372 827832 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"horny blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"horny минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"horny минет оральн секс"
]
|
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.