Query Metrics
7
Database Queries
7
Different statements
162.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.88 ms (85.95%) |
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 387270 415233 426816 426940 427702 439112 445135 445277 457874 461371 461547 461564 465140 468828 469154 472175 476240 476592 477813 487878 494086 494688 499188 499382 502217 503987 505889 507156 510339 511927 513223 513459 516644 520292 520319 521084 521580 522431 523367 525126 525674 526165 535420 538977 540846 543484 543781 544205 544483 546654 549081 549250 550485 552099 552134 555752 557536 557786 561026 562884 564258 570468 572266 572738 573376 573499 575542 578190 581793 583664 584882 589741 590498 590771 591340 592355 593004 593618 595477 600501 602181 602708 605858 606819 610728 611322 612771 614435 617045 619917 620331 621443 622830 623330 624471 626236 626870 628285 628343 633829 634224 651879 654363 654369 654459 654791 656407 657221 659302 660310 662083 662113 663982 668559 677356 682902 684060 684298 689084 ] |
||||||||||||||||||||||||||||||
|
12.95 ms (7.96%) |
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 461371 476592 521580 535420 521084 476240 543484 575542 583664 543781 544483 555752 557786 578190 656407 659302 689084 654369 572738 584882 591340 602181 593004 619917 592355 602708 617045 623330 626236 605858 614435 426940 439112 465140 469154 546654 561026 520319 581793 611322 387270 445277 426816 540846 668559 557536 487878 468828 494086 499382 503987 511927 513459 499188 516644 522431 523367 525126 494688 502217 505889 507156 520292 526165 538977 510339 513223 549250 572266 573499 544205 570468 549081 550485 573376 651879 654791 657221 662113 682902 684298 654363 654459 662083 677356 684060 660310 663982 552099 552134 562884 564258 590771 595477 628285 624471 589741 590498 600501 606819 610728 612771 620331 628343 634224 593618 621443 626870 622830 633829 445135 472175 427702 457874 461547 461564 525674 662221 477813 415233 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.81%) |
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 387270 415233 426816 426940 427702 439112 445135 445277 457874 461371 461547 461564 465140 468828 469154 472175 476240 476592 477813 487878 494086 494688 499188 499382 502217 503987 505889 507156 510339 511927 513223 513459 516644 520292 520319 521084 521580 522431 523367 525126 525674 526165 535420 538977 540846 543484 543781 544205 544483 546654 549081 549250 550485 552099 552134 555752 557536 557786 561026 562884 564258 570468 572266 572738 573376 573499 575542 578190 581793 583664 584882 589741 590498 590771 591340 592355 593004 593618 595477 600501 602181 602708 605858 606819 610728 611322 612771 614435 617045 619917 620331 621443 622830 623330 624471 626236 626870 628285 628343 633829 634224 651879 654363 654369 654459 654791 656407 657221 659302 660310 662083 662113 663982 668559 677356 682902 684060 684298 689084 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"лёжа на боку"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"леж на бок"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.