Query Metrics
7
Database Queries
7
Different statements
155.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.90 ms (84.00%) |
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 16776 70191 124361 187709 187918 187990 188129 280674 306275 348275 358449 360242 382387 382723 383305 385787 386866 388642 388723 388862 388968 389895 390051 390728 391237 397811 398527 398935 401058 403317 406587 407396 409234 411390 411695 411776 412973 413283 413474 419537 424739 428907 432189 440403 443918 444708 449082 450122 450647 452856 453491 454544 456298 460015 460411 460704 464349 465677 465962 466679 469046 477763 478460 486887 492292 497867 515904 518443 535878 536441 551863 555009 555129 560993 565525 569985 581305 587558 588911 604430 637503 678775 678975 681295 696316 696415 710531 714562 714630 720583 720622 720713 723984 726984 727050 728228 728348 734332 735032 736207 742341 742433 742722 744061 745517 754631 761012 761326 770139 774187 774196 780706 782657 790974 796164 808226 812518 815365 815722 819235 ] |
||||||||||||||||||||||||||||||
|
14.99 ms (9.62%) |
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 388723 388862 390051 432189 413474 411776 449082 515904 535878 565525 581305 678775 696316 720583 551863 604430 587558 745517 727050 735032 774187 742722 761012 761326 70191 407396 411390 450122 460015 492292 382723 16776 812518 388642 555129 486887 497867 754631 386866 187709 348275 280674 382387 401058 406587 412973 444708 815365 819235 477763 681295 720622 678975 569985 588911 782657 790974 723984 734332 736207 770139 796164 808226 728348 774196 726984 742341 728228 742433 637503 710531 720713 780706 187918 383305 360242 385787 390728 419537 424739 450647 452856 460411 398527 409234 411695 465677 518443 466679 358449 398935 306275 389895 124361 187990 397811 413283 443918 815722 453491 464349 536441 469046 555009 696415 714630 560993 744061 714562 188129 456298 460704 388968 403317 440403 391237 428907 454544 465962 478460 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.64%) |
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 16776 70191 124361 187709 187918 187990 188129 280674 306275 348275 358449 360242 382387 382723 383305 385787 386866 388642 388723 388862 388968 389895 390051 390728 391237 397811 398527 398935 401058 403317 406587 407396 409234 411390 411695 411776 412973 413283 413474 419537 424739 428907 432189 440403 443918 444708 449082 450122 450647 452856 453491 454544 456298 460015 460411 460704 464349 465677 465962 466679 469046 477763 478460 486887 492292 497867 515904 518443 535878 536441 551863 555009 555129 560993 565525 569985 581305 587558 588911 604430 637503 678775 678975 681295 696316 696415 710531 714562 714630 720583 720622 720713 723984 726984 727050 728228 728348 734332 735032 736207 742341 742433 742722 744061 745517 754631 761012 761326 770139 774187 774196 780706 782657 790974 796164 808226 812518 815365 815722 819235 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.38%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"тёщ и"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.