Query Metrics
7
Database Queries
7
Different statements
208.38 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.34 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.50 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asmr sex girl"
]
|
||||||||||||||||||||||||||||||
| 3 | 9.56 ms |
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 696484 622675 500240 584259 625930 772067 762191 788999 636507 452725 731517 568742 696172 510973 587049 568532 475111 633377 662055 740212 587125 456549 498446 601365 495361 564328 456554 823662 595315 818301 826470 787561 505795 757686 434458 825305 787572 505794 762580 765080 496878 612257 752513 765110 792341 468913 445315 601101 450536 395285 481558 798165 797948 765078 449514 452737 572896 799095 486632 797964 765118 765130 485656 457486 499517 762540 708348 797934 437807 484312 633657 765112 501911 517514 500225 498723 518915 455628 483957 605820 459774 459765 480183 616472 472266 514141 489257 498391 489258 ] |
||||||||||||||||||||||||||||||
| 4 | 2.08 ms |
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 395285 434458 437807 445315 449514 450536 452725 452737 455628 456549 456554 457486 459765 459774 468913 472266 475111 480183 481558 483957 484312 485656 486632 489257 489258 495361 496878 498391 498446 498723 499517 500225 500240 501911 505795 510973 514141 517514 518915 564328 568532 568742 572896 584259 587049 587125 595315 601101 601365 605820 612257 616472 622675 625930 633377 633657 636507 662055 696172 696484 708348 731517 740212 752513 757686 762191 762540 762580 765078 765080 765110 765112 765118 765130 772067 787561 788999 792341 797934 797948 797964 798165 799095 818301 823662 825305 826470 ] |
||||||||||||||||||||||||||||||
| 5 | 190.58 ms |
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 395285 434458 437807 445315 449514 450536 452725 452737 455628 456549 456554 457486 459765 459774 468913 472266 475111 480183 481558 483957 484312 485656 486632 489257 489258 495361 496878 498391 498446 498723 499517 500225 500240 501911 505795 510973 514141 517514 518915 564328 568532 568742 572896 584259 587049 587125 595315 601101 601365 605820 612257 616472 622675 625930 633377 633657 636507 662055 696172 696484 708348 731517 740212 752513 757686 762191 762540 762580 765078 765080 765110 765112 765118 765130 772067 787561 788999 792341 797934 797948 797964 798165 799095 818301 823662 825305 826470 ] |
||||||||||||||||||||||||||||||
| 6 | 1.97 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"asmr секс девушк"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.34 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"asmr секс девушк"
]
|
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.