Query Metrics
7
Database Queries
7
Different statements
190.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.23 ms (86.60%) |
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 306089 391592 391922 396917 402625 409060 414119 420174 421377 424248 427809 428224 440045 441074 443317 443659 443663 444684 445406 450023 450474 451609 451758 452366 454036 454235 454275 454661 457776 467715 470394 474809 474872 475907 479077 482136 485555 488713 494210 494540 499382 500909 501406 502454 510812 511388 512940 513265 518925 518934 521345 525297 527193 527209 532746 533653 536379 537943 544510 545408 546668 548464 550294 550665 553000 555104 555752 556884 563400 565612 566432 576444 583689 583710 584541 586027 588286 590241 592027 592384 593678 593894 598436 603649 603686 605513 611307 625385 635050 654246 656904 661335 661970 662428 663547 674495 677147 677155 691179 693596 699398 717523 719841 720198 724264 724410 726315 736226 739916 740309 755170 761136 767399 783105 794247 795807 796976 802161 808641 816115 ] |
||||||||||||||||||||||||||||||
|
15.96 ms (8.37%) |
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 699398 611307 794247 470394 661335 654246 533653 566432 635050 501406 563400 593894 441074 451609 518925 625385 512940 693596 598436 553000 588286 545408 663547 720198 556884 584541 795807 802161 485555 502454 518934 409060 494210 550665 691179 783105 475907 421377 488713 306089 661970 674495 546668 590241 603686 755170 452366 457776 494540 467715 592027 454235 739916 443659 424248 445406 474809 454036 479077 532746 521345 525297 527193 544510 548464 565612 583689 555104 583710 550294 555752 576444 656904 662428 677147 717523 719841 586027 592384 593678 796976 724264 724410 736226 740309 808641 427809 454275 450023 440045 450474 500909 511388 513265 537943 527209 677155 510812 761136 443663 396917 767399 605513 726315 603649 391592 391922 402625 414119 443317 420174 428224 444684 816115 474872 451758 454661 499382 536379 482136 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.56%) |
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 306089 391592 391922 396917 402625 409060 414119 420174 421377 424248 427809 428224 440045 441074 443317 443659 443663 444684 445406 450023 450474 451609 451758 452366 454036 454235 454275 454661 457776 467715 470394 474809 474872 475907 479077 482136 485555 488713 494210 494540 499382 500909 501406 502454 510812 511388 512940 513265 518925 518934 521345 525297 527193 527209 532746 533653 536379 537943 544510 545408 546668 548464 550294 550665 553000 555104 555752 556884 563400 565612 566432 576444 583689 583710 584541 586027 588286 590241 592027 592384 593678 593894 598436 603649 603686 605513 611307 625385 635050 654246 656904 661335 661970 662428 663547 674495 677147 677155 691179 693596 699398 717523 719841 720198 724264 724410 726315 736226 739916 740309 755170 761136 767399 783105 794247 795807 796976 802161 808641 816115 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur wife double"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск жен double"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.29 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск жен double"
]
|
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.