Query Metrics
7
Database Queries
7
Different statements
190.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.17 ms (85.06%) |
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 96665 385752 388903 390623 390713 395182 397780 400942 402649 406128 407313 414135 416294 417836 419523 419694 421043 424613 427245 432766 435695 446079 446110 448806 450455 452832 454188 457701 460208 460305 461315 462305 462317 464326 464959 467872 467893 468072 468073 468096 468099 468154 468835 469616 472659 473223 476180 482527 482552 484283 484645 485130 489868 490517 491259 493127 493202 493835 496835 497827 502775 508807 509800 511027 513195 518238 519309 520684 522592 538870 543855 550925 554866 574298 576636 576695 580265 584004 586673 590418 594340 596844 602259 609887 614833 615748 622335 631930 642022 643767 648204 656200 658773 670286 680215 692732 694222 696120 710460 715368 720714 722212 724268 727560 733416 744463 758256 775869 788187 796297 798705 800429 808472 815119 815943 817119 817632 823746 824456 825044 ] |
||||||||||||||||||||||||||||||
|
18.94 ms (9.94%) |
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 427245 519309 508807 468835 462305 462317 493127 454188 468072 509800 419523 388903 390713 414135 468099 395182 824456 580265 432766 419694 464959 468154 576695 518238 485130 715368 522592 658773 594340 482527 424613 490517 450455 502775 513195 469616 543855 400942 406128 468073 473223 497827 710460 609887 643767 744463 720714 417836 446079 511027 815119 472659 648204 670286 574298 631930 642022 590418 602259 622335 724268 808472 448806 467872 467893 496835 484283 464326 385752 390623 817632 823746 815943 817119 538870 554866 694222 722212 656200 680215 696120 596844 798705 733416 758256 452832 727560 407313 416294 457701 493202 614833 397780 520684 460305 476180 550925 692732 775869 788187 800429 796297 461315 96665 584004 435695 491259 493835 576636 615748 402649 421043 446110 460208 482552 489868 468096 484645 825044 586673 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.05%) |
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 96665 385752 388903 390623 390713 395182 397780 400942 402649 406128 407313 414135 416294 417836 419523 419694 421043 424613 427245 432766 435695 446079 446110 448806 450455 452832 454188 457701 460208 460305 461315 462305 462317 464326 464959 467872 467893 468072 468073 468096 468099 468154 468835 469616 472659 473223 476180 482527 482552 484283 484645 485130 489868 490517 491259 493127 493202 493835 496835 497827 502775 508807 509800 511027 513195 518238 519309 520684 522592 538870 543855 550925 554866 574298 576636 576695 580265 584004 586673 590418 594340 596844 602259 609887 614833 615748 622335 631930 642022 643767 648204 656200 658773 670286 680215 692732 694222 696120 710460 715368 720714 722212 724268 727560 733416 744463 758256 775869 788187 796297 798705 800429 808472 815119 815943 817119 817632 823746 824456 825044 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"волосатую зрелку в попу"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая зрелая женщин анал"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.80%) |
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.