Query Metrics
7
Database Queries
7
Different statements
176.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.53 ms (83.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 381777 394773 395606 396780 398678 401909 411419 411588 412618 419617 421201 426096 429526 432692 442970 443158 443363 444137 444251 447523 451566 455174 455830 456173 458712 458713 459727 462334 464716 473269 473989 476036 478805 479091 479272 480239 484451 485687 487927 490935 491709 493174 493311 496259 496595 501901 506218 506833 511368 514414 514843 515846 516728 516969 517279 520004 520520 520677 521875 522206 523590 524877 526947 527438 532939 535667 535707 537976 538624 541897 545988 548388 549787 551121 551386 552089 552324 552679 554757 555420 562463 562887 563419 565147 565561 565790 566325 566686 575852 577897 580251 580666 581564 581637 583522 587935 588151 588494 591627 592184 592222 592591 592890 599040 599617 602724 610235 610559 614428 618045 618344 620398 654000 659460 670839 671864 673791 688382 721421 723616 ] |
||||||||||||||||||||||||||||||
|
19.49 ms (11.04%) |
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 444251 520677 538624 541897 671864 618344 602724 476036 577897 458712 514414 566325 549787 592890 398678 473269 479091 537976 552324 563419 592591 587935 487927 535667 591627 412618 491709 496595 506833 548388 688382 451566 610235 479272 394773 562463 442970 455174 511368 459727 521875 516969 566686 580251 565790 456173 458713 480239 485687 562887 670839 599617 411588 473989 552089 583522 443363 411419 516728 575852 520004 462334 432692 426096 618045 514843 523590 381777 396780 429526 659460 592222 723616 517279 552679 592184 535707 506218 599040 614428 455830 493174 443158 419617 522206 555420 581564 581637 673791 565147 484451 478805 526947 527438 565561 515846 520520 554757 654000 551121 721421 551386 401909 444137 421201 588151 447523 580666 545988 588494 501901 620398 532939 610559 493311 464716 395606 490935 496259 524877 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.63%) |
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 381777 394773 395606 396780 398678 401909 411419 411588 412618 419617 421201 426096 429526 432692 442970 443158 443363 444137 444251 447523 451566 455174 455830 456173 458712 458713 459727 462334 464716 473269 473989 476036 478805 479091 479272 480239 484451 485687 487927 490935 491709 493174 493311 496259 496595 501901 506218 506833 511368 514414 514843 515846 516728 516969 517279 520004 520520 520677 521875 522206 523590 524877 526947 527438 532939 535667 535707 537976 538624 541897 545988 548388 549787 551121 551386 552089 552324 552679 554757 555420 562463 562887 563419 565147 565561 565790 566325 566686 575852 577897 580251 580666 581564 581637 583522 587935 588151 588494 591627 592184 592222 592591 592890 599040 599617 602724 610235 610559 614428 618045 618344 620398 654000 659460 670839 671864 673791 688382 721421 723616 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс и вана"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс ван"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.98%) |
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.