Query Metrics
7
Database Queries
7
Different statements
187.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.97 ms (86.75%) |
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 3691 270135 386178 391077 391808 396586 396623 398160 407429 411419 416936 417509 417520 418575 421074 421201 422299 428016 431761 435064 443262 443862 446731 447079 447553 447721 448396 451711 452181 452666 453001 455738 456124 462250 467979 471182 471414 471772 474992 483087 491468 492444 493050 494349 501909 503413 504347 514414 515106 516013 518901 523186 527349 527576 527794 528164 535578 542078 542091 549707 560554 564717 565972 566539 567216 567402 569103 575200 576293 577897 586791 590955 593136 595479 595820 599040 602766 609617 614675 616992 621719 644945 650134 678571 681855 706558 712632 713931 716144 717167 719638 721867 721913 728857 739699 740157 753365 754253 757085 761272 766811 770359 775167 781279 783630 788840 792765 793622 793835 794578 802091 808231 811254 811594 818738 820761 822103 822912 827108 ] |
||||||||||||||||||||||||||||||
|
15.22 ms (8.10%) |
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 518901 492444 542091 728857 417509 644945 614675 740157 431761 451711 447079 503413 575200 766811 560554 542078 650134 590955 739699 516013 599040 483087 595820 586791 456124 447721 706558 567216 448396 602766 3691 716144 781279 793622 493050 808231 396623 386178 422299 428016 721867 549707 793835 418575 447553 471182 775167 593136 577897 504347 535578 435064 491468 421074 443862 494349 811254 391077 753365 523186 576293 396586 818738 681855 712632 595479 783630 757085 566539 527794 391808 453001 514414 455738 452181 792765 398160 754253 822103 822912 621719 811594 794578 769266 761272 270135 452666 467979 471772 474992 528164 462250 565972 515106 471414 569103 719638 411419 501909 446731 678571 417520 567402 717167 616992 609617 802091 527349 721913 527576 564717 770359 443262 827108 407429 713931 421201 416936 788840 820761 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.25%) |
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 3691 270135 386178 391077 391808 396586 396623 398160 407429 411419 416936 417509 417520 418575 421074 421201 422299 428016 431761 435064 443262 443862 446731 447079 447553 447721 448396 451711 452181 452666 453001 455738 456124 462250 467979 471182 471414 471772 474992 483087 491468 492444 493050 494349 501909 503413 504347 514414 515106 516013 518901 523186 527349 527576 527794 528164 535578 542078 542091 549707 560554 564717 565972 566539 567216 567402 569103 575200 576293 577897 586791 590955 593136 595479 595820 599040 602766 609617 614675 616992 621719 644945 650134 678571 681855 706558 712632 713931 716144 717167 719638 721867 721913 728857 739699 740157 753365 754253 757085 761272 766811 770359 775167 781279 783630 788840 792765 793622 793835 794578 802091 808231 811254 811594 818738 820761 822103 822912 827108 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bathroom blowjob sperm"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван минет оральн секс сперм"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.84%) |
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.