Query Metrics
7
Database Queries
7
Different statements
173.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.15 ms (84.84%) |
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 365295 395724 402122 402882 431691 444474 446311 447352 471623 471707 473309 482249 485066 490801 491934 502300 513765 518504 522168 526649 536706 542344 543446 545292 556825 558814 559037 560510 565140 571195 572841 574277 579769 582213 585290 586351 589951 596816 596907 597604 600671 601020 601034 623879 640097 644953 660422 682144 716215 721692 725199 727391 728238 733357 738736 753019 784244 787341 797143 797500 801337 802700 802748 804196 805439 806088 809368 810926 811214 812797 812821 813269 813529 813672 813782 814249 814344 814414 814895 815068 815223 815254 815420 815496 815698 815777 815910 816020 816853 816880 817859 817942 817945 818213 818865 819175 820052 820060 820072 820717 820744 821032 821059 821210 821268 821283 821377 821450 821689 821726 822421 822424 823037 823243 823252 823377 823522 824953 825091 828648 ] |
||||||||||||||||||||||||||||||
|
15.76 ms (9.08%) |
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 545292 558814 572841 660422 601034 596816 600671 623879 805439 809368 810926 812797 812821 784244 402122 447352 518504 365295 814344 815420 817942 818865 823037 823243 644953 814414 817945 813782 815223 816020 819175 821283 822421 825091 815910 821032 821689 490801 543446 716215 586351 585290 597604 601020 797500 802748 804196 806088 811214 802700 725199 753019 787341 797143 813529 728238 727391 733357 738736 801337 813269 485066 395724 820072 822424 482249 473309 560510 559037 565140 589951 596907 402882 471623 471707 526649 491934 502300 513765 446311 431691 522168 444474 813672 821059 814249 815698 818213 821210 821268 821377 815254 815496 816880 817859 820052 821726 823252 823522 824953 814895 815068 815777 816853 820060 820717 820744 821450 823377 828648 536706 574277 542344 579769 682144 721692 556825 571195 582213 640097 ] |
||||||||||||||||||||||||||||||
|
3.30 ms (1.90%) |
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 365295 395724 402122 402882 431691 444474 446311 447352 471623 471707 473309 482249 485066 490801 491934 502300 513765 518504 522168 526649 536706 542344 543446 545292 556825 558814 559037 560510 565140 571195 572841 574277 579769 582213 585290 586351 589951 596816 596907 597604 600671 601020 601034 623879 640097 644953 660422 682144 716215 721692 725199 727391 728238 733357 738736 753019 784244 787341 797143 797500 801337 802700 802748 804196 805439 806088 809368 810926 811214 812797 812821 813269 813529 813672 813782 814249 814344 814414 814895 815068 815223 815254 815420 815496 815698 815777 815910 816020 816853 816880 817859 817942 817945 818213 818865 819175 820052 820060 820072 820717 820744 821032 821059 821210 821268 821283 821377 821450 821689 821726 822421 822424 823037 823243 823252 823377 823522 824953 825091 828648 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom латинская"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom латинская"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom latina"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.