Query Metrics
7
Database Queries
7
Different statements
163.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.78 ms (82.85%) |
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 389500 401200 406089 411245 411332 415160 421854 421876 421882 422926 423486 425117 425260 426987 429861 430481 439545 439559 439801 439813 439815 440548 447512 448845 448877 453768 454968 456293 457165 461004 463780 463873 463936 464724 466115 466599 466872 466979 469335 469474 470657 472868 474264 480757 482298 482622 484696 486884 489952 490418 493167 494784 495665 503441 503838 505843 506017 510513 512295 513338 513566 514252 514585 516155 516296 516484 516890 517743 518566 518945 520483 521131 522280 523019 523198 524620 526454 527078 527294 528708 529198 535441 536445 541751 541770 541885 542194 549990 550604 552267 554913 556505 558537 561944 564563 565162 567771 569132 573403 574023 574258 576673 584236 586963 591533 593799 596925 597227 597866 604960 607374 610616 614743 619097 622911 627806 634212 636268 637002 654399 ] |
||||||||||||||||||||||||||||||
|
18.94 ms (11.56%) |
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 447512 506017 514585 622911 503838 482298 518566 522280 516296 518945 503441 528708 586963 421854 505843 510513 426987 550604 463873 466599 466872 439813 493167 474264 429861 486884 597227 439801 565162 425260 516484 513566 495665 574023 482622 554913 535441 536445 526454 401200 464724 422926 463780 470657 576673 453768 512295 634212 439815 552267 421882 561944 472868 529198 463936 494784 604960 516155 549990 448845 439559 627806 637002 516890 406089 480757 440548 556505 430481 567771 489952 457165 610616 389500 439545 454968 654399 411332 569132 527078 564563 523019 574258 573403 490418 541885 466115 411245 614743 542194 541770 469335 597866 521131 423486 513338 541751 593799 523198 514252 517743 466979 591533 636268 484696 527294 421876 469474 584236 456293 524620 607374 619097 448877 461004 415160 558537 596925 425117 520483 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.61%) |
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 389500 401200 406089 411245 411332 415160 421854 421876 421882 422926 423486 425117 425260 426987 429861 430481 439545 439559 439801 439813 439815 440548 447512 448845 448877 453768 454968 456293 457165 461004 463780 463873 463936 464724 466115 466599 466872 466979 469335 469474 470657 472868 474264 480757 482298 482622 484696 486884 489952 490418 493167 494784 495665 503441 503838 505843 506017 510513 512295 513338 513566 514252 514585 516155 516296 516484 516890 517743 518566 518945 520483 521131 522280 523019 523198 524620 526454 527078 527294 528708 529198 535441 536445 541751 541770 541885 542194 549990 550604 552267 554913 556505 558537 561944 564563 565162 567771 569132 573403 574023 574258 576673 584236 586963 591533 593799 596925 597227 597866 604960 607374 610616 614743 619097 622911 627806 634212 636268 637002 654399 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кухн секс анал"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кухн секс анал"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"kitchen sex anal"
]
|
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.