Query Metrics
7
Database Queries
7
Different statements
349.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.65 ms (59.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
118.58 ms (33.93%) |
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 46186 385992 390607 400684 408560 409125 411962 417711 419890 420651 421009 421138 439811 453083 454443 454492 454616 456409 456583 459684 460257 460439 471835 472216 472274 479877 487102 487431 488010 490694 499134 504937 506499 509826 510321 515919 519187 523686 525449 527681 538497 545454 548729 548841 554912 558857 562685 567767 569476 571336 574611 579331 581229 586917 587204 589530 589876 598346 611506 617220 624162 624300 630282 636558 642697 651944 652617 672077 673964 677028 677350 679775 691330 694415 702518 703547 704241 705791 709052 711560 712073 713589 719028 720732 723069 736656 736897 739537 740718 747655 757368 764892 767964 770946 771517 771821 775254 775773 777498 786571 790200 793013 793337 796009 797656 798014 801145 802505 804972 807163 808046 809651 812914 814218 815591 816485 816703 817238 817413 821523 ] |
||||||||||||||||||||||||||||||
|
15.31 ms (4.38%) |
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 736897 764892 672077 408560 705791 817413 709052 796009 453083 677350 786571 487431 815591 821523 652617 651944 809651 630282 419890 770946 736656 817238 525449 624300 589876 808046 812914 421138 471835 400684 385992 456583 515919 420651 816703 814218 702518 677028 589530 740718 720732 46186 417711 472216 574611 611506 642697 802505 454616 598346 586917 439811 538497 519187 454443 490694 456409 411962 816485 499134 581229 562685 719028 712073 704241 587204 793013 801145 804972 757368 409125 567767 797656 767964 807163 421009 673964 527681 554912 771821 509826 523686 579331 771517 506499 694415 548729 624162 454492 460439 703547 472274 548841 691330 713589 723069 711560 571336 617220 636558 775254 793337 798014 747655 739537 775773 777498 558857 504937 459684 479877 510321 487102 569476 790200 390607 545454 679775 460257 488010 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (0.79%) |
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 46186 385992 390607 400684 408560 409125 411962 417711 419890 420651 421009 421138 439811 453083 454443 454492 454616 456409 456583 459684 460257 460439 471835 472216 472274 479877 487102 487431 488010 490694 499134 504937 506499 509826 510321 515919 519187 523686 525449 527681 538497 545454 548729 548841 554912 558857 562685 567767 569476 571336 574611 579331 581229 586917 587204 589530 589876 598346 611506 617220 624162 624300 630282 636558 642697 651944 652617 672077 673964 677028 677350 679775 691330 694415 702518 703547 704241 705791 709052 711560 712073 713589 719028 720732 723069 736656 736897 739537 740718 747655 757368 764892 767964 770946 771517 771821 775254 775773 777498 786571 790200 793013 793337 796009 797656 798014 801145 802505 804972 807163 808046 809651 812914 814218 815591 816485 816703 817238 817413 821523 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob perfect"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс perfect"
]
|
||||||||||||||||||||||||||||||
|
1.23 ms (0.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс perfect"
]
|
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.