Query Metrics
7
Database Queries
7
Different statements
152.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.01 ms (85.38%) |
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 56810 382499 386228 391774 408842 428632 447306 450639 454891 456843 468926 490622 490810 490814 495871 499648 515524 528985 529382 530094 530323 532562 533700 534628 537828 538599 538753 538838 539503 539597 539598 540857 544339 546398 547340 549259 549269 549275 549277 549329 549331 549373 549380 549385 549393 549420 549515 549957 550045 551106 552551 554034 557255 557285 560502 565070 566800 572561 572564 572594 576480 581621 583532 583814 583827 583831 583853 586126 586988 592740 593263 596924 598648 601220 601791 611382 614483 614592 615615 615722 618405 619646 623570 624914 629941 647721 647745 656406 656813 680933 690373 696168 716232 735410 737908 738633 751538 758926 760633 768057 774578 780961 788996 792581 798433 802917 804350 806518 807210 808495 810478 811987 814793 816831 819213 819351 819364 821761 822657 827203 ] |
||||||||||||||||||||||||||||||
|
13.49 ms (8.86%) |
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 454891 540857 538599 533700 552551 549269 611382 629941 774578 382499 538838 583827 560502 557255 581621 647745 619646 758926 806518 386228 819213 528985 534628 549275 566800 549329 614592 751538 490810 549331 810478 737908 827203 530094 572564 583814 549385 656406 56810 447306 515524 408842 814793 499648 551106 656813 696168 716232 546398 547340 549277 557285 583853 586126 615615 601220 615722 821761 822657 819351 819364 539598 537828 529382 576480 549259 647721 680933 596924 624914 811987 490814 598648 490622 538753 530323 544339 690373 593263 601791 808495 735410 738633 450639 539503 792581 428632 539597 550045 768057 802917 456843 495871 554034 798433 391774 816831 532562 549373 549420 549515 565070 549380 572561 549393 549957 572594 583831 586988 623570 592740 614483 618405 780961 804350 760633 788996 807210 468926 583532 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.44%) |
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 56810 382499 386228 391774 408842 428632 447306 450639 454891 456843 468926 490622 490810 490814 495871 499648 515524 528985 529382 530094 530323 532562 533700 534628 537828 538599 538753 538838 539503 539597 539598 540857 544339 546398 547340 549259 549269 549275 549277 549329 549331 549373 549380 549385 549393 549420 549515 549957 550045 551106 552551 554034 557255 557285 560502 565070 566800 572561 572564 572594 576480 581621 583532 583814 583827 583831 583853 586126 586988 592740 593263 596924 598648 601220 601791 611382 614483 614592 615615 615722 618405 619646 623570 624914 629941 647721 647745 656406 656813 680933 690373 696168 716232 735410 737908 738633 751538 758926 760633 768057 774578 780961 788996 792581 798433 802917 804350 806518 807210 808495 810478 811987 814793 816831 819213 819351 819364 821761 822657 827203 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"nude tits"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"nude сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"nude сиськ"
]
|
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.