Query Metrics
7
Database Queries
7
Different statements
161.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.23 ms (87.60%) |
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 7065 183634 187704 187723 188373 233340 233353 358566 387856 388713 388725 388766 388784 391287 391588 391659 392208 397885 406648 408207 409938 411408 425321 439439 439634 439724 439791 439806 439810 439821 440222 440801 440911 440947 444156 445625 453833 465460 465540 465953 466244 468373 470424 470468 471678 478378 483649 483656 490783 492292 496873 506067 506212 513968 517013 522510 523845 526401 533734 536456 547422 549221 555103 572669 573303 589608 591333 621536 632268 640312 647955 673536 680434 695380 696308 709545 714895 719957 724875 725030 725553 726936 726980 727503 727735 727778 727789 728170 729291 733375 734323 734390 736099 740115 740882 743829 747958 758096 758152 759878 759941 760973 761030 764144 767180 773271 785859 785934 788544 788565 797206 797392 802136 804524 810830 811118 823444 824613 827054 827484 ] |
||||||||||||||||||||||||||||||
|
11.47 ms (7.12%) |
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 696308 387856 466244 478378 483649 483656 536456 506067 388713 358566 591333 440911 453833 513968 573303 714895 802136 727778 759941 233353 391287 727735 758152 726980 758096 533734 647955 785859 811118 773271 728170 764144 797392 490783 465953 470424 439634 439724 439810 439791 439821 440222 797206 788565 408207 465460 740882 187723 388725 726936 440801 827484 725030 761030 187704 440947 465540 388766 409938 827054 621536 188373 397885 439806 824613 547422 7065 695380 727503 734323 183634 411408 233340 388784 392208 729291 439439 572669 470468 445625 468373 680434 719957 555103 785934 810830 725553 740115 724875 743829 760973 727789 733375 736099 709545 788544 804524 444156 522510 823444 471678 589608 391659 517013 496873 506212 549221 632268 391588 406648 523845 526401 673536 640312 767180 759878 734390 747958 492292 425321 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.50%) |
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 7065 183634 187704 187723 188373 233340 233353 358566 387856 388713 388725 388766 388784 391287 391588 391659 392208 397885 406648 408207 409938 411408 425321 439439 439634 439724 439791 439806 439810 439821 440222 440801 440911 440947 444156 445625 453833 465460 465540 465953 466244 468373 470424 470468 471678 478378 483649 483656 490783 492292 496873 506067 506212 513968 517013 522510 523845 526401 533734 536456 547422 549221 555103 572669 573303 589608 591333 621536 632268 640312 647955 673536 680434 695380 696308 709545 714895 719957 724875 725030 725553 726936 726980 727503 727735 727778 727789 728170 729291 733375 734323 734390 736099 740115 740882 743829 747958 758096 758152 759878 759941 760973 761030 764144 767180 773271 785859 785934 788544 788565 797206 797392 802136 804524 810830 811118 823444 824613 827054 827484 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal milf mature"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал milf mature"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.28 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал milf mature"
]
|
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.