Query Metrics
7
Database Queries
7
Different statements
355.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.33 ms (58.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
128.64 ms (36.19%) |
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 383773 386303 386354 390772 393749 393770 394184 396285 400436 400443 400455 400461 400471 402078 402090 403190 403210 415906 418493 418645 445058 456656 458058 462306 463161 464315 466635 467296 475453 489619 491193 494352 494356 503901 505497 512047 515092 515124 515160 515171 520716 523153 523274 537568 544309 547276 549940 550440 550445 550601 554114 554307 557304 557330 558059 566511 566514 566515 569661 570051 570069 578461 578464 585997 586634 587929 590224 597574 598683 598777 605307 607193 607742 609207 615112 628143 628303 629991 642779 644697 655861 663374 663473 663482 666767 667543 676951 691993 693073 696973 707011 707347 712806 714432 718705 722114 722679 722688 730254 730378 732387 734842 739670 740300 742689 744328 748574 749128 758198 759600 767956 771180 777345 789038 789304 808177 808762 815780 818936 827660 ] |
||||||||||||||||||||||||||||||
|
12.49 ms (3.51%) |
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 722114 557330 609207 628143 628303 629991 605307 789038 808177 808762 748574 739670 759600 712806 383773 400443 400455 403210 512047 578461 676951 663473 566511 587929 598683 597574 644697 418645 393749 494356 491193 386354 390772 400461 400471 402090 415906 489619 456656 464315 467296 554307 570051 578464 550601 570069 550440 655861 667543 663482 691993 696973 566515 598777 607742 585997 586634 607193 590224 777345 740300 758198 767956 744328 642779 714432 393770 400436 463161 466635 402078 418493 523153 730378 718705 544309 557304 515171 515160 722688 707011 722679 749128 537568 549940 789304 386303 403190 445058 818936 515124 520716 515092 550445 558059 566514 569661 707347 663374 666767 693073 771180 730254 734842 732387 742689 396285 394184 462306 475453 458058 503901 494352 505497 523274 615112 554114 815780 827660 547276 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (0.80%) |
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 383773 386303 386354 390772 393749 393770 394184 396285 400436 400443 400455 400461 400471 402078 402090 403190 403210 415906 418493 418645 445058 456656 458058 462306 463161 464315 466635 467296 475453 489619 491193 494352 494356 503901 505497 512047 515092 515124 515160 515171 520716 523153 523274 537568 544309 547276 549940 550440 550445 550601 554114 554307 557304 557330 558059 566511 566514 566515 569661 570051 570069 578461 578464 585997 586634 587929 590224 597574 598683 598777 605307 607193 607742 609207 615112 628143 628303 629991 642779 644697 655861 663374 663473 663482 666767 667543 676951 691993 693073 696973 707011 707347 712806 714432 718705 722114 722679 722688 730254 730378 732387 734842 739670 740300 742689 744328 748574 749128 758198 759600 767956 771180 777345 789038 789304 808177 808762 815780 818936 827660 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old young girl"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old young девушк"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old young девушк"
]
|
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.