Query Metrics
7
Database Queries
7
Different statements
191.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.54 ms (85.35%) |
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 13646 191179 193342 385474 388325 406361 407791 409506 419043 439593 451258 457804 462418 464345 465061 465924 467476 467498 468906 470158 470420 470948 471441 471659 473885 474470 474941 476015 478656 479139 480526 481920 482358 482516 482804 487364 491463 491784 492972 493128 494750 496353 498626 500375 502882 503535 504668 505254 506014 508679 508967 511348 511537 511554 511916 512177 513125 513265 515511 515729 516761 516998 517001 517650 518617 521568 523032 523148 523635 523875 524551 525418 525833 526843 526891 527014 527882 530713 531131 531133 532764 533258 533932 535022 535023 537132 541822 543846 548568 550076 554889 555917 559569 560378 565423 565484 573335 574222 577088 597149 597216 598859 600225 600274 600356 607374 619469 623655 637413 638416 641642 648219 700284 711998 717859 781712 799362 804487 814625 826592 ] |
||||||||||||||||||||||||||||||
|
18.47 ms (9.64%) |
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 504668 513125 530713 531133 533932 638416 623655 804487 543846 471441 799362 541822 521568 525833 464345 473885 535022 478656 479139 13646 474941 523032 439593 533258 554889 480526 559569 535023 517650 498626 494750 465061 524551 470158 826592 508967 607374 409506 388325 531131 781712 512177 476015 526891 565423 385474 193342 465924 560378 574222 619469 462418 505254 491784 470420 548568 717859 598859 516761 523875 468906 526843 518617 513265 406361 814625 482804 532764 508679 555917 482516 493128 470948 407791 515511 516998 515729 482358 597149 511554 491463 573335 457804 503535 506014 523635 487364 511916 467476 467498 451258 500375 597216 637413 419043 511348 525418 191179 511537 517001 492972 527014 711998 600225 550076 502882 496353 648219 641642 700284 471659 474470 527882 537132 565484 600274 600356 481920 523148 577088 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.32%) |
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 13646 191179 193342 385474 388325 406361 407791 409506 419043 439593 451258 457804 462418 464345 465061 465924 467476 467498 468906 470158 470420 470948 471441 471659 473885 474470 474941 476015 478656 479139 480526 481920 482358 482516 482804 487364 491463 491784 492972 493128 494750 496353 498626 500375 502882 503535 504668 505254 506014 508679 508967 511348 511537 511554 511916 512177 513125 513265 515511 515729 516761 516998 517001 517650 518617 521568 523032 523148 523635 523875 524551 525418 525833 526843 526891 527014 527882 530713 531131 531133 532764 533258 533932 535022 535023 537132 541822 543846 548568 550076 554889 555917 559569 560378 565423 565484 573335 574222 577088 597149 597216 598859 600225 600274 600356 607374 619469 623655 637413 638416 641642 648219 700284 711998 717859 781712 799362 804487 814625 826592 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature slave blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature доминирован минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature доминирован минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.82%) |
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.