Query Metrics
7
Database Queries
7
Different statements
194.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.97 ms (82.66%) |
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 10006 251363 383744 384285 384321 385303 385471 386303 386712 386860 387270 387377 388470 395170 395841 396171 396270 399250 399292 399300 399511 400461 400465 400854 400927 401313 401351 401881 403496 405078 406203 407320 417851 418653 418803 420600 422501 422509 422569 423398 424074 430333 434167 435646 443979 445938 446254 447371 447417 447495 450778 451438 454250 456909 457679 461098 463161 464277 464580 466874 467152 469531 469646 470844 471524 472921 475453 484088 495030 502302 503958 515091 515143 519629 522443 539469 542359 546002 547998 554307 556845 558059 560219 560473 560541 566507 569671 574808 574839 581613 590186 590224 591418 597460 597574 603591 607193 659635 670566 684235 687929 693073 705977 707347 712441 722706 727801 732396 740854 741480 744155 744312 747854 766990 777345 797216 800563 802269 804704 807772 ] |
||||||||||||||||||||||||||||||
|
23.84 ms (12.24%) |
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 597460 560219 399300 659635 684235 547998 797216 802269 744155 741480 705977 804704 385471 386303 386860 385303 384321 383744 395170 10006 388470 387270 396171 396270 400461 400465 399511 400854 399292 401881 401351 405078 406203 403496 417851 422501 430333 435646 422569 418653 447371 450778 457679 464277 447417 447495 502302 539469 522443 472921 542359 554307 558059 574808 581613 560473 569671 574839 560541 707347 670566 687929 693073 712441 722706 546002 556845 566507 591418 597574 607193 590186 590224 777345 800563 807772 727801 740854 766990 732396 744312 747854 603591 418803 446254 456909 384285 386712 399250 400927 407320 434167 463161 466874 467152 469531 470844 471524 387377 395841 424074 443979 445938 451438 461098 251363 401313 422509 423398 454250 475453 420600 464580 469646 515091 515143 503958 519629 484088 495030 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.41%) |
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 10006 251363 383744 384285 384321 385303 385471 386303 386712 386860 387270 387377 388470 395170 395841 396171 396270 399250 399292 399300 399511 400461 400465 400854 400927 401313 401351 401881 403496 405078 406203 407320 417851 418653 418803 420600 422501 422509 422569 423398 424074 430333 434167 435646 443979 445938 446254 447371 447417 447495 450778 451438 454250 456909 457679 461098 463161 464277 464580 466874 467152 469531 469646 470844 471524 472921 475453 484088 495030 502302 503958 515091 515143 519629 522443 539469 542359 546002 547998 554307 556845 558059 560219 560473 560541 566507 569671 574808 574839 581613 590186 590224 591418 597460 597574 603591 607193 659635 670566 684235 687929 693073 705977 707347 712441 722706 727801 732396 740854 741480 744155 744312 747854 766990 777345 797216 800563 802269 804704 807772 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"man such"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.76%) |
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.