Query Metrics
7
Database Queries
7
Different statements
151.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.83 ms (81.23%) |
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 95986 386709 398227 398244 400719 404346 405895 406868 408969 415862 419146 445472 467048 467678 471526 477705 510457 516644 522908 534786 540334 541623 543407 543415 546761 548734 548736 548743 549755 550099 550233 551044 554311 554313 556409 558131 558614 559184 559187 561334 565254 565367 568175 575019 575059 575716 576083 581349 582789 583902 584022 589211 591620 592692 595813 597242 600503 603285 606508 606571 607730 608031 615883 617652 624175 624789 627809 628366 628391 630526 631965 632046 632588 632689 632979 637080 642043 642751 646229 664305 665210 666546 666883 668886 670758 674368 679457 679810 679826 680118 680120 680142 680167 680185 680255 683831 685791 687924 697025 702166 714511 715662 718968 730233 733840 733870 737521 746852 748218 748234 748238 748957 776521 789764 790234 800588 804464 811497 811945 815737 ] |
||||||||||||||||||||||||||||||
|
18.77 ms (12.41%) |
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 467048 467678 546761 550099 558614 543415 549755 559184 559187 565254 581349 584022 550233 554313 558131 582789 674368 679810 680185 702166 714511 670758 679826 680255 685791 646229 666546 666883 680118 680167 683831 687924 554311 561334 565367 575716 606508 627809 631965 606571 632689 591620 600503 603285 628366 632588 632979 642751 624175 628391 630526 632046 637080 800588 811497 790234 733840 748957 730233 733870 608031 642043 804464 400719 477705 541623 386709 95986 398227 398244 404346 405895 408969 406868 415862 419146 815737 471526 445472 510457 534786 540334 516644 522908 568175 543407 548743 551044 556409 575019 575059 583902 664305 668886 715662 665210 680120 680142 679457 697025 718968 548734 548736 576083 589211 607730 617652 597242 624789 592692 595813 615883 789764 776521 811945 746852 748234 748238 737521 748218 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (2.04%) |
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 95986 386709 398227 398244 400719 404346 405895 406868 408969 415862 419146 445472 467048 467678 471526 477705 510457 516644 522908 534786 540334 541623 543407 543415 546761 548734 548736 548743 549755 550099 550233 551044 554311 554313 556409 558131 558614 559184 559187 561334 565254 565367 568175 575019 575059 575716 576083 581349 582789 583902 584022 589211 591620 592692 595813 597242 600503 603285 606508 606571 607730 608031 615883 617652 624175 624789 627809 628366 628391 630526 631965 632046 632588 632689 632979 637080 642043 642751 646229 664305 665210 666546 666883 668886 670758 674368 679457 679810 679826 680118 680120 680142 680167 680185 680255 683831 685791 687924 697025 702166 714511 715662 718968 730233 733840 733870 737521 746852 748218 748234 748238 748957 776521 789764 790234 800588 804464 811497 811945 815737 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young group"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young group"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.26 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young group"
]
|
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.