Query Metrics
7
Database Queries
7
Different statements
142.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.99 ms (83.29%) |
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 78637 188176 228393 383235 397218 401230 402101 408249 409709 410889 417512 418038 418436 422167 422866 448517 450307 450985 451791 453181 454911 455174 455498 459518 460178 466918 470952 471972 480033 480630 481389 484545 484720 485537 489826 493394 499794 500197 502048 502524 504498 508782 510658 511436 512045 513725 514406 518477 519554 522657 524092 525966 528276 529451 545172 545811 546375 549158 549589 551511 555917 558284 559151 560626 560946 564617 571317 572024 572776 578116 580309 581495 583549 586460 589595 592253 598207 603730 605727 610044 613248 615853 618815 621845 624266 625259 625631 627660 629965 636328 653333 682267 692806 695333 695488 695691 706411 708424 720161 727055 732964 737082 740084 741104 744850 750785 752407 758227 764132 765451 788086 796627 798889 800384 804230 806886 806914 818488 821671 821870 ] |
||||||||||||||||||||||||||||||
|
13.84 ms (9.69%) |
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 410889 525966 818488 821671 480033 625259 586460 613248 788086 796627 752407 750785 629965 471972 453181 418436 454911 592253 485537 744850 459518 564617 692806 589595 188176 583549 765451 228393 518477 572776 549158 500197 493394 514406 422866 551511 555917 558284 615853 737082 800384 806914 764132 804230 422167 489826 522657 451791 625631 401230 417512 450985 484720 529451 549589 580309 653333 695333 695691 706411 605727 618815 806886 732964 624266 510658 519554 528276 524092 603730 508782 572024 455174 502048 821870 484545 559151 571317 695488 708424 720161 682267 560626 740084 741104 727055 610044 798889 418038 448517 499794 545172 581495 758227 455498 480630 460178 504498 598207 512045 502524 78637 466918 560946 402101 578116 546375 636328 621845 627660 450307 397218 470952 481389 545811 513725 511436 383235 408249 409709 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.98%) |
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 78637 188176 228393 383235 397218 401230 402101 408249 409709 410889 417512 418038 418436 422167 422866 448517 450307 450985 451791 453181 454911 455174 455498 459518 460178 466918 470952 471972 480033 480630 481389 484545 484720 485537 489826 493394 499794 500197 502048 502524 504498 508782 510658 511436 512045 513725 514406 518477 519554 522657 524092 525966 528276 529451 545172 545811 546375 549158 549589 551511 555917 558284 559151 560626 560946 564617 571317 572024 572776 578116 580309 581495 583549 586460 589595 592253 598207 603730 605727 610044 613248 615853 618815 621845 624266 625259 625631 627660 629965 636328 653333 682267 692806 695333 695488 695691 706411 708424 720161 727055 732964 737082 740084 741104 744850 750785 752407 758227 764132 765451 788086 796627 798889 800384 804230 806886 806914 818488 821671 821870 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"good blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"good минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"good минет оральн секс"
]
|
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.