Query Metrics
7
Database Queries
7
Different statements
182.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.56 ms (87.99%) |
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 7088 41433 123949 143195 152529 205655 382266 383305 384382 385461 386721 388566 396354 399038 400931 402251 405406 405482 405488 405491 406648 407124 407432 407881 409151 409163 409180 413612 413995 414002 415941 428356 428672 433673 434472 441785 441844 442407 443811 446042 447474 447475 448731 450195 451456 451801 456396 456933 459138 459163 459715 459717 462484 464272 471486 471502 472939 476402 477452 484296 497452 512340 512421 512620 512911 521915 525236 545670 562810 562813 562815 574871 575464 576356 579619 603003 606722 611700 611813 623335 630536 632632 632935 644292 646846 661444 669967 671703 672819 679361 679362 679363 679377 679383 682414 702628 713699 717236 727794 727989 728234 755430 758423 762213 762225 762262 777172 787883 792609 792677 797096 810825 815191 815737 816040 817851 822694 823290 824473 827943 ] |
||||||||||||||||||||||||||||||
|
13.39 ms (7.34%) |
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 823290 682414 755430 787883 661444 630536 405491 817851 632632 41433 497452 407432 632935 7088 433673 143195 679363 152529 441785 815191 792677 797096 727989 623335 409180 205655 816040 679361 669967 758423 459138 385461 413612 405488 679377 471486 762225 123949 388566 441844 446042 405406 762262 671703 679383 512911 399038 459715 402251 409151 713699 822694 679362 384382 824473 451801 672819 728234 777172 476402 512421 383305 428672 702628 382266 477452 574871 611813 471502 603003 396354 409163 386721 827943 646846 472939 415941 815737 407881 434472 459163 512340 606722 810825 727794 611700 414002 562813 400931 462484 579619 405482 576356 644292 717236 451456 459717 406648 521915 545670 448731 413995 442407 447475 456396 450195 428356 484296 464272 575464 562810 792609 762213 447474 562815 443811 456933 525236 407124 512620 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.30%) |
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 7088 41433 123949 143195 152529 205655 382266 383305 384382 385461 386721 388566 396354 399038 400931 402251 405406 405482 405488 405491 406648 407124 407432 407881 409151 409163 409180 413612 413995 414002 415941 428356 428672 433673 434472 441785 441844 442407 443811 446042 447474 447475 448731 450195 451456 451801 456396 456933 459138 459163 459715 459717 462484 464272 471486 471502 472939 476402 477452 484296 497452 512340 512421 512620 512911 521915 525236 545670 562810 562813 562815 574871 575464 576356 579619 603003 606722 611700 611813 623335 630536 632632 632935 644292 646846 661444 669967 671703 672819 679361 679362 679363 679377 679383 682414 702628 713699 717236 727794 727989 728234 755430 758423 762213 762225 762262 777172 787883 792609 792677 797096 810825 815191 815737 816040 817851 822694 823290 824473 827943 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex eva"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс eva"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс eva"
]
|
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.