Query Metrics
7
Database Queries
7
Different statements
174.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.05 ms (86.77%) |
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 426959 449872 455343 464237 468190 479512 484250 489796 495210 497056 498984 501080 512424 514341 519518 522615 527075 527339 529454 541954 542927 546840 558394 558979 562043 564941 565220 565359 578067 579110 581285 583779 589347 589783 591211 592337 599631 612048 620707 622020 630399 633916 634376 635357 639525 649837 652283 655542 659956 666991 668403 672422 676760 678713 687751 689478 691224 692435 694425 694432 695647 695654 695660 695667 695677 695682 695962 696019 696032 696050 696051 696055 696069 696432 696617 696628 696673 696699 696700 697088 698229 698802 699859 700177 701623 701644 702360 702443 706067 709932 712660 718530 720729 721072 722304 726931 729564 731002 731027 732128 734030 738664 738976 745994 746633 749604 751769 757558 757603 758942 767437 789065 793210 797854 817497 828032 828135 828137 828139 828140 ] |
||||||||||||||||||||||||||||||
|
11.54 ms (6.63%) |
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 565359 578067 449872 479512 455343 522615 464237 767437 498984 749604 558394 678713 599631 699859 789065 514341 797854 527339 426959 489796 484250 718530 817497 546840 529454 562043 793210 565220 589783 468190 691224 731002 751769 634376 745994 757603 697088 495210 828135 695654 583779 746633 501080 695647 695682 726931 758942 558979 620707 581285 687751 695677 692435 668403 696051 639525 630399 542927 698229 622020 696019 706067 695660 695962 828137 828032 633916 541954 702360 696032 720729 722304 696700 702443 579110 592337 738664 731027 612048 696432 497056 564941 698802 696069 635357 591211 589347 700177 738976 828140 757558 696050 649837 696617 659956 676760 701623 701644 734030 729564 689478 828139 512424 519518 732128 721072 527075 655542 694425 696055 712660 672422 695667 709932 652283 666991 694432 696628 696673 696699 ] |
||||||||||||||||||||||||||||||
|
3.41 ms (1.96%) |
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 426959 449872 455343 464237 468190 479512 484250 489796 495210 497056 498984 501080 512424 514341 519518 522615 527075 527339 529454 541954 542927 546840 558394 558979 562043 564941 565220 565359 578067 579110 581285 583779 589347 589783 591211 592337 599631 612048 620707 622020 630399 633916 634376 635357 639525 649837 652283 655542 659956 666991 668403 672422 676760 678713 687751 689478 691224 692435 694425 694432 695647 695654 695660 695667 695677 695682 695962 696019 696032 696050 696051 696055 696069 696432 696617 696628 696673 696699 696700 697088 698229 698802 699859 700177 701623 701644 702360 702443 706067 709932 712660 718530 720729 721072 722304 726931 729564 731002 731027 732128 734030 738664 738976 745994 746633 749604 751769 757558 757603 758942 767437 789065 793210 797854 817497 828032 828135 828137 828139 828140 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cock на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cock public"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cock на улиц"
]
|
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.