Query Metrics
7
Database Queries
7
Different statements
190.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.38 ms (87.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 393108 420584 442318 444739 468629 477876 478835 527681 529845 532114 532559 533187 533474 540090 541280 543468 555927 567730 584347 593590 598433 598541 600279 602563 605560 607178 609834 616740 618982 628653 630782 641358 643296 646431 661976 666659 667353 710706 716770 722081 724862 737404 754457 758601 765834 766903 769349 769426 769877 770009 771164 771615 771730 772997 773225 773231 775004 775738 776970 777361 777697 782973 786352 787490 789041 789962 790553 795176 795511 799036 799248 799282 799344 799400 801209 802111 802207 802547 803058 803063 803291 804071 805214 805361 805833 808121 809338 811250 813269 814636 815094 815123 815126 815127 815225 815515 819370 819533 820493 820870 821007 821171 821283 821284 821492 821505 821516 821525 821775 821902 822162 822547 822590 822783 823397 824637 825545 825825 826996 827305 ] |
||||||||||||||||||||||||||||||
|
14.08 ms (7.40%) |
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 802207 776970 799248 393108 815123 607178 801209 771615 802547 822162 478835 799282 805361 803058 477876 468629 420584 782973 541280 661976 442318 444739 628653 804071 820493 821007 821171 822590 815225 821516 821775 822547 823397 826996 819370 820870 821283 821492 821525 822783 815515 825825 827305 529845 533474 533187 543468 666659 722081 641358 775738 795176 799344 805214 805833 789041 799036 803063 770009 772997 724862 769877 773225 769349 771730 605560 789962 802111 809338 813269 815094 598433 609834 795511 540090 766903 532114 777697 819533 787490 527681 602563 775004 821284 824637 814636 821505 821902 825545 584347 667353 555927 567730 616740 593590 598541 630782 643296 790553 799400 786352 754457 758601 769426 765834 773231 710706 716770 803291 815126 815127 532559 646431 811250 737404 771164 777361 600279 808121 618982 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.56%) |
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 393108 420584 442318 444739 468629 477876 478835 527681 529845 532114 532559 533187 533474 540090 541280 543468 555927 567730 584347 593590 598433 598541 600279 602563 605560 607178 609834 616740 618982 628653 630782 641358 643296 646431 661976 666659 667353 710706 716770 722081 724862 737404 754457 758601 765834 766903 769349 769426 769877 770009 771164 771615 771730 772997 773225 773231 775004 775738 776970 777361 777697 782973 786352 787490 789041 789962 790553 795176 795511 799036 799248 799282 799344 799400 801209 802111 802207 802547 803058 803063 803291 804071 805214 805361 805833 808121 809338 811250 813269 814636 815094 815123 815126 815127 815225 815515 819370 819533 820493 820870 821007 821171 821283 821284 821492 821505 821516 821525 821775 821902 822162 822547 822590 822783 823397 824637 825545 825825 826996 827305 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov mom blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов mom минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов mom минет оральн секс"
]
|
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.