Query Metrics
7
Database Queries
7
Different statements
167.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.56 ms (86.45%) |
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 555175 588141 589633 596981 603119 603204 603345 604877 606853 609977 618181 618678 622868 625451 626803 639176 645052 645962 652747 662039 669196 675545 680640 693535 694149 695417 696337 699304 701733 706995 707589 709913 717595 717740 719021 720841 722081 722452 725562 726343 726660 726989 727505 728097 728810 730998 731369 733386 734311 736330 740852 741390 741891 742115 742565 742723 744688 746219 746277 746461 748599 752914 753620 754990 755285 755351 755394 755830 755950 758913 761051 767428 770054 774141 774143 774511 775813 776793 777097 777522 779173 785633 785901 788591 788695 790764 791414 794553 795158 795176 795585 795747 795869 795926 796001 797143 797186 797208 797367 797698 797779 798241 800095 800616 800726 800871 800968 801124 801302 801362 801589 801913 803249 803320 803346 805319 805781 806508 809181 ] |
||||||||||||||||||||||||||||||
|
12.29 ms (7.35%) |
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 675545 694149 696337 699304 701733 706995 688681 707589 717595 717740 722081 645052 645962 652747 662039 669196 680640 693535 695417 709913 719021 720841 722452 555175 589633 596981 626803 603119 603345 606853 622868 604877 609977 639176 588141 603204 618181 618678 625451 775813 776793 777097 779173 785633 785901 788695 794553 795176 795585 797367 797779 800095 800968 801124 801589 801913 803249 803320 803346 805319 805781 806508 809181 774511 777522 795158 795747 798241 800726 801302 801362 734311 740852 742565 746219 748599 752914 754990 755830 755950 758913 761051 767428 774143 788591 790764 791414 795869 795926 796001 797143 797186 797208 797698 800616 800871 730998 741390 741891 742115 746277 755394 726343 728097 733386 746461 755351 727505 736330 742723 744688 753620 755285 770054 774141 725562 726660 726989 728810 731369 ] |
||||||||||||||||||||||||||||||
|
3.69 ms (2.20%) |
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 555175 588141 589633 596981 603119 603204 603345 604877 606853 609977 618181 618678 622868 625451 626803 639176 645052 645962 652747 662039 669196 675545 680640 693535 694149 695417 696337 699304 701733 706995 707589 709913 717595 717740 719021 720841 722081 722452 725562 726343 726660 726989 727505 728097 728810 730998 731369 733386 734311 736330 740852 741390 741891 742115 742565 742723 744688 746219 746277 746461 748599 752914 753620 754990 755285 755351 755394 755830 755950 758913 761051 767428 770054 774141 774143 774511 775813 776793 777097 777522 779173 785633 785901 788591 788695 790764 791414 794553 795158 795176 795585 795747 795869 795926 796001 797143 797186 797208 797367 797698 797779 798241 800095 800616 800726 800871 800968 801124 801302 801362 801589 801913 803249 803320 803346 805319 805781 806508 809181 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hair milf"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hair milf"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hair milf"
]
|
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.