Query Metrics
7
Database Queries
7
Different statements
205.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
180.99 ms (88.27%) |
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 123955 386085 396375 398085 403252 420321 432184 444254 471646 493553 496704 499484 500060 513814 523393 527506 529606 537280 540928 541018 552557 556197 559983 565707 572356 575935 577041 577238 580395 583653 584418 589155 589604 589868 593110 594048 598413 599460 600228 607381 608628 611240 611509 615781 621085 631464 638893 642293 646329 646493 646789 652221 660308 661063 661519 661526 662945 671097 676503 676996 680971 690769 698479 707264 708543 717687 737242 740506 740507 742212 742335 743238 743256 743265 743270 744004 744045 744109 744130 744510 752805 753599 754397 757818 758018 769335 772511 780889 781024 786200 786266 786310 787153 789990 791334 791756 792401 792445 798315 801826 803976 804248 806532 810610 810969 811881 812217 812242 814208 816834 817185 819089 819123 822313 825132 826349 827332 827716 828587 ] |
||||||||||||||||||||||||||||||
|
13.93 ms (6.79%) |
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 828293 826349 801826 789990 420321 541018 583653 707264 752805 753599 803976 646329 499484 432184 493553 594048 584418 523393 540928 599460 496704 811881 786200 471646 500060 792445 611240 717687 780889 396375 810610 403252 819123 819089 575935 556197 559983 646789 621085 600228 744045 444254 817185 529606 537280 580395 652221 660308 661063 661526 676503 676996 661519 646493 671097 708543 552557 598413 589155 589868 812217 781024 744004 786266 792401 798315 740506 743256 743270 744510 769335 743265 758018 742335 744130 743238 744109 611509 786310 791756 631464 787153 804248 814208 825132 816834 827332 827716 822313 828587 513814 527506 565707 577041 572356 690769 662945 680971 577238 608628 638893 607381 593110 589604 806532 742212 757818 791334 737242 740507 754397 772511 615781 642293 698479 810969 812242 386085 123955 398085 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.26%) |
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 123955 386085 396375 398085 403252 420321 432184 444254 471646 493553 496704 499484 500060 513814 523393 527506 529606 537280 540928 541018 552557 556197 559983 565707 572356 575935 577041 577238 580395 583653 584418 589155 589604 589868 593110 594048 598413 599460 600228 607381 608628 611240 611509 615781 621085 631464 638893 642293 646329 646493 646789 652221 660308 661063 661519 661526 662945 671097 676503 676996 680971 690769 698479 707264 708543 717687 737242 740506 740507 742212 742335 743238 743256 743265 743270 744004 744045 744109 744130 744510 752805 753599 754397 757818 758018 769335 772511 780889 781024 786200 786266 786310 787153 789990 791334 791756 792401 792445 798315 801826 803976 804248 806532 810610 810969 811881 812217 812242 814208 816834 817185 819089 819123 822313 825132 826349 827332 827716 828587 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац девушк"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation girls"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.82%) |
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.