Query Metrics
7
Database Queries
7
Different statements
367.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.39 ms (57.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"член массаж"
]
|
||||||||||||||||||||||||||||||
|
135.62 ms (36.87%) |
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 185123 185125 185212 185595 205147 322773 357806 386331 387777 389135 389517 389543 390282 390804 406191 406235 406404 406578 408043 408085 408172 413465 413943 437448 447488 456184 456579 461091 464195 481087 487346 507133 507171 511294 521918 531725 545814 549583 551316 551358 551428 560102 560136 568363 569820 572012 575135 575549 578493 584200 593671 600596 604497 607286 610580 620105 623950 625036 626152 628342 628346 630478 633118 636032 648491 651936 651941 653240 653241 653243 653250 654065 654154 661768 662033 662711 662966 662989 672536 676929 676976 677158 677376 679702 687138 697489 699542 703877 705689 711057 716318 722855 723077 724712 726467 735417 743129 744469 746498 747366 748674 749284 759772 760507 765482 772484 773071 773084 792833 795376 797697 799522 799623 800009 800296 804671 810789 811662 811760 814793 ] |
||||||||||||||||||||||||||||||
|
13.16 ms (3.58%) |
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 551358 797697 810789 795376 811662 773071 799623 772484 322773 387777 408172 551428 386331 560102 575135 676976 653240 185595 814793 654065 662711 705689 661768 677158 551316 628342 626152 804671 749284 743129 747366 748674 697489 699542 716318 722855 389517 390282 357806 389135 578493 569820 653250 679702 560136 584200 620105 185125 703877 185123 408085 413465 545814 568363 406578 511294 390804 406191 406404 408043 711057 723077 662033 604497 456184 507171 531725 464195 487346 549583 651936 636032 800296 799522 744469 773084 185212 507133 572012 653243 593671 628346 765482 760507 625036 406235 205147 461091 456579 447488 521918 437448 575549 651941 653241 654154 662966 676929 648491 672536 687138 662989 677376 600596 630478 633118 607286 623950 811760 792833 800009 726467 759772 735417 746498 724712 610580 389543 481087 413943 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (0.70%) |
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 185123 185125 185212 185595 205147 322773 357806 386331 387777 389135 389517 389543 390282 390804 406191 406235 406404 406578 408043 408085 408172 413465 413943 437448 447488 456184 456579 461091 464195 481087 487346 507133 507171 511294 521918 531725 545814 549583 551316 551358 551428 560102 560136 568363 569820 572012 575135 575549 578493 584200 593671 600596 604497 607286 610580 620105 623950 625036 626152 628342 628346 630478 633118 636032 648491 651936 651941 653240 653241 653243 653250 654065 654154 661768 662033 662711 662966 662989 672536 676929 676976 677158 677376 679702 687138 697489 699542 703877 705689 711057 716318 722855 723077 724712 726467 735417 743129 744469 746498 747366 748674 749284 759772 760507 765482 772484 773071 773084 792833 795376 797697 799522 799623 800009 800296 804671 810789 811662 811760 814793 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dick massage"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член массаж"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.43%) |
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.