Query Metrics
7
Database Queries
7
Different statements
387.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.43 ms (53.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бюстгалтер нижн бел минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
153.63 ms (39.65%) |
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 233889 391392 391530 396101 396778 399659 406062 409995 410094 413049 420807 423979 425996 434793 435104 437924 441500 443801 445112 445617 449190 451239 452229 454992 455041 456829 457881 460063 460082 460592 461631 461936 462694 463169 463673 464961 466851 469453 470283 471956 472597 473944 475129 475483 476341 477961 481267 482525 483323 483951 484421 484931 488549 489529 490138 490183 490195 490324 495182 496528 497401 497837 497961 498212 502278 502420 503361 504572 505834 508069 509037 510528 512085 512880 513141 513936 514152 515816 517128 518176 519297 520718 520916 524013 525499 526801 529450 536861 545723 545828 547427 548232 548705 554787 555133 557512 560366 560986 561071 561821 565188 565402 572889 574804 574841 576072 581069 582384 583280 584337 584991 601910 603672 604247 606016 616971 619843 620086 626091 661528 ] |
||||||||||||||||||||||||||||||
|
17.47 ms (4.51%) |
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 584991 554787 464961 483951 445112 463169 443801 495182 561821 525499 457881 496528 473944 481267 497961 574804 555133 391392 584337 560366 565402 396101 508069 484931 512880 470283 472597 620086 449190 460063 572889 548705 477961 434793 517128 498212 396778 399659 425996 461631 490183 560986 576072 548232 601910 413049 420807 526801 505834 435104 441500 461936 475129 514152 536861 513936 509037 233889 452229 557512 582384 583280 437924 490195 466851 476341 510528 515816 519297 513141 409995 410094 616971 503361 391530 619843 460082 502420 463673 423979 451239 565188 520916 475483 471956 462694 661528 626091 561071 484421 604247 469453 524013 490324 455041 518176 497837 482525 606016 504572 489529 497401 512085 574841 445617 547427 581069 456829 488549 490138 529450 545828 603672 460592 454992 483323 406062 502278 545723 520718 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (0.73%) |
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 233889 391392 391530 396101 396778 399659 406062 409995 410094 413049 420807 423979 425996 434793 435104 437924 441500 443801 445112 445617 449190 451239 452229 454992 455041 456829 457881 460063 460082 460592 461631 461936 462694 463169 463673 464961 466851 469453 470283 471956 472597 473944 475129 475483 476341 477961 481267 482525 483323 483951 484421 484931 488549 489529 490138 490183 490195 490324 495182 496528 497401 497837 497961 498212 502278 502420 503361 504572 505834 508069 509037 510528 512085 512880 513141 513936 514152 515816 517128 518176 519297 520718 520916 524013 525499 526801 529450 536861 545723 545828 547427 548232 548705 554787 555133 557512 560366 560986 561071 561821 565188 565402 572889 574804 574841 576072 581069 582384 583280 584337 584991 601910 603672 604247 606016 616971 619843 620086 626091 661528 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (0.54%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.54%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бюстгалтер нижн бел минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bra blowjob"
]
|
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.