Query Metrics
7
Database Queries
7
Different statements
142.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.12 ms (82.63%) |
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 30767 101986 120074 233504 311005 382468 385370 385809 387291 387610 388542 389517 390304 391697 395170 395224 395522 395926 397416 399355 401866 404247 407250 410874 412907 413583 414427 416785 417891 418897 419150 419731 419882 420727 422219 422291 423593 425784 426026 426250 435973 437748 441669 443498 446902 447838 448634 448969 449019 449848 451420 452295 452508 453218 453968 455160 455530 455702 456482 456543 456615 457128 458521 459060 459289 459655 461029 461147 461783 462214 463099 464307 464643 466431 468586 468811 469721 471804 472765 474889 476438 479265 479426 479613 480108 480966 481214 482676 482840 486278 486387 487252 490314 490634 495103 495442 496690 498126 507455 508990 511209 512713 513736 528168 528785 543549 551674 552851 557479 565281 571799 571852 575804 603488 624935 672858 677847 686652 703328 735901 ] |
||||||||||||||||||||||||||||||
|
15.26 ms (10.68%) |
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 390304 385370 686652 311005 389517 448969 387291 412907 422219 461783 388542 490314 474889 404247 387610 677847 441669 451420 418897 382468 101986 413583 453968 495442 423593 480966 120074 455160 459289 443498 463099 458521 459655 391697 482676 459060 511209 479265 466431 395926 486278 395224 462214 448634 233504 419731 472765 512713 507455 420727 455702 395522 414427 447838 449848 468811 453218 456543 416785 437748 464307 449019 446902 575804 455530 452508 481214 401866 399355 571852 528785 482840 571799 385809 464643 552851 417891 456482 425784 486387 528168 456615 476438 419882 565281 468586 672858 426026 30767 624935 513736 703328 496690 735901 603488 498126 397416 508990 480108 487252 551674 495103 407250 471804 479613 490634 422291 469721 461147 457128 461029 543549 435973 410874 395170 419150 452295 557479 426250 479426 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.94%) |
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 30767 101986 120074 233504 311005 382468 385370 385809 387291 387610 388542 389517 390304 391697 395170 395224 395522 395926 397416 399355 401866 404247 407250 410874 412907 413583 414427 416785 417891 418897 419150 419731 419882 420727 422219 422291 423593 425784 426026 426250 435973 437748 441669 443498 446902 447838 448634 448969 449019 449848 451420 452295 452508 453218 453968 455160 455530 455702 456482 456543 456615 457128 458521 459060 459289 459655 461029 461147 461783 462214 463099 464307 464643 466431 468586 468811 469721 471804 472765 474889 476438 479265 479426 479613 480108 480966 481214 482676 482840 486278 486387 487252 490314 490634 495103 495442 496690 498126 507455 508990 511209 512713 513736 528168 528785 543549 551674 552851 557479 565281 571799 571852 575804 603488 624935 672858 677847 686652 703328 735901 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"толстый член в вагине%…"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"толстый член в вагин"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"толстый член в вагин"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.10%) |
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.