Query Metrics
7
Database Queries
7
Different statements
194.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.19 ms (83.27%) |
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 7981 95673 96371 191048 387544 393724 399568 400162 400932 407895 411688 414723 419932 421201 421204 425281 425332 426009 426547 428406 434456 438001 445681 447265 448383 448992 451576 454364 461090 461903 463082 463941 464732 465509 466369 466573 471678 471722 473782 474706 474923 475911 475915 478779 478787 480709 483212 487150 491169 493260 495014 495738 495877 495890 499498 506557 506827 508468 510821 517556 519962 521977 531908 533848 533851 535269 536681 538242 542751 545586 548606 548751 557540 562037 564668 565251 565355 566375 566439 570644 573263 581350 590560 593238 601651 614344 616617 621647 631919 632020 632021 633744 637007 640802 665139 674129 682839 683438 685718 690785 713262 720271 721109 722900 728441 729618 733854 741542 790397 797541 799971 807141 808077 809466 810826 814392 814511 818439 821605 827854 ] |
||||||||||||||||||||||||||||||
|
22.51 ms (11.56%) |
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 810826 733854 721109 399568 425281 818439 493260 685718 632021 799971 729618 400162 421204 495877 400932 411688 814511 682839 570644 807141 728441 7981 521977 545586 191048 387544 533851 674129 713262 474923 564668 508468 448992 438001 426009 517556 447265 590560 827854 741542 495738 566375 506557 531908 814392 461090 475915 478779 720271 690785 722900 614344 448383 471722 96371 419932 473782 535269 461903 466573 665139 565251 601651 790397 475911 428406 95673 421201 538242 533848 562037 621647 637007 809466 797541 808077 451576 478787 495890 573263 565355 631919 426547 510821 445681 463082 474706 499498 454364 632020 566439 495014 425332 414723 640802 465509 434456 593238 633744 480709 557540 616617 407895 491169 821605 536681 519962 548751 683438 463941 464732 483212 471678 548606 581350 542751 466369 393724 487150 506827 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.36%) |
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 7981 95673 96371 191048 387544 393724 399568 400162 400932 407895 411688 414723 419932 421201 421204 425281 425332 426009 426547 428406 434456 438001 445681 447265 448383 448992 451576 454364 461090 461903 463082 463941 464732 465509 466369 466573 471678 471722 473782 474706 474923 475911 475915 478779 478787 480709 483212 487150 491169 493260 495014 495738 495877 495890 499498 506557 506827 508468 510821 517556 519962 521977 531908 533848 533851 535269 536681 538242 542751 545586 548606 548751 557540 562037 564668 565251 565355 566375 566439 570644 573263 581350 590560 593238 601651 614344 616617 621647 631919 632020 632021 633744 637007 640802 665139 674129 682839 683438 685718 690785 713262 720271 721109 722900 728441 729618 733854 741542 790397 797541 799971 807141 808077 809466 810826 814392 814511 818439 821605 827854 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hard секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hard threesome"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hard секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.83%) |
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.