Query Metrics
7
Database Queries
7
Different statements
231.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
201.73 ms (87.17%) |
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 182110 182118 182136 182154 182238 182754 183074 272725 275727 357499 381812 382272 382281 382390 382723 383560 383571 384463 384480 385653 387293 387520 394648 398099 400942 405690 407398 409909 414077 414119 415857 418112 418139 423651 424606 425431 426259 429596 429601 429602 430374 434286 434336 434338 434350 439125 440639 443240 443243 443247 444117 449022 449023 452876 454688 455914 458761 460016 460813 467877 467929 468255 468813 469046 469092 469139 469158 470428 475319 475431 476046 476191 476654 481871 481961 482293 486768 486772 486778 493258 493838 500789 500897 500912 511272 511277 516028 529795 531185 555236 555771 569701 569749 593044 593053 599502 652772 660385 660419 666426 708195 720140 722379 727935 731779 731785 744391 755945 768385 799696 800542 800551 800698 800733 802182 808125 826829 826832 827619 827633 ] |
||||||||||||||||||||||||||||||
|
18.51 ms (8.00%) |
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 384463 382272 182754 808125 182238 387520 384480 800698 708195 182154 182136 744391 434286 400942 666426 799696 768385 482293 382281 444117 475431 720140 800542 800733 827619 426259 467877 467929 423651 500897 599502 357499 275727 382390 381812 387293 429602 449022 470428 439125 183074 460813 486778 826829 826832 569749 731779 731785 481871 469046 727935 475319 182118 418112 434336 418139 429596 449023 415857 434338 443240 493258 182110 827633 569701 469092 529795 593044 443243 425431 414077 430374 486772 800551 272725 398099 476046 555236 555771 652772 755945 722379 469158 443247 460016 385653 383560 405690 407398 531185 593053 469139 383571 394648 429601 486768 468255 468813 481961 511277 493838 516028 382723 458761 500912 511272 476191 414119 424606 409909 434350 440639 455914 454688 500789 660385 660419 802182 452876 476654 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (1.46%) |
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 182110 182118 182136 182154 182238 182754 183074 272725 275727 357499 381812 382272 382281 382390 382723 383560 383571 384463 384480 385653 387293 387520 394648 398099 400942 405690 407398 409909 414077 414119 415857 418112 418139 423651 424606 425431 426259 429596 429601 429602 430374 434286 434336 434338 434350 439125 440639 443240 443243 443247 444117 449022 449023 452876 454688 455914 458761 460016 460813 467877 467929 468255 468813 469046 469092 469139 469158 470428 475319 475431 476046 476191 476654 481871 481961 482293 486768 486772 486778 493258 493838 500789 500897 500912 511272 511277 516028 529795 531185 555236 555771 569701 569749 593044 593053 599502 652772 660385 660419 666426 708195 720140 722379 727935 731779 731785 744391 755945 768385 799696 800542 800551 800698 800733 802182 808125 826829 826832 827619 827633 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature sex machine"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature сексмашин"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.