Query Metrics
7
Database Queries
7
Different statements
152.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.29 ms (82.97%) |
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 393986 394158 417733 455361 462860 477702 478329 492016 492667 494894 499083 501322 502716 513330 513804 513836 514483 530395 531377 534768 535847 536439 538060 546273 567526 574020 578171 583165 590328 595447 608287 609081 616887 622527 624389 629265 631287 637998 656167 657234 660572 661991 662144 662383 664472 672807 672822 676673 676929 677366 681388 686322 689981 697217 698911 698916 700920 703245 706704 710331 710846 713031 714079 714675 716681 720073 720195 720200 720507 720648 720652 724516 724518 725446 726918 727331 729634 730504 730662 732771 733399 733409 733518 733852 734197 734251 737425 738391 740244 742657 744262 745914 748403 748620 750641 752000 753744 760338 761218 762333 764160 764247 771213 771281 780333 780944 782297 788782 791836 792470 799832 800520 803411 805269 810917 812149 815751 824994 827048 ] |
||||||||||||||||||||||||||||||
|
14.52 ms (9.54%) |
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 720652 791836 803411 417733 698916 800520 734197 393986 753744 745914 534768 780944 824994 513330 531377 492667 681388 805269 799832 742657 726918 499083 514483 536439 720200 661991 513804 538060 530395 697217 656167 700920 706704 583165 771281 733409 733518 737425 716681 720195 455361 827048 578171 574020 657234 676929 710846 660572 689981 698911 676673 677366 720507 546273 590328 609081 616887 639224 780333 729634 740244 752000 782297 810917 730662 738391 750641 725446 727331 760338 744262 637998 710331 720073 720648 788782 792470 812149 732771 748620 502716 664472 686322 624389 724516 761218 724518 730504 733399 672822 494894 567526 492016 535847 713031 622527 629265 734251 762333 631287 513836 462860 672807 714675 764247 771213 662144 662383 714079 477702 394158 608287 595447 764160 733852 748403 703245 815751 478329 501322 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (2.29%) |
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 393986 394158 417733 455361 462860 477702 478329 492016 492667 494894 499083 501322 502716 513330 513804 513836 514483 530395 531377 534768 535847 536439 538060 546273 567526 574020 578171 583165 590328 595447 608287 609081 616887 622527 624389 629265 631287 637998 656167 657234 660572 661991 662144 662383 664472 672807 672822 676673 676929 677366 681388 686322 689981 697217 698911 698916 700920 703245 706704 710331 710846 713031 714079 714675 716681 720073 720195 720200 720507 720648 720652 724516 724518 725446 726918 727331 729634 730504 730662 732771 733399 733409 733518 733852 734197 734251 737425 738391 740244 742657 744262 745914 748403 748620 750641 752000 753744 760338 761218 762333 764160 764247 771213 771281 780333 780944 782297 788782 791836 792470 799832 800520 803411 805269 810917 812149 815751 824994 827048 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие cock orgasm"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие cock orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big cock orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.23%) |
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.