Query Metrics
7
Database Queries
7
Different statements
357.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.55 ms (58.32%) |
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 401704 407489 435731 445498 452303 457024 457076 457378 457390 457391 457392 458560 458580 460629 460631 460635 463830 472275 473218 477579 478990 484269 486531 488566 488573 490969 494720 494736 507207 512790 512800 512807 512810 521552 521563 521564 521580 521582 521583 525088 525092 528335 536458 542345 542602 542802 542999 543048 543143 543150 543164 543179 543181 543191 543204 543253 543255 543435 543438 543461 543506 543776 543779 543781 544704 549144 550688 552044 552050 556867 556935 556941 556945 556950 556951 556961 556970 562773 565220 565925 565929 567591 568050 569968 574994 575009 576942 577058 577074 577541 581089 585110 585111 585569 586490 586498 586499 586508 586513 586516 586518 586520 586534 590728 591859 591870 599289 605176 617116 618768 619816 621246 621543 626348 632119 655482 660750 660843 663288 682098 ] |
||||||||||||||||||||||||||||||
|
122.56 ms (34.27%) |
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 401704 407489 435731 445498 452303 457024 457076 457378 457390 457391 457392 458560 458580 460629 460631 460635 463830 472275 473218 477579 478990 484269 486531 488566 488573 490969 494720 494736 507207 512790 512800 512807 512810 521552 521563 521564 521580 521582 521583 525088 525092 528335 536458 542345 542602 542802 542999 543048 543143 543150 543164 543179 543181 543191 543204 543253 543255 543435 543438 543461 543506 543776 543779 543781 544704 549144 550688 552044 552050 556867 556935 556941 556945 556950 556951 556961 556970 562773 565220 565925 565929 567591 568050 569968 574994 575009 576942 577058 577074 577541 581089 585110 585111 585569 586490 586498 586499 586508 586513 586516 586518 586520 586534 590728 591859 591870 599289 605176 617116 618768 619816 621246 621543 626348 632119 655482 660750 660843 663288 682098 ] |
||||||||||||||||||||||||||||||
|
18.72 ms (5.23%) |
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 552044 407489 457024 521583 542602 590728 618768 585111 460631 528335 543150 567591 660750 682098 549144 586498 488573 490969 544704 574994 577541 591870 458580 460635 542345 543438 569968 586490 626348 605176 621246 556867 512810 401704 521580 542802 543179 457390 457392 552050 543781 521563 550688 543776 542999 543164 556961 577074 585569 586516 585110 445498 458560 512800 581089 543253 543506 575009 576942 586513 586508 457391 463830 543143 543204 494736 472275 484269 507207 660843 565220 577058 591859 488566 494720 599289 457378 478990 486531 562773 512807 536458 556945 565929 556950 460629 543255 543191 568050 655482 586499 521564 543435 619816 457076 543779 556935 586520 525092 632119 473218 543048 556951 663288 521582 543181 452303 512790 521552 543461 621543 586518 477579 586534 525088 556970 565925 435731 556941 617116 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.59%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"muslim секс"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"muslim fuck"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"muslim секс"
]
|
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.