Query Metrics
7
Database Queries
7
Different statements
358.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.89 ms (57.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old mature woman"
]
|
||||||||||||||||||||||||||||||
|
129.39 ms (36.06%) |
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 24855 188136 188266 233143 233617 357595 365875 381795 381991 383063 383384 386189 386472 388762 389098 390252 390653 392604 393056 394212 395133 395889 395942 396329 396969 397215 397221 397871 397916 398227 398553 400143 401954 405411 406067 408207 411615 411750 411933 413279 416408 429292 443194 443777 448727 451498 452237 457011 457991 460175 460190 462010 465947 466173 466231 466233 467545 469283 469554 470302 471417 476264 480757 481124 484685 484744 486110 487929 490904 494222 513149 525834 546687 546950 561598 563044 563055 588084 620200 663865 665229 665406 670504 702179 714142 720591 721267 724233 725227 726489 730555 733315 742786 745028 746636 759808 769491 777167 777186 781649 782186 782198 782234 788468 789532 789997 792660 795942 796101 804583 807600 808015 810775 811491 814620 815785 824168 824535 824806 827054 ] |
||||||||||||||||||||||||||||||
|
15.74 ms (4.39%) |
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 466233 397916 490904 561598 448727 470302 443777 429292 386472 383384 395133 395942 397221 397215 406067 413279 815785 824168 824806 824535 457011 670504 702179 721267 663865 665406 720591 588084 620200 781649 795942 796101 777167 725227 782186 782198 782234 788468 742786 777186 804583 381795 396969 486110 408207 827054 714142 789997 789532 807600 808015 730555 759808 733315 390252 397871 24855 383063 188266 395889 390653 398227 401954 405411 411750 452237 462010 563044 546687 546950 726489 746636 792660 811491 724233 745028 233617 386189 357595 365875 388762 392604 394212 467545 233143 381991 411933 469283 411615 476264 443194 487929 484685 484744 769491 188136 393056 396329 400143 416408 469554 810775 480757 457991 471417 460175 465947 563055 398553 460190 481124 451498 466231 389098 466173 513149 525834 814620 494222 665229 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (0.65%) |
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 24855 188136 188266 233143 233617 357595 365875 381795 381991 383063 383384 386189 386472 388762 389098 390252 390653 392604 393056 394212 395133 395889 395942 396329 396969 397215 397221 397871 397916 398227 398553 400143 401954 405411 406067 408207 411615 411750 411933 413279 416408 429292 443194 443777 448727 451498 452237 457011 457991 460175 460190 462010 465947 466173 466231 466233 467545 469283 469554 470302 471417 476264 480757 481124 484685 484744 486110 487929 490904 494222 513149 525834 546687 546950 561598 563044 563055 588084 620200 663865 665229 665406 670504 702179 714142 720591 721267 724233 725227 726489 730555 733315 742786 745028 746636 759808 769491 777167 777186 781649 782186 782198 782234 788468 789532 789997 792660 795942 796101 804583 807600 808015 810775 811491 814620 815785 824168 824535 824806 827054 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.55%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old зрелая женщин"
]
|
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.