Query Metrics
5
Database Queries
5
Different statements
661.38 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.45 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
| 2 | 7.54 ms |
SELECT p.post_id, p.user_id, p.content_id, p.public_key, 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.type = ? AND p.status = ? AND p.sexual_orientation = ? ORDER BY max_ctr DESC LIMIT 120
Parameters:
[ 1 2 0 10 0 ] |
| 3 | 2.94 ms |
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 545916 400884 720778 555873 555839 720732 544493 382381 336860 545527 521047 551858 477698 705667 656175 549170 422399 732140 644106 755521 477430 565341 750117 682521 680705 650779 413185 435573 751261 750655 457419 680944 657761 604574 465737 387318 383932 535875 455919 516664 636545 435579 435587 681084 632342 626599 599557 588231 435580 435572 383856 751003 613488 566375 427517 749343 656209 435570 577378 574413 766770 750634 748155 729818 728269 673244 660070 635480 630631 562387 555809 460006 435917 435568 415527 383972 750333 628537 593185 707282 655568 655348 749025 435567 435734 435747 435774 776248 748204 743159 728226 669589 566550 435562 383820 750604 690648 435566 435740 745556 698109 521126 759617 743811 656225 584739 731884 435563 581667 750756 751267 763406 751262 749019 748153 747846 747826 745361 729644 712047 ] |
| 4 | 148.12 ms |
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 545916 400884 720778 555873 555839 720732 544493 382381 336860 545527 521047 551858 477698 705667 656175 549170 422399 732140 644106 755521 477430 565341 750117 682521 680705 650779 413185 435573 751261 750655 457419 680944 657761 604574 465737 387318 383932 535875 455919 516664 636545 435579 435587 681084 632342 626599 599557 588231 435580 435572 383856 751003 613488 566375 427517 749343 656209 435570 577378 574413 766770 750634 748155 729818 728269 673244 660070 635480 630631 562387 555809 460006 435917 435568 415527 383972 750333 628537 593185 707282 655568 655348 749025 435567 435734 435747 435774 776248 748204 743159 728226 669589 566550 435562 383820 750604 690648 435566 435740 745556 698109 521126 759617 743811 656225 584739 731884 435563 581667 750756 751267 763406 751262 749019 748153 747846 747826 745361 729644 712047 ] |
| 5 | 501.32 ms |
SELECT COUNT(*) 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.type = ? AND p.status = ? AND p.sexual_orientation = ?
Parameters:
[ 1 2 0 10 0 ] |
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.