Query Metrics
7
Database Queries
7
Different statements
199.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.71 ms (62.54%) |
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 411841 413126 414643 421814 422147 424125 426616 429416 432852 433375 435747 448928 449717 450161 451713 452986 453260 455298 457298 457428 459249 459764 460143 460182 460192 460283 460284 460660 461402 464426 466711 466714 469347 471609 475266 477110 478265 506014 513784 515018 515045 521166 521450 522931 523351 523760 523841 524651 525158 525265 525270 527000 527158 528084 528343 531473 531499 531512 533193 544794 549644 555767 555778 559173 563924 564731 571129 573757 582416 582615 585989 586373 587158 596518 601030 606633 607737 614499 615561 668985 728733 755426 765721 774333 774690 777750 778941 782508 786129 792135 792936 794375 796008 798929 800880 802778 804927 805557 807352 807353 807543 808416 811029 811500 812979 814226 814629 814630 814648 815080 815087 815117 815121 817422 818208 820423 820956 822131 822424 825762 ] |
||||||||||||||||||||||||||||||
|
64.32 ms (32.26%) |
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 524651 815080 523760 411841 471609 815121 531473 778941 805557 607737 804927 432852 435747 814226 814630 822131 822424 814648 815087 820956 815117 817422 820423 814629 818208 453260 451713 452986 455298 457298 459764 460143 460182 460283 460284 464426 513784 525270 527158 531499 460192 461402 466711 549644 555767 555778 563924 564731 573757 582416 582615 571129 587158 596518 606633 586373 601030 614499 585989 777750 782508 796008 800880 807352 807353 774690 792135 802778 811029 765721 786129 808416 811500 812979 774333 792936 794375 798929 807543 460660 422147 466714 421814 450161 424125 429416 477110 414643 459249 478265 515045 506014 522931 521450 525158 528084 527000 533193 433375 449717 525265 515018 523351 531512 559173 457428 475266 469347 521166 523841 528343 544794 668985 615561 755426 728733 413126 426616 825762 448928 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (1.59%) |
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 411841 413126 414643 421814 422147 424125 426616 429416 432852 433375 435747 448928 449717 450161 451713 452986 453260 455298 457298 457428 459249 459764 460143 460182 460192 460283 460284 460660 461402 464426 466711 466714 469347 471609 475266 477110 478265 506014 513784 515018 515045 521166 521450 522931 523351 523760 523841 524651 525158 525265 525270 527000 527158 528084 528343 531473 531499 531512 533193 544794 549644 555767 555778 559173 563924 564731 571129 573757 582416 582615 585989 586373 587158 596518 601030 606633 607737 614499 615561 668985 728733 755426 765721 774333 774690 777750 778941 782508 786129 792135 792936 794375 796008 798929 800880 802778 804927 805557 807352 807353 807543 808416 811029 811500 812979 814226 814629 814630 814648 815080 815087 815117 815121 817422 818208 820423 820956 822131 822424 825762 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature pov mom"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature пов mom"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature пов mom"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.