Query Metrics
7
Database Queries
7
Different statements
182.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.73 ms (86.05%) |
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 397557 411914 421056 426101 453744 470258 472400 492293 493148 500963 506270 526393 545931 557494 560093 565736 569973 591039 592923 602496 604709 605890 615705 628160 628661 629412 638912 657525 660070 663814 664831 666483 668946 668971 680702 701302 709359 710386 710526 714534 723783 725212 725214 725228 725468 725473 725477 725499 725513 725522 727033 727044 727831 731152 731156 731165 735840 735850 735929 735948 736396 736565 739545 740236 741084 741759 741776 741777 741778 741788 742532 742575 742751 742756 742762 742814 743797 744392 744395 744402 744407 744431 744483 745751 746124 746141 746159 746179 746669 746719 748392 748480 751471 757541 757888 758158 761190 763141 763182 763251 766403 786459 788360 792581 794101 795979 796107 798565 799318 799988 800725 800727 800732 800743 800767 803426 803431 806720 807802 813566 ] |
||||||||||||||||||||||||||||||
|
16.58 ms (9.10%) |
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 628160 628661 602496 592923 605890 638912 795979 799318 806720 799988 800767 803431 723783 725214 725468 725499 725522 727831 731152 736396 740236 741084 741777 741778 741788 744431 746159 746669 798565 800732 725212 725473 727033 735929 743797 744392 744402 736565 742762 744483 746179 735948 742814 751471 757541 761190 763251 731156 741759 742756 748392 709359 792581 794101 803426 397557 500963 493148 813566 453744 472400 492293 545931 557494 569973 560093 660070 664831 668946 668971 710526 663814 666483 710386 657525 714534 565736 591039 604709 629412 786459 800727 800725 800743 725477 725513 763141 788360 744395 746141 757888 725228 731165 735840 742532 742575 742751 745751 748480 766403 735850 739545 741776 746719 758158 763182 727044 744407 746124 615705 701302 796107 807802 470258 421056 506270 526393 411914 426101 680702 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.17%) |
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 397557 411914 421056 426101 453744 470258 472400 492293 493148 500963 506270 526393 545931 557494 560093 565736 569973 591039 592923 602496 604709 605890 615705 628160 628661 629412 638912 657525 660070 663814 664831 666483 668946 668971 680702 701302 709359 710386 710526 714534 723783 725212 725214 725228 725468 725473 725477 725499 725513 725522 727033 727044 727831 731152 731156 731165 735840 735850 735929 735948 736396 736565 739545 740236 741084 741759 741776 741777 741778 741788 742532 742575 742751 742756 742762 742814 743797 744392 744395 744402 744407 744431 744483 745751 746124 746141 746159 746179 746669 746719 748392 748480 751471 757541 757888 758158 761190 763141 763182 763251 766403 786459 788360 792581 794101 795979 796107 798565 799318 799988 800725 800727 800732 800743 800767 803426 803431 806720 807802 813566 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"law"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"law"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"law"
]
|
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.