Query Metrics
7
Database Queries
7
Different statements
153.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.11 ms (81.90%) |
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 53515 91532 182895 384793 388912 390049 393049 397197 410163 410702 414123 414723 417486 417799 419777 422483 423428 424652 427131 427143 427358 429300 430264 430573 432359 441111 441841 441952 447788 452623 453007 453788 459703 459878 466356 470128 475591 477348 478442 485334 490785 493186 493876 495063 496999 501290 507772 508884 508935 510818 512860 513978 513979 513982 515371 517564 517659 517846 518887 522139 523860 524804 526223 530629 531247 533544 534018 535261 536375 536460 536470 536691 541123 543872 544963 546201 546803 546829 547532 550952 554498 556331 558640 559194 559666 569150 576444 576517 583360 583657 587189 598859 601172 609930 632557 672492 680248 688666 710339 710877 726292 738487 742145 749282 749730 768946 791110 797643 803687 803688 803697 804307 805536 807568 814625 817151 817156 817753 819613 827940 ] |
||||||||||||||||||||||||||||||
|
17.27 ms (11.22%) |
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 726292 749282 417799 429300 742145 768946 598859 558640 390049 427143 817151 817753 475591 533544 541123 546829 559194 583657 554498 576517 672492 609930 791110 738487 427131 427358 485334 510818 526223 517564 587189 490785 501290 680248 495063 496999 688666 419777 804307 393049 423428 535261 546803 556331 576444 452623 91532 430573 817156 827940 477348 453788 524804 513979 517659 493186 569150 601172 632557 797643 803687 807568 710877 803688 803697 53515 430264 530629 517846 805536 583360 547532 559666 710339 531247 536691 749730 518887 414723 432359 523860 543872 546201 459703 515371 384793 182895 388912 397197 441952 414123 441111 410163 417486 422483 424652 410702 441841 814625 819613 447788 453007 466356 470128 478442 507772 512860 536460 513982 522139 536375 536470 508884 508935 513978 534018 459878 493876 544963 550952 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.82%) |
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 53515 91532 182895 384793 388912 390049 393049 397197 410163 410702 414123 414723 417486 417799 419777 422483 423428 424652 427131 427143 427358 429300 430264 430573 432359 441111 441841 441952 447788 452623 453007 453788 459703 459878 466356 470128 475591 477348 478442 485334 490785 493186 493876 495063 496999 501290 507772 508884 508935 510818 512860 513978 513979 513982 515371 517564 517659 517846 518887 522139 523860 524804 526223 530629 531247 533544 534018 535261 536375 536460 536470 536691 541123 543872 544963 546201 546803 546829 547532 550952 554498 556331 558640 559194 559666 569150 576444 576517 583360 583657 587189 598859 601172 609930 632557 672492 680248 688666 710339 710877 726292 738487 742145 749282 749730 768946 791110 797643 803687 803688 803697 804307 805536 807568 814625 817151 817156 817753 819613 827940 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бдсм хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bondage extreme"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бдсм хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.20%) |
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.