Query Metrics
7
Database Queries
7
Different statements
149.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.21 ms (80.58%) |
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 396236 401465 405145 419428 421530 436098 439583 440991 447208 448457 451751 452207 452586 462078 462114 464999 471508 475473 481407 481908 484995 485250 486871 493851 500175 501603 503085 503587 504756 505084 506207 507740 510360 510518 510697 510704 512055 512738 516740 516780 516823 517060 518798 520596 521040 521408 521507 523129 525022 525258 525697 525706 526785 527355 527788 527858 532102 532338 539764 542531 545690 545909 549493 549682 552550 552880 554066 558738 559008 561424 561560 564244 564246 564644 565581 565631 566230 566781 572913 573357 573455 590579 590968 591198 591468 591595 598887 599368 599483 602912 603055 604046 605552 606759 609181 609464 618334 620009 621392 622686 628632 636154 653101 663264 663297 668140 682719 ] |
||||||||||||||||||||||||||||||
|
18.26 ms (12.24%) |
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 590968 462114 493851 481908 526785 621392 471508 452586 523129 545690 682719 554066 512738 516780 525258 525697 527858 452207 504756 549493 558738 421530 436098 439583 527788 484995 505084 510704 506207 517060 520596 532338 552880 564644 561560 628632 591468 401465 516740 485250 501603 464999 462078 545909 525022 606759 561424 572913 396236 503587 500175 609464 448457 521408 503085 518798 559008 542531 564246 609181 481407 510518 565631 603055 525706 507740 663297 532102 573357 510697 653101 590579 405145 419428 565581 521040 573455 552550 451751 527355 566230 539764 512055 549682 604046 516823 510360 475473 440991 566781 447208 564244 591595 521507 622686 598887 605552 591198 663264 486871 636154 668140 599368 599483 620009 618334 602912 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (2.18%) |
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 396236 401465 405145 419428 421530 436098 439583 440991 447208 448457 451751 452207 452586 462078 462114 464999 471508 475473 481407 481908 484995 485250 486871 493851 500175 501603 503085 503587 504756 505084 506207 507740 510360 510518 510697 510704 512055 512738 516740 516780 516823 517060 518798 520596 521040 521408 521507 523129 525022 525258 525697 525706 526785 527355 527788 527858 532102 532338 539764 542531 545690 545909 549493 549682 552550 552880 554066 558738 559008 561424 561560 564244 564246 564644 565581 565631 566230 566781 572913 573357 573455 590579 590968 591198 591468 591595 598887 599368 599483 602912 603055 604046 605552 606759 609181 609464 618334 620009 621392 622686 628632 636154 653101 663264 663297 668140 682719 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex on phone"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс phone"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс phone"
]
|
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.