Query Metrics
7
Database Queries
7
Different statements
154.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.25 ms (82.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 397509 402217 414132 414137 416568 416683 416746 417334 417396 432970 439102 439150 439396 447160 447318 448257 448773 452791 454745 455918 463183 466624 471101 474900 480428 482291 486829 490387 500336 502559 502797 505317 517425 518137 521559 525466 528947 532442 540032 556476 558519 569633 573192 576320 576951 583083 587260 594113 595209 595249 595847 601766 602136 606365 607799 627409 628553 628850 633147 635993 636732 639184 641830 642035 645230 651161 656935 658777 658796 661424 673173 674885 685506 692743 695893 696154 696597 705210 706359 708544 708562 708714 709089 709128 723930 725629 730011 740909 744949 745119 745136 750947 752602 752664 752676 757905 758788 764295 766173 770213 770253 770387 777012 777051 780382 786874 788567 790219 792897 793135 795402 798291 799268 800507 801284 808641 812278 816094 824668 825442 ] |
||||||||||||||||||||||||||||||
|
16.71 ms (10.79%) |
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 606365 402217 439396 528947 795402 639184 454745 525466 502559 685506 558519 466624 576951 448773 486829 595847 417396 471101 705210 793135 740909 780382 583083 447318 708544 708562 674885 709089 569633 628850 792897 801284 800507 750947 766173 745119 764295 744949 825442 824668 474900 576320 658777 482291 448257 595209 414137 416746 414132 816094 490387 455918 502797 500336 521559 532442 556476 673173 695893 645230 656935 696154 706359 708714 651161 658796 696597 573192 587260 602136 641830 642035 601766 636732 607799 628553 777051 786874 777012 752676 788567 799268 812278 758788 770213 723930 725629 730011 745136 757905 770253 752602 752664 770387 627409 633147 790219 808641 397509 480428 416568 452791 417334 439102 463183 517425 505317 798291 416683 432970 439150 447160 518137 540032 692743 661424 635993 594113 595249 709128 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.95%) |
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 397509 402217 414132 414137 416568 416683 416746 417334 417396 432970 439102 439150 439396 447160 447318 448257 448773 452791 454745 455918 463183 466624 471101 474900 480428 482291 486829 490387 500336 502559 502797 505317 517425 518137 521559 525466 528947 532442 540032 556476 558519 569633 573192 576320 576951 583083 587260 594113 595209 595249 595847 601766 602136 606365 607799 627409 628553 628850 633147 635993 636732 639184 641830 642035 645230 651161 656935 658777 658796 661424 673173 674885 685506 692743 695893 696154 696597 705210 706359 708544 708562 708714 709089 709128 723930 725629 730011 740909 744949 745119 745136 750947 752602 752664 752676 757905 758788 764295 766173 770213 770253 770387 777012 777051 780382 786874 788567 790219 792897 793135 795402 798291 799268 800507 801284 808641 812278 816094 824668 825442 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vagina teen dildo"
]
|
||||||||||||||||||||||||||||||
|
2.19 ms (1.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин teen дилд"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вагин teen дилд"
]
|
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.