Query Metrics
7
Database Queries
7
Different statements
263.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
240.95 ms (91.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 31503 117883 118173 346211 373995 383576 385662 387450 389144 391940 396120 419045 422676 428195 439028 440094 441102 441841 443095 459375 460285 460941 466737 480457 490649 495750 495765 500687 503379 504571 505382 505649 507243 508177 510731 510825 512074 512365 514222 514848 514852 514863 514868 519374 520767 525351 528939 531836 531849 534564 535261 536453 540593 540915 541064 542705 545225 569592 573207 573977 575636 580190 580216 583460 583518 583689 585644 590262 599477 600508 609198 616146 618238 618257 618267 622318 627461 627466 628708 629725 632302 638998 639371 643181 645673 656938 666861 666905 669030 669034 670354 672937 679574 696595 713153 722389 734839 735743 740624 740699 744412 749204 752611 752621 752638 752752 768219 784298 788185 789328 792691 792708 792727 796857 796859 796878 799699 801621 809351 810820 ] |
||||||||||||||||||||||||||||||
|
12.41 ms (4.71%) |
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 645673 670354 722389 585644 618257 629725 792691 740699 752638 784298 796857 801621 810820 752611 752621 616146 713153 789328 792727 346211 117883 441102 441841 443095 490649 510825 512365 510731 514852 495750 512074 534564 503379 505649 508177 514848 580216 569592 609198 590262 628708 599477 627466 632302 460941 466737 387450 391940 422676 428195 439028 440094 505382 514863 459375 528939 385662 383576 118173 31503 540593 514222 531836 531849 575636 545225 583460 541064 669034 679574 656938 666861 666905 672937 696595 573977 600508 618238 638998 627461 639371 643181 622318 796859 788185 792708 796878 734839 744412 752752 768219 799699 809351 735743 749204 740624 618267 373995 396120 520767 580190 389144 419045 460285 480457 495765 500687 504571 525351 507243 514868 519374 535261 536453 573207 583518 583689 540915 542705 669030 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.19%) |
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 31503 117883 118173 346211 373995 383576 385662 387450 389144 391940 396120 419045 422676 428195 439028 440094 441102 441841 443095 459375 460285 460941 466737 480457 490649 495750 495765 500687 503379 504571 505382 505649 507243 508177 510731 510825 512074 512365 514222 514848 514852 514863 514868 519374 520767 525351 528939 531836 531849 534564 535261 536453 540593 540915 541064 542705 545225 569592 573207 573977 575636 580190 580216 583460 583518 583689 585644 590262 599477 600508 609198 616146 618238 618257 618267 622318 627461 627466 628708 629725 632302 638998 639371 643181 645673 656938 666861 666905 669030 669034 670354 672937 679574 696595 713153 722389 734839 735743 740624 740699 744412 749204 752611 752621 752638 752752 768219 784298 788185 789328 792691 792708 792727 796857 796859 796878 799699 801621 809351 810820 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"фистит"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фистинг"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.70%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.58%) |
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.