Query Metrics
7
Database Queries
7
Different statements
152.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.58 ms (83.11%) |
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 382450 383773 386060 386207 386303 386354 390967 393749 396285 400421 400435 400436 400461 400471 403190 413295 414498 415906 418493 453562 453668 456885 458058 459233 464315 470844 475453 489619 512047 515092 515216 515279 523274 527503 550440 550445 550601 554307 566511 581628 587929 597264 597807 598443 598679 598777 600165 605331 605339 621620 628310 630977 642779 644291 644698 655861 663466 663473 664307 671578 671640 681808 682022 683454 683515 683563 684189 685587 685664 685687 687205 687488 687929 696973 698293 707347 714432 715323 715575 717610 717708 717713 717895 718947 722912 722913 724509 728309 728384 729871 732303 734842 735446 740300 740704 740854 743341 744328 748574 748685 757367 757442 758198 767956 771180 773650 777646 780444 798992 799002 800305 804015 811128 811647 812010 817720 823808 825808 826672 827523 ] |
||||||||||||||||||||||||||||||
|
15.04 ms (9.88%) |
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 798992 732303 735446 728309 459233 823808 817720 685664 683563 685587 687488 804015 748574 812010 729871 773650 621620 780444 386207 386303 386354 386060 383773 400435 400461 400471 403190 415906 827523 453668 489619 464315 512047 515092 515216 550445 554307 550601 550440 655861 707347 663466 664307 687929 696973 722912 722913 663473 566511 587929 598777 597264 597807 740854 771180 734842 740300 758198 767956 744328 642779 714432 382450 396285 400436 470844 400421 413295 393749 418493 453562 475453 458058 515279 523274 456885 826672 671578 687205 715323 671640 683454 684189 685687 717895 718947 717610 598443 628310 644291 598679 605339 644698 605331 630977 777646 740704 743341 757367 800305 811647 724509 728384 757442 748685 698293 715575 717708 717713 799002 811128 414498 390967 527503 825808 581628 683515 682022 681808 600165 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.82%) |
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 382450 383773 386060 386207 386303 386354 390967 393749 396285 400421 400435 400436 400461 400471 403190 413295 414498 415906 418493 453562 453668 456885 458058 459233 464315 470844 475453 489619 512047 515092 515216 515279 523274 527503 550440 550445 550601 554307 566511 581628 587929 597264 597807 598443 598679 598777 600165 605331 605339 621620 628310 630977 642779 644291 644698 655861 663466 663473 664307 671578 671640 681808 682022 683454 683515 683563 684189 685587 685664 685687 687205 687488 687929 696973 698293 707347 714432 715323 715575 717610 717708 717713 717895 718947 722912 722913 724509 728309 728384 729871 732303 734842 735446 740300 740704 740854 743341 744328 748574 748685 757367 757442 758198 767956 771180 773650 777646 780444 798992 799002 800305 804015 811128 811647 812010 817720 823808 825808 826672 827523 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen old"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen old"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen old"
]
|
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.