Query Metrics
7
Database Queries
7
Different statements
213.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.73 ms (81.09%) |
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 188669 232940 381752 390929 442652 445668 450172 452385 452638 462101 463066 463825 465147 465299 465317 465337 466135 466982 466989 466997 467039 469453 470762 471890 472645 474139 474629 474874 475080 475683 476856 478672 480290 480757 482304 482357 482367 483355 484656 485374 486530 488370 489831 491022 493197 500458 502467 502806 502808 502921 504386 504481 506801 507659 510599 511607 511664 511916 515086 515723 515724 516744 517048 517067 517073 518774 519140 519151 521448 522594 524882 525480 525484 525511 526212 527947 527953 529312 529341 529390 541570 549225 549233 550307 550647 559062 559569 559579 561576 563422 564292 565677 567491 572347 573335 574384 580340 580667 589597 598649 598653 601904 602668 603224 607132 617722 663420 668943 672954 678778 678782 678791 678804 812320 ] |
||||||||||||||||||||||||||||||
|
29.86 ms (14.02%) |
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 442652 450172 471890 472645 475080 482357 488370 463825 465147 467039 493197 525480 510599 518774 465337 466997 475683 559579 672954 663420 668943 565677 567491 617722 607132 812320 474629 390929 188669 466135 511664 519140 519151 529341 502467 502806 502921 511607 485374 507659 527953 466989 517048 549233 601904 517067 445668 452385 465299 486530 500458 525484 529312 515724 527947 515086 522594 482367 541570 550647 572347 559569 678791 550307 589597 602668 470762 474874 511916 502808 521448 474139 574384 580340 491022 452638 482304 517073 526212 573335 563422 564292 678778 678782 465317 463066 469453 466982 504481 504386 678804 598653 462101 476856 381752 480757 484656 516744 232940 480290 603224 524882 598649 559062 483355 506801 580667 515723 525511 489831 529390 561576 549225 478672 ] |
||||||||||||||||||||||||||||||
|
3.61 ms (1.69%) |
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 188669 232940 381752 390929 442652 445668 450172 452385 452638 462101 463066 463825 465147 465299 465317 465337 466135 466982 466989 466997 467039 469453 470762 471890 472645 474139 474629 474874 475080 475683 476856 478672 480290 480757 482304 482357 482367 483355 484656 485374 486530 488370 489831 491022 493197 500458 502467 502806 502808 502921 504386 504481 506801 507659 510599 511607 511664 511916 515086 515723 515724 516744 517048 517067 517073 518774 519140 519151 521448 522594 524882 525480 525484 525511 526212 527947 527953 529312 529341 529390 541570 549225 549233 550307 550647 559062 559569 559579 561576 563422 564292 565677 567491 572347 573335 574384 580340 580667 589597 598649 598653 601904 602668 603224 607132 617722 663420 668943 672954 678778 678782 678791 678804 812320 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"granny чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"granny in stockings"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"granny чулк нижн бел"
]
|
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.