Query Metrics
7
Database Queries
7
Different statements
182.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.88 ms (85.97%) |
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 419240 424297 424924 425299 426457 428374 428764 429178 429294 437638 443029 444791 445310 447289 452367 453022 455425 456149 457002 457012 458369 459598 459937 461251 466781 467684 468815 478216 478307 478319 478679 485353 488138 489270 490467 491302 492499 493433 496153 497946 499043 506084 507315 515318 520553 521029 523920 524667 526629 527732 529267 545725 546140 552104 552246 555161 555945 557043 557726 558750 560099 564080 569516 571392 572846 575725 576587 578041 580185 581229 593421 595512 598186 598944 603044 604319 604635 613937 616091 638917 648519 662374 671470 673472 723131 740508 757455 762675 764675 769344 773539 775268 775487 778514 781573 784989 785238 785718 786831 787944 788533 790320 793788 795143 795522 796048 797570 797859 798351 798856 800016 801399 802867 806271 806841 808257 809271 812822 813086 824456 ] |
||||||||||||||||||||||||||||||
|
16.01 ms (8.77%) |
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 426457 497946 493433 795143 555161 798856 457002 419240 598944 762675 557726 569516 572846 555945 778514 786831 802867 812822 813086 769344 740508 801399 545725 662374 648519 457012 455425 424924 552246 603044 425299 488138 808257 796048 478216 520553 793788 673472 507315 581229 444791 492499 575725 578041 576587 773539 775487 787944 506084 459937 795522 800016 604635 564080 806841 452367 478307 478319 613937 529267 598186 558750 790320 580185 478679 781573 485353 593421 824456 429178 459598 515318 560099 671470 595512 797859 496153 468815 466781 521029 443029 526629 557043 523920 489270 546140 571392 429294 428374 456149 638917 797570 775268 784989 757455 785238 764675 785718 788533 798351 461251 806271 428764 453022 458369 552104 424297 437638 447289 524667 723131 809271 604319 527732 490467 499043 491302 616091 445310 467684 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.41%) |
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 419240 424297 424924 425299 426457 428374 428764 429178 429294 437638 443029 444791 445310 447289 452367 453022 455425 456149 457002 457012 458369 459598 459937 461251 466781 467684 468815 478216 478307 478319 478679 485353 488138 489270 490467 491302 492499 493433 496153 497946 499043 506084 507315 515318 520553 521029 523920 524667 526629 527732 529267 545725 546140 552104 552246 555161 555945 557043 557726 558750 560099 564080 569516 571392 572846 575725 576587 578041 580185 581229 593421 595512 598186 598944 603044 604319 604635 613937 616091 638917 648519 662374 671470 673472 723131 740508 757455 762675 764675 769344 773539 775268 775487 778514 781573 784989 785238 785718 786831 787944 788533 790320 793788 795143 795522 796048 797570 797859 798351 798856 800016 801399 802867 806271 806841 808257 809271 812822 813086 824456 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov blowjob facial"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов минет оральн секс facial"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов минет оральн секс facial"
]
|
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.