Query Metrics
7
Database Queries
7
Different statements
229.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.01 ms (90.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 3561 8900 23003 382066 390754 395285 398376 399201 405761 411046 412078 412525 418458 424404 425508 426051 426696 426886 429020 432884 438051 441041 442100 452205 460335 463509 464270 464788 465583 465918 480788 488923 495376 497792 499013 504348 508152 509936 514250 517035 523176 528223 528370 529189 530980 545236 550797 553166 554180 555808 558261 559580 567313 577521 580136 580817 581428 582654 583519 584032 584922 585849 588125 589916 589933 593195 594820 596309 599500 599998 600936 602221 604815 606594 610308 624128 624907 627961 629309 629462 640143 658931 660811 664191 666485 668760 671204 677250 678758 682829 688922 689252 703650 712366 713948 736002 736045 740258 742696 748495 752619 754759 762215 767718 772483 772683 781255 784320 784892 788317 793011 800139 803915 804140 804430 811816 813729 813737 814466 828472 ] |
||||||||||||||||||||||||||||||
|
13.06 ms (5.70%) |
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 582654 629462 399201 658931 660811 624907 828472 666485 784320 514250 580136 426696 567313 426886 488923 504348 523176 813729 530980 689252 800139 748495 629309 23003 804140 742696 803915 412078 425508 442100 602221 553166 555808 703650 588125 464270 398376 3561 584922 762215 781255 668760 736002 736045 712366 594820 411046 688922 464788 465918 452205 559580 460335 581428 418458 813737 713948 589916 589933 784892 772683 390754 497792 678758 583519 627961 804430 788317 767718 754759 499013 438051 508152 529189 395285 382066 8900 405761 606594 752619 793011 811816 429020 432884 463509 580817 577521 600936 593195 495376 596309 599500 426051 558261 604815 772483 441041 528223 480788 412525 610308 554180 740258 509936 585849 599998 624128 424404 465583 528370 640143 814466 517035 545236 584032 682829 671204 677250 664191 550797 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (0.99%) |
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 3561 8900 23003 382066 390754 395285 398376 399201 405761 411046 412078 412525 418458 424404 425508 426051 426696 426886 429020 432884 438051 441041 442100 452205 460335 463509 464270 464788 465583 465918 480788 488923 495376 497792 499013 504348 508152 509936 514250 517035 523176 528223 528370 529189 530980 545236 550797 553166 554180 555808 558261 559580 567313 577521 580136 580817 581428 582654 583519 584032 584922 585849 588125 589916 589933 593195 594820 596309 599500 599998 600936 602221 604815 606594 610308 624128 624907 627961 629309 629462 640143 658931 660811 664191 666485 668760 671204 677250 678758 682829 688922 689252 703650 712366 713948 736002 736045 740258 742696 748495 752619 754759 762215 767718 772483 772683 781255 784320 784892 788317 793011 800139 803915 804140 804430 811816 813729 813737 814466 828472 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl masturbation bathroom"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк мастурбац ван"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.