Query Metrics
7
Database Queries
7
Different statements
305.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
276.01 ms (90.49%) |
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 168687 396331 398976 400495 418795 418896 420157 421831 421876 421885 428783 433051 433792 433888 434629 434839 435108 439431 439731 441158 444750 444919 445087 450301 453967 455513 456067 456581 458152 459298 461036 462350 463032 463456 463460 468916 475224 475552 478652 483188 484247 487932 489381 500031 500605 501957 503834 505578 505983 506693 509043 512950 513847 514847 515759 516968 517680 518004 518627 519611 520165 520761 521175 522433 522626 524139 524176 526494 526687 527685 528322 528584 529618 530448 536406 538119 542383 550522 551908 551935 558216 559979 562941 563330 572250 578693 582499 584171 584229 585193 585454 587468 588404 589310 596897 600794 601414 602883 603768 606907 612687 621457 626659 628267 632722 636355 639670 661989 671219 674350 674905 722422 760411 764123 778229 781011 801249 801653 812298 812547 ] |
||||||||||||||||||||||||||||||
|
20.33 ms (6.66%) |
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 801653 456067 456581 512950 661989 475224 418896 421831 421876 462350 530448 528322 572250 606907 396331 400495 484247 418795 489381 168687 439431 563330 596897 801249 671219 441158 639670 434839 450301 463460 453967 521175 526687 517680 538119 463032 578693 584229 550522 674350 628267 589310 636355 600794 433051 434629 503834 500031 558216 506693 513847 487932 674905 778229 516968 522433 542383 585454 621457 444919 527685 515759 522626 514847 562941 468916 444750 551935 603768 518004 398976 459298 433888 435108 439731 509043 518627 526494 461036 524176 588404 520165 585193 505578 529618 601414 524139 428783 520761 420157 483188 536406 612687 602883 433792 584171 505983 551908 722422 587468 626659 781011 764123 812547 760411 445087 455513 559979 582499 458152 501957 519611 500605 812298 632722 528584 463456 475552 421885 478652 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (0.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 168687 396331 398976 400495 418795 418896 420157 421831 421876 421885 428783 433051 433792 433888 434629 434839 435108 439431 439731 441158 444750 444919 445087 450301 453967 455513 456067 456581 458152 459298 461036 462350 463032 463456 463460 468916 475224 475552 478652 483188 484247 487932 489381 500031 500605 501957 503834 505578 505983 506693 509043 512950 513847 514847 515759 516968 517680 518004 518627 519611 520165 520761 521175 522433 522626 524139 524176 526494 526687 527685 528322 528584 529618 530448 536406 538119 542383 550522 551908 551935 558216 559979 562941 563330 572250 578693 582499 584171 584229 585193 585454 587468 588404 589310 596897 600794 601414 602883 603768 606907 612687 621457 626659 628267 632722 636355 639670 661989 671219 674350 674905 722422 760411 764123 778229 781011 801249 801653 812298 812547 ] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"замужние раком в трус%…"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен рак в трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.