Query Metrics
7
Database Queries
7
Different statements
182.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.67 ms (86.06%) |
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 249788 390908 404540 407250 416367 418422 418852 420629 421109 421238 423239 429033 429930 437793 438889 439868 439869 443047 446254 449001 451683 453228 460770 461617 462123 463161 466252 466588 468462 469865 471359 473771 474585 476421 477552 479197 480807 481451 484842 484849 484956 487038 488700 490625 491585 497067 499782 504900 505144 505952 508043 517195 522620 527791 540304 540574 540601 548092 553674 554789 557415 559219 559912 559985 560432 560655 561901 570627 572314 574636 575059 575078 579375 584576 586835 594090 596638 598547 599855 600018 600473 605435 608378 611103 613426 625489 643624 648648 651578 669339 671060 678783 688997 693291 696114 699788 710587 712276 712814 729886 730076 734481 739073 742434 744927 747574 750090 759405 772991 788540 790369 792060 792722 803190 804801 811950 813933 819585 ] |
||||||||||||||||||||||||||||||
|
15.42 ms (8.47%) |
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 527791 540601 734481 825317 823159 437793 491585 557415 594090 742434 481451 418422 522620 484842 505952 484849 484956 249788 423239 439869 813933 819585 469865 490625 574636 579375 699788 710587 671060 584576 608378 599855 600018 605435 772991 788540 804801 750090 759405 747574 792060 803190 451683 418852 466252 540574 390908 404540 421109 517195 560432 548092 429930 443047 477552 505144 559219 559985 561901 553674 554789 648648 651578 678783 688997 693291 712814 669339 696114 712276 560655 570627 643624 600473 625489 586835 611103 613426 811950 729886 790369 739073 730076 744927 792722 449001 407250 421238 438889 439868 416367 420629 487038 453228 460770 473771 466588 474585 497067 540304 559912 575059 575078 572314 598547 596638 429033 446254 476421 480807 463161 471359 461617 462123 468462 479197 504900 499782 508043 488700 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.68%) |
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 249788 390908 404540 407250 416367 418422 418852 420629 421109 421238 423239 429033 429930 437793 438889 439868 439869 443047 446254 449001 451683 453228 460770 461617 462123 463161 466252 466588 468462 469865 471359 473771 474585 476421 477552 479197 480807 481451 484842 484849 484956 487038 488700 490625 491585 497067 499782 504900 505144 505952 508043 517195 522620 527791 540304 540574 540601 548092 553674 554789 557415 559219 559912 559985 560432 560655 561901 570627 572314 574636 575059 575078 579375 584576 586835 594090 596638 598547 599855 600018 600473 605435 608378 611103 613426 625489 643624 648648 651578 669339 671060 678783 688997 693291 696114 699788 710587 712276 712814 729886 730076 734481 739073 742434 744927 747574 750090 759405 772991 788540 790369 792060 792722 803190 804801 811950 813933 819585 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits skinny"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сиськ худые"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.