Query Metrics
7
Database Queries
7
Different statements
185.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.02 ms (84.26%) |
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 37245 37730 119671 282138 288045 381764 382032 382825 383079 383392 383496 383809 384022 384793 385884 386304 386637 386697 388653 395225 396419 401517 402507 405599 410319 411449 413429 415097 416309 416360 416797 417783 419384 421109 425033 429451 435703 445266 445322 449254 450241 450633 458013 458935 461743 461747 461757 463108 464142 468756 472222 472842 472883 473748 474725 475303 475720 477243 477387 477899 481435 482138 483453 483574 484802 485163 485795 492488 494277 496408 496993 505024 512523 513795 516291 525249 525363 527436 536742 536775 539224 551025 562883 564201 566813 568050 573927 587912 587913 588590 598362 608411 641445 642582 675241 676890 678869 719969 729883 732369 735375 737724 738380 749176 760990 761000 767169 771152 773508 785417 787713 792812 792821 793401 797736 805277 810428 816296 818379 827267 ] |
||||||||||||||||||||||||||||||
|
18.18 ms (9.82%) |
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 475303 468756 411449 761000 676890 797736 483574 477387 735375 818379 282138 477243 562883 573927 381764 678869 787713 738380 384793 388653 416309 485795 496993 536775 608411 827267 472842 415097 474725 385884 445266 472222 494277 505024 481435 485163 425033 475720 568050 587913 816296 737724 771152 785417 382032 516291 461757 512523 386697 492488 539224 598362 793401 421109 482138 413429 463108 805277 395225 450633 383079 792821 402507 458935 473748 386637 472883 588590 719969 642582 732369 810428 773508 401517 386304 792812 587912 383809 513795 525363 382825 119671 396419 37245 435703 483453 675241 564201 729883 410319 477899 288045 445322 641445 429451 419384 449254 384022 464142 383392 416360 416797 536742 383496 461743 527436 551025 749176 767169 450241 496408 484802 525249 417783 760990 37730 405599 566813 458013 461747 ] |
||||||||||||||||||||||||||||||
|
3.55 ms (1.92%) |
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 37245 37730 119671 282138 288045 381764 382032 382825 383079 383392 383496 383809 384022 384793 385884 386304 386637 386697 388653 395225 396419 401517 402507 405599 410319 411449 413429 415097 416309 416360 416797 417783 419384 421109 425033 429451 435703 445266 445322 449254 450241 450633 458013 458935 461743 461747 461757 463108 464142 468756 472222 472842 472883 473748 474725 475303 475720 477243 477387 477899 481435 482138 483453 483574 484802 485163 485795 492488 494277 496408 496993 505024 512523 513795 516291 525249 525363 527436 536742 536775 539224 551025 562883 564201 566813 568050 573927 587912 587913 588590 598362 608411 641445 642582 675241 676890 678869 719969 729883 732369 735375 737724 738380 749176 760990 761000 767169 771152 773508 785417 787713 792812 792821 793401 797736 805277 810428 816296 818379 827267 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ebony girl sex"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чернокожая девушк секс"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.82%) |
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.