Query Metrics
7
Database Queries
7
Different statements
187.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.74 ms (86.93%) |
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 75664 76268 152276 184985 185011 185208 185212 185428 185464 185606 185708 185834 185861 319841 323129 357806 357886 379578 382696 384986 385096 386071 387006 387487 389135 389142 389304 390200 390219 390592 390698 390908 391064 391677 400435 401492 402601 402604 402605 404032 406235 408060 408085 408172 412222 413300 415934 424571 426894 427925 447493 448652 486924 494578 501718 501720 501750 506960 511294 514568 523971 525251 555944 562881 563715 569827 572018 583633 592054 592364 608606 610365 623950 623958 624285 653261 654385 671703 676927 676929 679702 684572 685612 687138 689591 689846 691358 700805 714404 722810 732379 735684 738907 740235 744460 744469 744631 758812 758980 759782 765482 779532 794425 797499 800069 800114 800127 800268 800324 801243 801905 807806 815790 817486 818326 818362 824332 825002 825204 ] |
||||||||||||||||||||||||||||||
|
15.64 ms (8.36%) |
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 676929 685612 687138 623950 758812 779532 387487 408060 387006 426894 758980 447493 817486 402604 185208 389304 486924 506960 689846 654385 800324 735684 800114 807806 390219 185212 390698 653261 592054 759782 765482 427925 323129 406235 75664 391677 525251 824332 825204 801243 801905 379578 386071 185011 583633 700805 714404 608606 610365 744460 744469 744631 185708 448652 412222 501720 185834 357806 389135 400435 514568 679702 592364 623958 357886 424571 404032 825002 815790 800127 390200 185428 389142 408172 684572 691358 624285 797499 732379 800069 385096 384986 390592 494578 382696 402605 818326 722810 800268 740235 738907 738923 794425 390908 76268 563715 671703 689591 555944 562881 572018 391064 402601 152276 401492 415934 501750 523971 818362 184985 408085 569827 185464 501718 511294 676927 413300 185606 185861 319841 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.33%) |
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 75664 76268 152276 184985 185011 185208 185212 185428 185464 185606 185708 185834 185861 319841 323129 357806 357886 379578 382696 384986 385096 386071 387006 387487 389135 389142 389304 390200 390219 390592 390698 390908 391064 391677 400435 401492 402601 402604 402605 404032 406235 408060 408085 408172 412222 413300 415934 424571 426894 427925 447493 448652 486924 494578 501718 501720 501750 506960 511294 514568 523971 525251 555944 562881 563715 569827 572018 583633 592054 592364 608606 610365 623950 623958 624285 653261 654385 671703 676927 676929 679702 684572 685612 687138 689591 689846 691358 700805 714404 722810 732379 735684 738907 740235 744460 744469 744631 758812 758980 759782 765482 779532 794425 797499 800069 800114 800127 800268 800324 801243 801905 807806 815790 817486 818326 818362 824332 825002 825204 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy massage"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy массаж"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy массаж"
]
|
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.