Query Metrics
7
Database Queries
7
Different statements
178.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.53 ms (85.38%) |
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 17190 212024 387376 388290 390593 395563 397288 399088 399853 400982 401793 401858 412180 413296 416847 417366 417491 417744 419383 421977 423580 428241 430103 430809 433164 437635 441389 443729 447499 447514 451254 451755 456156 461155 461743 463884 463965 464593 475451 478644 482538 485306 485336 487189 489522 491667 491718 494526 497439 497976 501723 507651 512257 512306 518905 522288 527531 527927 530476 530632 530697 533266 533696 537910 537929 541073 543720 552637 557086 561361 561685 561824 561880 565158 565959 566516 574473 574553 574804 574813 574882 575165 575464 575505 576047 576104 576291 576324 578392 594171 595515 596582 597801 598489 598712 603285 629243 642687 644923 663231 665714 666865 667760 680151 680198 686088 692051 697291 720388 729940 735085 737298 740373 747402 753302 765278 780533 786522 799531 817195 ] |
||||||||||||||||||||||||||||||
|
16.75 ms (9.38%) |
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 433164 437635 447514 463965 417491 447499 512257 491667 522288 487189 491718 489522 212024 17190 390593 417366 456156 518905 464593 574473 665714 663231 720388 574813 597801 598489 595515 598712 740373 753302 735085 737298 765278 747402 629243 786522 388290 401858 397288 533266 594171 441389 461155 603285 537929 530476 537910 697291 729940 387376 817195 780533 686088 692051 799531 507651 596582 666865 642687 395563 399088 399853 400982 401793 421977 430809 412180 443729 413296 416847 423580 430103 417744 419383 428241 644923 451755 475451 451254 482538 461743 485306 485336 497976 501723 530697 497439 512306 530632 527531 533696 494526 527927 463884 478644 561824 565158 566516 574553 574882 575464 575505 576104 576291 552637 557086 561880 565959 575165 576324 578392 541073 543720 561361 561685 574804 576047 667760 680151 680198 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.62%) |
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 17190 212024 387376 388290 390593 395563 397288 399088 399853 400982 401793 401858 412180 413296 416847 417366 417491 417744 419383 421977 423580 428241 430103 430809 433164 437635 441389 443729 447499 447514 451254 451755 456156 461155 461743 463884 463965 464593 475451 478644 482538 485306 485336 487189 489522 491667 491718 494526 497439 497976 501723 507651 512257 512306 518905 522288 527531 527927 530476 530632 530697 533266 533696 537910 537929 541073 543720 552637 557086 561361 561685 561824 561880 565158 565959 566516 574473 574553 574804 574813 574882 575165 575464 575505 576047 576104 576291 576324 578392 594171 595515 596582 597801 598489 598712 603285 629243 642687 644923 663231 665714 666865 667760 680151 680198 686088 692051 697291 720388 729940 735085 737298 740373 747402 753302 765278 780533 786522 799531 817195 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits teen"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ teen"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сиськ teen"
]
|
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.