Query Metrics
7
Database Queries
7
Different statements
174.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.80 ms (85.19%) |
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 384165 389497 402045 438672 455779 461249 464782 469897 470659 475053 480984 484206 488517 492296 493806 495641 499685 503771 508102 514221 515319 521247 521533 524938 526460 527795 528542 529780 530197 530208 533152 535900 537417 538159 538779 539213 539287 539564 540561 541598 542309 545159 545599 545810 547207 549518 550274 551698 552726 554187 556088 556105 556162 557256 558655 562709 564356 564403 567275 568962 569306 572978 573989 574390 575026 575679 577272 578312 583346 585645 588928 589277 589324 589837 589986 592145 594063 594627 595231 596603 597185 597723 599258 600887 603245 603278 603603 604687 605664 606601 627252 627493 627552 628569 629468 631284 631649 632931 635212 639528 640847 644008 647089 650659 653051 665332 665609 683078 685495 715380 724674 740058 745607 764443 770350 779077 782555 784722 799774 804808 ] |
||||||||||||||||||||||||||||||
|
14.84 ms (8.50%) |
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 606601 597723 603278 631649 588928 595231 640847 779077 804808 724674 745607 770350 715380 521533 384165 389497 484206 524938 529780 515319 539287 461249 557256 574390 589986 600887 605664 627552 603603 438672 480984 527795 495641 492296 470659 537417 540561 508102 530197 530208 533152 573989 583346 542309 545159 549518 665609 683078 665332 650659 653051 550274 567275 572978 578312 596603 631284 635212 589277 599258 628569 594063 627493 644008 740058 799774 764443 604687 639528 782555 402045 493806 514221 528542 535900 539213 499685 538159 538779 503771 521247 545810 547207 551698 552726 558655 575679 545599 556105 554187 568962 575026 685495 647089 556088 562709 564356 564403 569306 577272 592145 594627 597185 629468 585645 603245 589324 589837 627252 632931 784722 455779 464782 469897 541598 475053 539564 556162 488517 526460 ] |
||||||||||||||||||||||||||||||
|
3.68 ms (2.11%) |
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 384165 389497 402045 438672 455779 461249 464782 469897 470659 475053 480984 484206 488517 492296 493806 495641 499685 503771 508102 514221 515319 521247 521533 524938 526460 527795 528542 529780 530197 530208 533152 535900 537417 538159 538779 539213 539287 539564 540561 541598 542309 545159 545599 545810 547207 549518 550274 551698 552726 554187 556088 556105 556162 557256 558655 562709 564356 564403 567275 568962 569306 572978 573989 574390 575026 575679 577272 578312 583346 585645 588928 589277 589324 589837 589986 592145 594063 594627 595231 596603 597185 597723 599258 600887 603245 603278 603603 604687 605664 606601 627252 627493 627552 628569 629468 631284 631649 632931 635212 639528 640847 644008 647089 650659 653051 665332 665609 683078 685495 715380 724674 740058 745607 764443 770350 779077 782555 784722 799774 804808 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl telephone"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк телефон"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.84%) |
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.