Query Metrics
7
Database Queries
7
Different statements
153.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.08 ms (82.03%) |
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 396557 415896 421797 423021 423349 424314 431476 434779 434931 437285 437310 446394 448121 448215 453494 455039 459189 461144 462008 463068 463663 466490 472935 473766 483320 487525 489648 492529 492779 493169 496527 500363 500503 501734 504091 511184 512012 512478 512991 513824 513828 518328 519200 520205 520427 520753 521828 523212 524751 524777 525049 525547 525868 526130 526540 527054 527304 527453 528586 534375 539748 544113 544490 546594 547824 549214 551136 552348 552466 554881 555736 559173 561289 561488 561898 565779 566086 569921 571976 576990 578774 578816 580613 581552 584328 594228 595099 595723 596901 598980 601180 601347 603985 605378 605442 609225 612490 612507 613977 614621 615482 615680 619201 621412 621494 621520 625235 625594 634725 636371 650056 661382 666714 675374 715234 724481 751572 770225 779012 807914 ] |
||||||||||||||||||||||||||||||
|
17.08 ms (11.11%) |
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 492529 555736 576990 578816 612490 603985 625594 751572 462008 552348 463663 434779 415896 520427 487525 534375 489648 561289 554881 636371 779012 455039 525049 525868 512012 466490 521828 807914 513824 512478 493169 595723 396557 423021 437310 527453 561898 569921 715234 598980 724481 526130 459189 524777 518328 621412 448215 526540 500503 661382 581552 666714 565779 504091 461144 650056 612507 527054 605378 605442 615680 424314 519200 472935 561488 595099 601180 634725 473766 544113 437285 496527 566086 544490 547824 571976 619201 621494 613977 431476 546594 525547 549214 527304 524751 520205 512991 511184 552466 448121 483320 513828 434931 423349 463068 523212 501734 578774 551136 559173 421797 601347 596901 492779 584328 528586 446394 453494 770225 539748 675374 614621 625235 594228 580613 609225 500363 615482 520753 621520 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.58%) |
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 396557 415896 421797 423021 423349 424314 431476 434779 434931 437285 437310 446394 448121 448215 453494 455039 459189 461144 462008 463068 463663 466490 472935 473766 483320 487525 489648 492529 492779 493169 496527 500363 500503 501734 504091 511184 512012 512478 512991 513824 513828 518328 519200 520205 520427 520753 521828 523212 524751 524777 525049 525547 525868 526130 526540 527054 527304 527453 528586 534375 539748 544113 544490 546594 547824 549214 551136 552348 552466 554881 555736 559173 561289 561488 561898 565779 566086 569921 571976 576990 578774 578816 580613 581552 584328 594228 595099 595723 596901 598980 601180 601347 603985 605378 605442 609225 612490 612507 613977 614621 615482 615680 619201 621412 621494 621520 625235 625594 634725 636371 650056 661382 666714 675374 715234 724481 751572 770225 779012 807914 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hotel blowjob"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hotel минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hotel минет оральн секс"
]
|
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.