Query Metrics
7
Database Queries
7
Different statements
161.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.82 ms (84.22%) |
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 73289 386678 388374 413084 417943 419224 422308 423682 425495 426383 434590 447356 447890 447955 447965 448199 455531 456790 457805 459340 469182 469193 477063 478946 494284 495937 496270 498056 498442 498809 500839 507285 507976 508512 511919 517123 518628 519849 520742 522985 523553 525409 525953 527182 527721 527978 531573 533772 533949 537247 545192 545273 549569 552846 555030 557658 559725 567013 567161 579546 579940 582804 585984 588374 588551 589356 590214 590223 590670 593696 598103 598190 601438 602185 603697 610147 616933 618778 619092 624003 624320 627722 641778 642237 642249 642662 658216 668463 675588 686265 686373 698600 707071 712534 712553 714580 721278 728756 731345 739886 741542 751228 756165 757099 763589 764620 769616 770493 773498 777935 779120 779952 793418 793456 798666 805005 806329 806854 809327 810848 ] |
||||||||||||||||||||||||||||||
|
14.00 ms (8.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 388374 518628 588551 423682 477063 422308 810848 455531 417943 448199 447356 447965 579940 603697 798666 527182 527978 508512 610147 498442 498809 741542 495937 585984 425495 589356 469182 456790 598103 627722 494284 419224 545273 624003 533949 413084 522985 523553 447955 478946 426383 764620 537247 498056 582804 527721 549569 469193 686373 779952 590670 496270 675588 793456 686265 751228 642662 507285 806329 777935 602185 73289 555030 773498 559725 641778 763589 531573 728756 769616 618778 779120 806854 793418 809327 557658 642237 642249 707071 712553 386678 533772 590223 739886 714580 520742 601438 757099 658216 805005 459340 721278 457805 698600 590214 731345 756165 567161 668463 567013 525409 593696 770493 619092 434590 588374 712534 624320 545192 552846 500839 507976 511919 517123 579546 525953 447890 598190 519849 616933 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (2.01%) |
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 73289 386678 388374 413084 417943 419224 422308 423682 425495 426383 434590 447356 447890 447955 447965 448199 455531 456790 457805 459340 469182 469193 477063 478946 494284 495937 496270 498056 498442 498809 500839 507285 507976 508512 511919 517123 518628 519849 520742 522985 523553 525409 525953 527182 527721 527978 531573 533772 533949 537247 545192 545273 549569 552846 555030 557658 559725 567013 567161 579546 579940 582804 585984 588374 588551 589356 590214 590223 590670 593696 598103 598190 601438 602185 603697 610147 616933 618778 619092 624003 624320 627722 641778 642237 642249 642662 658216 668463 675588 686265 686373 698600 707071 712534 712553 714580 721278 728756 731345 739886 741542 751228 756165 757099 763589 764620 769616 770493 773498 777935 779120 779952 793418 793456 798666 805005 806329 806854 809327 810848 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"face секс"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"face sex"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"face секс"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.04%) |
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.