Query Metrics
7
Database Queries
7
Different statements
193.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.71 ms (86.88%) |
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 385057 416472 417497 426549 426944 445473 447445 448250 449208 453329 458222 461461 461620 461795 463910 466415 473472 473748 479798 480434 483555 484051 487168 487975 498423 503617 507688 507965 508189 510704 511465 515333 517229 520739 521537 524504 524639 525243 526033 526589 527626 527867 533686 552160 557422 557888 558856 560107 560587 561664 565189 565191 569147 570054 573296 575505 576689 577897 586688 591073 593729 598150 598246 599467 601454 604715 607385 610317 615440 617030 622371 623086 623450 630802 653519 656358 659418 661691 663448 675156 680200 688450 710891 714816 716628 716710 729440 730607 731475 736850 746318 747177 751229 759002 765154 765393 769088 776377 777628 777940 779328 781569 783052 783641 784381 785287 786145 786319 788480 789726 790129 790701 793446 800026 807339 808255 816146 819452 821582 822886 ] |
||||||||||||||||||||||||||||||
|
14.73 ms (7.63%) |
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 716710 463910 515333 524639 586688 416472 507965 716628 731475 473472 557422 448250 458222 788480 557888 617030 466415 630802 807339 746318 576689 776377 786145 808255 525243 751229 623450 822886 819452 816146 821582 533686 656358 661691 688450 790129 779328 765154 784381 747177 765393 800026 385057 445473 461620 498423 524504 560107 565189 570054 577897 560587 569147 598246 622371 623086 447445 461795 487168 527626 714816 527867 680200 659418 604715 785287 736850 675156 517229 793446 729440 710891 786319 789726 790701 783052 783641 759002 769088 781569 730607 599467 453329 777628 503617 552160 484051 598150 520739 565191 593729 479798 663448 417497 521537 601454 483555 653519 607385 449208 508189 610317 615440 777940 507688 461461 426549 473748 526589 526033 487975 575505 558856 573296 561664 591073 426944 480434 511465 510704 ] |
||||||||||||||||||||||||||||||
|
3.66 ms (1.90%) |
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 385057 416472 417497 426549 426944 445473 447445 448250 449208 453329 458222 461461 461620 461795 463910 466415 473472 473748 479798 480434 483555 484051 487168 487975 498423 503617 507688 507965 508189 510704 511465 515333 517229 520739 521537 524504 524639 525243 526033 526589 527626 527867 533686 552160 557422 557888 558856 560107 560587 561664 565189 565191 569147 570054 573296 575505 576689 577897 586688 591073 593729 598150 598246 599467 601454 604715 607385 610317 615440 617030 622371 623086 623450 630802 653519 656358 659418 661691 663448 675156 680200 688450 710891 714816 716628 716710 729440 730607 731475 736850 746318 747177 751229 759002 765154 765393 769088 776377 777628 777940 779328 781569 783052 783641 784381 785287 786145 786319 788480 789726 790129 790701 793446 800026 807339 808255 816146 819452 821582 822886 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс сперм косичк"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"минет сперма с косичками"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.