Query Metrics
7
Database Queries
7
Different statements
153.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.97 ms (82.68%) |
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 6840 14534 105023 125944 161969 213614 233500 351216 365865 385436 385928 388313 388769 391083 391567 391850 391908 392031 392579 392588 392599 397439 397852 398958 400696 402255 402733 402982 411418 420736 423483 429111 432304 440715 444666 453629 456023 457580 458223 458408 461414 461460 461553 461619 462538 464244 467549 469277 470510 472019 472298 472400 472609 473611 476481 477963 478008 483242 484403 485087 488955 490709 491090 504167 505293 509230 510794 512645 516312 517548 521422 522655 527634 533782 534147 534497 543619 543717 544397 544864 545527 546661 548713 549578 549624 549785 550238 552248 552633 555787 567830 568847 571401 572497 579072 579893 584841 595473 598577 610835 611422 659300 671250 717662 718643 718658 720031 736185 742938 749907 754104 762277 763463 770278 785049 788457 792317 814973 819786 ] |
||||||||||||||||||||||||||||||
|
16.64 ms (10.84%) |
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 546661 717662 584841 464244 461460 491090 792317 762277 458408 549624 6840 429111 462538 485087 543717 610835 718643 105023 392599 456023 388313 549578 527634 742938 213614 543619 365865 545527 736185 397852 125944 814973 549785 579072 684768 595473 453629 504167 391083 397439 544864 391567 458223 598577 477963 544397 552633 572497 351216 402255 392579 473611 476481 534497 749907 161969 470510 659300 720031 548713 423483 533782 478008 509230 819786 432304 440715 461619 785049 763463 233500 505293 14534 534147 671250 770278 391908 402982 385436 411418 488955 522655 550238 788457 754104 718658 392588 388769 472019 611422 420736 398958 392031 391850 483242 571401 444666 461414 472298 402733 472609 469277 472400 490709 568847 567830 552248 400696 461553 467549 484403 510794 517548 521422 579893 385928 516312 512645 555787 457580 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.61%) |
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 6840 14534 105023 125944 161969 213614 233500 351216 365865 385436 385928 388313 388769 391083 391567 391850 391908 392031 392579 392588 392599 397439 397852 398958 400696 402255 402733 402982 411418 420736 423483 429111 432304 440715 444666 453629 456023 457580 458223 458408 461414 461460 461553 461619 462538 464244 467549 469277 470510 472019 472298 472400 472609 473611 476481 477963 478008 483242 484403 485087 488955 490709 491090 504167 505293 509230 510794 512645 516312 517548 521422 522655 527634 533782 534147 534497 543619 543717 544397 544864 545527 546661 548713 549578 549624 549785 550238 552248 552633 555787 567830 568847 571401 572497 579072 579893 584841 595473 598577 610835 611422 659300 671250 717662 718643 718658 720031 736185 742938 749907 754104 762277 763463 770278 785049 788457 792317 814973 819786 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"трах с русской"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс русск"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.05%) |
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.