Query Metrics
7
Database Queries
7
Different statements
185.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.73 ms (84.68%) |
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 417097 417232 417704 417789 420301 424180 425562 425580 427081 428076 428467 428610 433419 436463 438577 440164 441280 442399 442416 442422 442477 445830 445843 447273 451220 454035 454959 454966 456061 457569 457581 459255 460345 461115 461136 462876 464361 466904 466924 467728 469558 470804 473476 475645 477414 484010 484332 491337 495245 496512 498768 501033 502194 502584 502611 508653 508868 519122 523898 524813 527851 530628 533665 539329 539349 539504 541068 544117 554782 558809 563563 563732 564253 565288 565421 565742 567722 571809 574712 579584 579678 580585 581181 582861 584707 585111 587156 588331 591988 594170 599385 600983 601006 637905 661463 664258 666021 696124 696555 700821 726968 736672 744222 756322 764247 765493 780430 780442 781852 787065 794224 794530 794733 798351 803814 808228 808239 809649 809693 812372 ] |
||||||||||||||||||||||||||||||
|
19.58 ms (10.58%) |
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 441280 501033 459255 502584 428610 563563 581181 744222 417232 442399 466924 462876 473476 523898 524813 466904 477414 544117 574712 467728 445830 527851 496512 571809 594170 637905 794733 417097 442422 585111 464361 491337 457581 460345 495245 539329 539349 530628 541068 567722 579584 554782 696555 661463 664258 696124 564253 579678 580585 582861 584707 600983 601006 587156 808228 809649 780442 781852 794530 809693 812372 764247 787065 808239 765493 726968 756322 780430 798351 803814 424180 438577 469558 425562 427081 433419 440164 451220 475645 498768 484010 563732 417704 436463 420301 454966 445843 447273 461115 456061 533665 539504 502194 508868 558809 565288 565742 666021 565421 588331 428076 454035 428467 442477 454959 470804 442416 461136 502611 484332 508653 519122 599385 591988 700821 794224 736672 417789 457569 425580 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.22%) |
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 417097 417232 417704 417789 420301 424180 425562 425580 427081 428076 428467 428610 433419 436463 438577 440164 441280 442399 442416 442422 442477 445830 445843 447273 451220 454035 454959 454966 456061 457569 457581 459255 460345 461115 461136 462876 464361 466904 466924 467728 469558 470804 473476 475645 477414 484010 484332 491337 495245 496512 498768 501033 502194 502584 502611 508653 508868 519122 523898 524813 527851 530628 533665 539329 539349 539504 541068 544117 554782 558809 563563 563732 564253 565288 565421 565742 567722 571809 574712 579584 579678 580585 581181 582861 584707 585111 587156 588331 591988 594170 599385 600983 601006 637905 661463 664258 666021 696124 696555 700821 726968 736672 744222 756322 764247 765493 780430 780442 781852 787065 794224 794530 794733 798351 803814 808228 808239 809649 809693 812372 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov chubby girl"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов chubby девушк"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов chubby девушк"
]
|
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.