Query Metrics
7
Database Queries
7
Different statements
165.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.42 ms (81.98%) |
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 95855 400479 400826 401005 404600 409251 409259 412288 417473 421810 421824 421826 421845 421856 421860 421868 421882 421889 421894 422151 422198 422204 422209 425982 428588 428814 430002 439704 439797 439801 442507 442750 450827 453099 455462 460370 461036 464256 465391 466564 467441 469454 469774 470300 471807 472282 473172 474519 474820 476314 476347 476406 478374 478375 482248 482292 482315 483569 483631 483639 488380 489950 492779 492799 500797 502814 503153 505965 511251 511314 512561 515914 518574 519478 519958 520701 523122 523198 524900 526997 531420 531495 532888 534246 537789 544824 546878 549797 549845 550578 554981 558286 562178 565313 567212 568665 579484 599203 601040 601889 602968 604781 606285 609085 614479 625235 628314 633173 643364 647344 668641 668668 725036 752506 760267 784427 789665 802121 804209 811040 ] |
||||||||||||||||||||||||||||||
|
20.59 ms (12.46%) |
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 466564 511251 643364 401005 461036 752506 469454 453099 442507 465391 400479 422151 478375 483639 502814 500797 483631 519478 668668 628314 601889 439801 520701 523198 482292 488380 400826 568665 439797 546878 606285 421810 428588 422204 417473 409259 524900 544824 558286 802121 476406 523122 532888 531495 464256 579484 599203 725036 760267 784427 404600 421824 442750 482315 421889 439704 421826 421845 430002 455462 519958 609085 614479 549797 489950 647344 492799 478374 505965 601040 425982 421882 549845 567212 625235 422198 469774 483569 668641 515914 422209 511314 95855 526997 550578 554981 531420 492779 602968 565313 467441 474519 473172 789665 460370 512561 537789 474820 476347 476314 534246 562178 604781 811040 633173 804209 421856 421860 421868 428814 470300 471807 421894 472282 482248 503153 409251 450827 518574 412288 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.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 95855 400479 400826 401005 404600 409251 409259 412288 417473 421810 421824 421826 421845 421856 421860 421868 421882 421889 421894 422151 422198 422204 422209 425982 428588 428814 430002 439704 439797 439801 442507 442750 450827 453099 455462 460370 461036 464256 465391 466564 467441 469454 469774 470300 471807 472282 473172 474519 474820 476314 476347 476406 478374 478375 482248 482292 482315 483569 483631 483639 488380 489950 492779 492799 500797 502814 503153 505965 511251 511314 512561 515914 518574 519478 519958 520701 523122 523198 524900 526997 531420 531495 532888 534246 537789 544824 546878 549797 549845 550578 554981 558286 562178 565313 567212 568665 579484 599203 601040 601889 602968 604781 606285 609085 614479 625235 628314 633173 643364 647344 668641 668668 725036 752506 760267 784427 789665 802121 804209 811040 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature red panties"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature red трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature red трусик нижн бел"
]
|
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.