Query Metrics
7
Database Queries
7
Different statements
145.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.85 ms (82.38%) |
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 6699 7172 66799 91603 96843 108555 124661 180923 181422 203811 203927 213316 237982 238031 270290 330102 383398 383440 383801 384807 385474 386883 387279 390747 391344 392082 394646 401207 403418 411399 418943 419346 430789 433620 444671 448701 455619 464260 464346 465925 466380 467183 472303 476091 484373 485275 490106 491453 491830 499912 503471 503663 503682 504246 508272 508281 509362 509378 510728 512219 515575 515629 515733 519432 520924 521174 522961 525619 526882 530364 530545 531282 532057 535328 535340 537540 538154 549276 552755 560640 563220 564275 565021 569369 578079 579151 580033 585473 588325 591823 595421 600878 601271 609402 619423 621112 621367 625282 626945 629926 631592 642934 643672 654074 664548 674356 695353 712246 724795 731003 731021 741009 743946 746066 759975 763405 766265 789243 791455 ] |
||||||||||||||||||||||||||||||
|
15.91 ms (10.94%) |
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 387279 520924 674356 731003 503663 515733 181422 508281 491453 609402 383398 491830 383440 430789 418943 664548 6699 512219 759975 465925 466380 383801 731021 743946 203927 124661 270290 237982 490106 504246 595421 448701 238031 763405 394646 530545 535328 560640 626945 472303 330102 419346 538154 467183 510728 766265 535340 621367 791455 433620 444671 484373 401207 663879 411399 108555 565021 509362 530364 537540 521174 526882 66799 390747 531282 580033 741009 392082 525619 642934 391344 509378 7172 724795 464260 712246 601271 203811 508272 515575 564275 569369 591823 585473 455619 503471 91603 619423 600878 499912 213316 476091 654074 180923 549276 643672 96843 386883 385474 629926 746066 515629 621112 464346 522961 503682 485275 519432 578079 579151 552755 695353 631592 532057 588325 403418 789243 384807 563220 625282 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.81%) |
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 6699 7172 66799 91603 96843 108555 124661 180923 181422 203811 203927 213316 237982 238031 270290 330102 383398 383440 383801 384807 385474 386883 387279 390747 391344 392082 394646 401207 403418 411399 418943 419346 430789 433620 444671 448701 455619 464260 464346 465925 466380 467183 472303 476091 484373 485275 490106 491453 491830 499912 503471 503663 503682 504246 508272 508281 509362 509378 510728 512219 515575 515629 515733 519432 520924 521174 522961 525619 526882 530364 530545 531282 532057 535328 535340 537540 538154 549276 552755 560640 563220 564275 565021 569369 578079 579151 580033 585473 588325 591823 595421 600878 601271 609402 619423 621112 621367 625282 626945 629926 631592 642934 643672 654074 664548 674356 695353 712246 724795 731003 731021 741009 743946 746066 759975 763405 766265 789243 791455 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс офисе раком"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс секретарш рак"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.