Query Metrics
7
Database Queries
7
Different statements
353.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.53 ms (59.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy рак"
]
|
||||||||||||||||||||||||||||||
|
117.83 ms (33.32%) |
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 118359 223663 262435 378272 391577 393868 395249 395459 397605 398815 411125 411515 416428 421388 425281 435521 442405 447094 448171 466471 482182 485855 489207 490503 495003 495106 501434 503787 506460 514362 514975 516493 516534 526949 528800 534430 541203 552038 556084 556142 556704 556743 559733 560276 561282 562622 563284 565638 583009 583176 584465 585145 598990 604545 606923 615409 617112 619752 626996 628744 635402 636504 641890 644447 647784 657804 663841 672844 673254 675183 679908 698154 698765 702038 718826 720103 721230 723726 726325 729013 731173 733259 739346 740070 742758 745243 746293 748063 749621 758780 762360 766918 768962 769099 771128 771898 776179 778475 778574 778841 779527 780977 781021 781502 783563 783995 787403 790912 791478 795316 795948 796466 796480 800906 802147 805412 809813 809869 817107 ] |
||||||||||||||||||||||||||||||
|
16.17 ms (4.57%) |
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 528800 817107 673254 647784 698765 561282 628744 617112 776179 778574 781502 809869 762360 771128 771898 739346 495106 560276 720103 636504 606923 805412 723726 745243 749621 398815 416428 740070 482182 718826 635402 796480 733259 644447 395249 391577 534430 565638 583009 541203 657804 721230 552038 562622 641890 795948 790912 768962 731173 742758 795316 262435 393868 421388 556743 663841 672844 556084 563284 615409 626996 598990 778475 780977 781021 783995 779527 746293 802147 748063 726325 787403 809813 411125 425281 447094 584465 556704 619752 604545 526949 489207 490503 514975 516534 516493 823879 397605 448171 503787 506460 559733 583176 556142 675183 702038 585145 758780 698154 778841 800906 411515 442405 466471 118359 395459 435521 485855 495003 501434 378272 514362 679908 783563 796466 769099 729013 766918 791478 223663 ] |
||||||||||||||||||||||||||||||
|
3.62 ms (1.02%) |
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 118359 223663 262435 378272 391577 393868 395249 395459 397605 398815 411125 411515 416428 421388 425281 435521 442405 447094 448171 466471 482182 485855 489207 490503 495003 495106 501434 503787 506460 514362 514975 516493 516534 526949 528800 534430 541203 552038 556084 556142 556704 556743 559733 560276 561282 562622 563284 565638 583009 583176 584465 585145 598990 604545 606923 615409 617112 619752 626996 628744 635402 636504 641890 644447 647784 657804 663841 672844 673254 675183 679908 698154 698765 702038 718826 720103 721230 723726 726325 729013 731173 733259 739346 740070 742758 745243 746293 748063 749621 758780 762360 766918 768962 769099 771128 771898 776179 778475 778574 778841 779527 780977 781021 781502 783563 783995 787403 790912 791478 795316 795948 796466 796480 800906 802147 805412 809813 809869 817107 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy doggy"
]
|
||||||||||||||||||||||||||||||
|
2.23 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy рак"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.55%) |
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.