Query Metrics
7
Database Queries
7
Different statements
275.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
252.86 ms (91.66%) |
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 446573 497336 498254 498442 543468 556459 556563 558461 563759 571382 582841 584274 610489 613383 614280 616395 616535 617679 618336 628183 631058 636155 641358 646610 654647 662443 682413 690541 692562 693333 701545 707521 711102 714785 722148 722313 722337 723897 724320 727060 735158 737290 738509 741681 747665 749937 751907 760361 761996 763342 764325 765797 767324 769624 770693 771429 771714 771752 773509 773689 775289 777210 777214 777726 778338 778341 778468 778534 778939 779182 779296 780022 780112 780288 782385 783547 784115 785243 786067 786620 788965 789193 789513 789778 790656 790942 792474 793474 795599 797207 797881 798610 799597 799863 805097 805518 806379 807343 813577 816101 816128 817248 817485 817611 819175 819448 819465 819479 819654 819661 819722 821831 824662 824710 825495 825546 827052 ] |
||||||||||||||||||||||||||||||
|
13.26 ms (4.81%) |
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 763342 771752 793474 797207 782385 798610 571382 707521 701545 662443 777210 749937 767324 806379 723897 760361 763756 765797 777214 780112 790656 819448 778468 779296 497336 556563 563759 556459 498442 582841 813577 821831 825495 817611 819465 819479 711102 690541 722313 614280 618336 777462 789193 792474 775289 778341 778534 789778 797881 805097 770693 773509 785243 786067 751907 727060 738509 764325 761996 735158 737290 771429 773689 777726 778338 784115 799597 722337 610489 790942 769836 799863 741681 779182 807343 498254 558461 631058 805518 446573 780022 795599 788965 584274 780288 786620 789513 724320 747665 769624 771714 778939 783547 816101 816128 819722 817248 819654 827052 817485 819175 819661 824710 825546 824662 543468 693333 714785 682413 692562 646610 654647 722148 616395 616535 628183 636155 617679 613383 641358 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.14%) |
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 446573 497336 498254 498442 543468 556459 556563 558461 563759 571382 582841 584274 610489 613383 614280 616395 616535 617679 618336 628183 631058 636155 641358 646610 654647 662443 682413 690541 692562 693333 701545 707521 711102 714785 722148 722313 722337 723897 724320 727060 735158 737290 738509 741681 747665 749937 751907 760361 761996 763342 764325 765797 767324 769624 770693 771429 771714 771752 773509 773689 775289 777210 777214 777726 778338 778341 778468 778534 778939 779182 779296 780022 780112 780288 782385 783547 784115 785243 786067 786620 788965 789193 789513 789778 790656 790942 792474 793474 795599 797207 797881 798610 799597 799863 805097 805518 806379 807343 813577 816101 816128 817248 817485 817611 819175 819448 819465 819479 819654 819661 819722 821831 824662 824710 825495 825546 827052 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.65%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"онлифанс социальн сет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"only fans blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"онлифанс социальн сет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.54%) |
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.