Query Metrics
7
Database Queries
7
Different statements
205.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.91 ms (85.01%) |
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 172191 387516 457375 477578 488563 494759 495799 508231 538582 539586 542270 542273 542302 542331 542338 543038 543102 543106 543176 543178 543200 543211 543258 543273 543283 543486 544002 544337 544626 544706 544707 547684 549154 550691 553828 554113 554117 556944 561620 565967 567036 568049 575008 575022 575363 575409 576869 580115 582736 584640 612245 618749 621532 622916 623633 625027 628634 633440 636430 639850 640483 649548 651230 655880 660455 660573 663187 664452 669240 676155 681458 682977 685097 687512 688299 701811 702154 705247 705882 706602 710356 713085 717617 718153 727458 728238 732144 734346 736642 737138 738450 738571 748055 750266 752104 752518 765502 767076 775126 785339 789515 789714 795847 796066 796732 797109 797143 797889 797982 804401 810569 811536 813832 817513 818709 818722 825404 825952 826282 828798 ] |
||||||||||||||||||||||||||||||
|
21.06 ms (10.23%) |
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 544626 575008 575409 542273 543178 543200 543211 543273 543283 543486 544706 544707 554113 565967 568049 575363 542270 543102 543258 553828 556944 575022 660455 660573 685097 649548 655880 663187 669240 676155 705247 706602 710356 717617 718153 651230 664452 681458 682977 687512 688299 702154 554117 561620 576869 625027 640483 612245 621532 636430 639850 618749 622916 628634 623633 775126 795847 810569 796066 797982 734346 748055 789515 789714 796732 797109 797143 797889 804401 728238 738450 765502 727458 738571 750266 752104 752518 767076 732144 736642 737138 633440 701811 705882 713085 785339 811536 172191 387516 813832 818722 817513 826282 825404 825952 818709 828798 457375 477578 488563 495799 494759 538582 539586 508231 542302 542338 544002 549154 550691 582736 584640 542331 543176 544337 547684 567036 580115 543038 543106 ] |
||||||||||||||||||||||||||||||
|
3.43 ms (1.67%) |
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 172191 387516 457375 477578 488563 494759 495799 508231 538582 539586 542270 542273 542302 542331 542338 543038 543102 543106 543176 543178 543200 543211 543258 543273 543283 543486 544002 544337 544626 544706 544707 547684 549154 550691 553828 554113 554117 556944 561620 565967 567036 568049 575008 575022 575363 575409 576869 580115 582736 584640 612245 618749 621532 622916 623633 625027 628634 633440 636430 639850 640483 649548 651230 655880 660455 660573 663187 664452 669240 676155 681458 682977 685097 687512 688299 701811 702154 705247 705882 706602 710356 713085 717617 718153 727458 728238 732144 734346 736642 737138 738450 738571 748055 750266 752104 752518 765502 767076 775126 785339 789515 789714 795847 796066 796732 797109 797143 797889 797982 804401 810569 811536 813832 817513 818709 818722 825404 825952 826282 828798 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ххх арабк"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ххх араб"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ххх арабк"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.73%) |
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.