Query Metrics
7
Database Queries
7
Different statements
150.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.80 ms (80.47%) |
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 97383 188395 309449 341729 381435 387905 390871 390950 391070 398545 399162 409828 411014 411681 411747 411851 423480 423657 424259 425940 430543 443209 443243 443945 448632 453494 457651 465299 468340 468631 471429 471792 479003 493837 507284 509808 517690 522909 530268 530788 531164 531183 531184 532653 532726 532783 532959 532989 533831 534249 534307 534961 536281 536287 536289 536290 536335 536344 536532 537932 541336 544181 549314 550200 561136 566557 581295 583921 586859 598918 599852 599941 600225 600968 617429 620164 628312 630678 631937 634131 634202 636292 639784 639789 642714 644971 648223 648863 653937 656943 659962 660147 660422 684048 699573 707316 714522 715595 728268 744775 751019 752611 760267 760791 771033 777039 788249 800567 800931 801949 803659 805120 806087 809644 810840 814784 815202 815473 820171 820776 ] |
||||||||||||||||||||||||||||||
|
18.46 ms (12.30%) |
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 423657 522909 188395 341729 411747 644971 536289 532726 648863 715595 617429 801949 411851 751019 707316 390871 537932 684048 549314 581295 443945 423480 443243 598918 309449 509808 541336 586859 97383 425940 443209 815473 815202 820776 457651 531184 534249 534961 566557 648223 660147 699573 714522 660422 642714 600225 810840 788249 805120 760791 744775 468631 430543 752611 411681 536335 453494 533831 631937 628312 409828 411014 777039 800931 390950 532783 536281 536287 536532 532959 532989 536344 531183 530268 634202 639789 398545 544181 800567 639784 465299 479003 493837 820171 507284 583921 381435 391070 399162 531164 534307 550200 659962 653937 630678 620164 760267 771033 809644 517690 814784 806087 471429 561136 448632 656943 728268 536290 530788 532653 634131 599852 600968 599941 636292 803659 424259 471792 387905 468340 ] |
||||||||||||||||||||||||||||||
|
3.24 ms (2.16%) |
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 97383 188395 309449 341729 381435 387905 390871 390950 391070 398545 399162 409828 411014 411681 411747 411851 423480 423657 424259 425940 430543 443209 443243 443945 448632 453494 457651 465299 468340 468631 471429 471792 479003 493837 507284 509808 517690 522909 530268 530788 531164 531183 531184 532653 532726 532783 532959 532989 533831 534249 534307 534961 536281 536287 536289 536290 536335 536344 536532 537932 541336 544181 549314 550200 561136 566557 581295 583921 586859 598918 599852 599941 600225 600968 617429 620164 628312 630678 631937 634131 634202 636292 639784 639789 642714 644971 648223 648863 653937 656943 659962 660147 660422 684048 699573 707316 714522 715595 728268 744775 751019 752611 760267 760791 771033 777039 788249 800567 800931 801949 803659 805120 806087 809644 810840 814784 815202 815473 820171 820776 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин double анал"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин double анал"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother double anal"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.