Query Metrics
7
Database Queries
7
Different statements
185.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.57 ms (87.53%) |
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 79942 387693 390257 401229 404000 418132 418256 418975 419616 420351 421346 421802 422819 423584 423765 423907 424214 426771 428027 432383 432431 432433 432453 432481 432485 432504 432534 432540 433373 433429 433640 433707 433822 435620 457348 459066 462588 469147 471712 472621 472812 475288 475643 480091 480557 483855 490257 493571 496020 496846 500654 503877 505992 508696 511473 513582 515637 521480 525975 526880 532057 534475 535962 536100 553655 555063 559365 561916 564379 565819 578877 583538 604320 622686 660076 663193 686862 687422 695701 695730 695733 695734 695777 695793 695812 708505 710093 710173 713038 718891 721819 727040 730741 735834 735959 739814 739960 753504 757238 757559 760598 760875 760881 761834 767638 767669 767984 768691 772230 777761 778858 785584 788778 791758 791763 797052 812732 814206 ] |
||||||||||||||||||||||||||||||
|
12.98 ms (6.99%) |
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 532057 535962 508696 525975 561916 559365 687422 695734 695812 710173 718891 708505 710093 660076 663193 713038 604320 623097 778858 791758 788778 735959 739814 760598 785584 791763 753504 757559 760881 768691 739960 757238 760875 767669 735834 767638 772230 730741 761834 767984 721819 777761 797052 812732 79942 423907 432383 432485 433822 459066 469147 421802 432433 432481 433640 472812 404000 432431 432453 432504 432534 432540 390257 419616 426771 433707 480557 422819 433373 475643 521480 526880 483855 500654 553655 695777 578877 727040 462588 565819 401229 424214 420351 622686 511473 457348 471712 564379 686862 602781 418256 433429 515637 493571 387693 421346 423584 423765 418975 428027 435620 418132 814206 472621 480091 505992 503877 536100 496020 496846 513582 534475 475288 490257 583538 555063 695701 695733 695793 695730 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (1.82%) |
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 79942 387693 390257 401229 404000 418132 418256 418975 419616 420351 421346 421802 422819 423584 423765 423907 424214 426771 428027 432383 432431 432433 432453 432481 432485 432504 432534 432540 433373 433429 433640 433707 433822 435620 457348 459066 462588 469147 471712 472621 472812 475288 475643 480091 480557 483855 490257 493571 496020 496846 500654 503877 505992 508696 511473 513582 515637 521480 525975 526880 532057 534475 535962 536100 553655 555063 559365 561916 564379 565819 578877 583538 604320 622686 660076 663193 686862 687422 695701 695730 695733 695734 695777 695793 695812 708505 710093 710173 713038 718891 721819 727040 730741 735834 735959 739814 739960 753504 757238 757559 760598 760875 760881 761834 767638 767669 767984 768691 772230 777761 778858 785584 788778 791758 791763 797052 812732 814206 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"порно в колготках женâ…"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"порн колготк жен"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.