Query Metrics
7
Database Queries
7
Different statements
169.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.43 ms (83.26%) |
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 388803 392498 405709 406132 413004 413277 415546 415575 416292 416794 419561 420357 423663 424606 426480 426481 429107 429933 429946 430261 431691 432692 442831 444288 446024 446264 447761 450287 450378 451089 452496 453208 454652 454735 454752 454755 458007 458678 461989 467760 469737 470535 471077 471116 471620 474361 475237 475407 475488 475593 476419 476428 478041 478947 480494 480837 482687 482688 485799 486236 491493 491707 491894 499587 500331 500508 501892 504196 504279 506021 508181 508200 510546 512512 513408 513674 514101 517639 521172 521353 521760 523903 526877 527766 527920 528356 528524 530942 545909 546613 548749 548756 549794 549800 550507 552480 552990 557978 559629 567063 568208 569050 574486 576776 580359 582068 583687 594415 600341 603735 643986 644569 647940 650748 670750 707706 748227 787120 803046 805638 ] |
||||||||||||||||||||||||||||||
|
18.22 ms (10.73%) |
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 450378 454652 454755 480494 429107 521760 504279 470535 419561 406132 552480 643986 644569 392498 424606 446264 471116 478041 453208 471077 508181 530942 506021 787120 451089 475593 426481 548749 454752 501892 527766 508200 670750 548756 415575 475488 491894 485799 486236 517639 528524 557978 550507 603735 447761 476419 480837 454735 528356 513674 482688 469737 527920 552990 594415 600341 413004 452496 461989 504196 526877 482687 500508 574486 549800 559629 429946 420357 444288 521172 514101 450287 549794 580359 478947 430261 432692 458678 510546 576776 568208 546613 567063 650748 431691 521353 805638 416794 442831 416292 513408 545909 647940 475407 500331 748227 413277 491707 388803 426480 423663 499587 569050 803046 471620 446024 512512 582068 707706 583687 475237 467760 474361 405709 523903 476428 491493 429933 458007 415546 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.85%) |
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 388803 392498 405709 406132 413004 413277 415546 415575 416292 416794 419561 420357 423663 424606 426480 426481 429107 429933 429946 430261 431691 432692 442831 444288 446024 446264 447761 450287 450378 451089 452496 453208 454652 454735 454752 454755 458007 458678 461989 467760 469737 470535 471077 471116 471620 474361 475237 475407 475488 475593 476419 476428 478041 478947 480494 480837 482687 482688 485799 486236 491493 491707 491894 499587 500331 500508 501892 504196 504279 506021 508181 508200 510546 512512 513408 513674 514101 517639 521172 521353 521760 523903 526877 527766 527920 528356 528524 530942 545909 546613 548749 548756 549794 549800 550507 552480 552990 557978 559629 567063 568208 569050 574486 576776 580359 582068 583687 594415 600341 603735 643986 644569 647940 650748 670750 707706 748227 787120 803046 805638 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"on cam sex"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cam секс"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cam секс"
]
|
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.