Query Metrics
7
Database Queries
7
Different statements
218.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
192.52 ms (87.91%) |
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 6696 16831 16897 30897 33998 53499 55146 74588 86358 88614 96800 97450 97480 107606 111630 129791 153440 176148 185601 191412 191529 192223 197574 197757 228779 234067 236378 258166 277079 278488 321414 327134 357915 359089 382085 382303 382620 382839 383053 383701 383820 384780 385388 385754 385949 386451 386930 387806 390846 390987 391227 394109 396322 398921 400976 401562 404112 407387 407910 413792 417202 441024 446137 459833 464687 466430 468552 475354 484939 489994 510056 519717 521135 521159 521306 530749 531632 536716 538770 542441 553294 557446 565228 566654 575897 587196 601122 606697 609835 612809 621715 629040 630567 637632 642295 643335 646286 663237 666832 667234 690326 713331 717833 721755 731787 740131 742870 749989 752429 754418 754436 756109 773442 779066 782292 786485 791528 792843 809766 811456 ] |
||||||||||||||||||||||||||||||
|
16.43 ms (7.50%) |
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 441024 521135 521306 756109 587196 521159 606697 475354 489994 612809 191412 97450 278488 809766 185601 383701 258166 630567 55146 86358 97480 236378 6696 754436 191529 387806 30897 385388 742870 782292 621715 459833 646286 383820 382303 16897 390846 390987 690326 667234 385949 566654 327134 398921 407387 234067 663237 129791 33998 484939 382085 519717 530749 542441 721755 792843 383053 153440 386930 666832 359089 382839 176148 510056 277079 192223 717833 468552 575897 228779 385754 53499 407910 791528 749989 111630 107606 357915 391227 88614 413792 754418 713331 779066 382620 731787 773442 400976 394109 464687 531632 811456 74588 740131 96800 536716 557446 601122 384780 16831 565228 752429 786485 197574 321414 404112 466430 553294 643335 401562 538770 417202 396322 446137 629040 637632 609835 642295 386451 197757 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.23%) |
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 6696 16831 16897 30897 33998 53499 55146 74588 86358 88614 96800 97450 97480 107606 111630 129791 153440 176148 185601 191412 191529 192223 197574 197757 228779 234067 236378 258166 277079 278488 321414 327134 357915 359089 382085 382303 382620 382839 383053 383701 383820 384780 385388 385754 385949 386451 386930 387806 390846 390987 391227 394109 396322 398921 400976 401562 404112 407387 407910 413792 417202 441024 446137 459833 464687 466430 468552 475354 484939 489994 510056 519717 521135 521159 521306 530749 531632 536716 538770 542441 553294 557446 565228 566654 575897 587196 601122 606697 609835 612809 621715 629040 630567 637632 642295 643335 646286 663237 666832 667234 690326 713331 717833 721755 731787 740131 742870 749989 752429 754418 754436 756109 773442 779066 782292 786485 791528 792843 809766 811456 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big boobs blonde"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие boobs беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие boobs беловолосая"
]
|
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.