Query Metrics
7
Database Queries
7
Different statements
150.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.04 ms (80.93%) |
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 95673 98543 397306 404904 407011 415004 418928 418959 425609 425977 427199 430389 431133 431442 434286 439650 441110 442307 447253 450226 450814 451252 454241 456333 461059 461694 463107 463305 465256 466294 468650 468884 472125 474830 475592 477147 477185 477555 477708 477974 478032 482788 485975 486450 487364 488477 489471 490196 491266 491398 491937 492128 493197 494171 494513 496835 501228 502279 503153 503376 504139 506038 506705 506803 509024 512215 514765 515972 516750 516770 516775 516979 516998 517005 517196 517368 517723 517732 520673 520778 522187 522353 524257 524860 528297 529548 530268 530371 530765 531227 531905 532813 533613 533831 535045 537202 539786 540944 543860 543888 545909 546773 550063 551904 556421 561132 561515 570899 574756 580263 586645 604631 617048 620244 622990 628312 647995 681137 718745 808472 ] |
||||||||||||||||||||||||||||||
|
17.77 ms (11.78%) |
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 474830 543860 531905 439650 434286 450814 532813 506705 472125 515972 524860 492128 502279 533613 461694 506803 517005 550063 517196 535045 580263 543888 430389 546773 620244 397306 404904 486450 531227 494513 512215 516998 517732 537202 556421 516770 491398 506038 95673 493197 533831 478032 545909 681137 466294 503153 487364 528297 98543 425609 482788 494171 516750 529548 530371 530268 551904 622990 628312 808472 415004 425977 463305 431133 477555 501228 491266 520778 561515 418928 463107 468650 490196 522353 530765 539786 516775 522187 570899 718745 617048 461059 450226 465256 477974 447253 407011 491937 485975 496835 524257 489471 504139 441110 442307 451252 514765 516979 574756 604631 454241 456333 477147 520673 517723 427199 418959 477708 477185 509024 517368 540944 561132 647995 586645 431442 475592 468884 488477 503376 ] |
||||||||||||||||||||||||||||||
|
3.25 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 95673 98543 397306 404904 407011 415004 418928 418959 425609 425977 427199 430389 431133 431442 434286 439650 441110 442307 447253 450226 450814 451252 454241 456333 461059 461694 463107 463305 465256 466294 468650 468884 472125 474830 475592 477147 477185 477555 477708 477974 478032 482788 485975 486450 487364 488477 489471 490196 491266 491398 491937 492128 493197 494171 494513 496835 501228 502279 503153 503376 504139 506038 506705 506803 509024 512215 514765 515972 516750 516770 516775 516979 516998 517005 517196 517368 517723 517732 520673 520778 522187 522353 524257 524860 528297 529548 530268 530371 530765 531227 531905 532813 533613 533831 535045 537202 539786 540944 543860 543888 545909 546773 550063 551904 556421 561132 561515 570899 574756 580263 586645 604631 617048 620244 622990 628312 647995 681137 718745 808472 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature sex slave"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature секс доминирован"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature секс доминирован"
]
|
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.