Query Metrics
7
Database Queries
7
Different statements
342.26 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.71 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 205.62 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur pov threesome"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.28 ms |
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 785956 421839 424329 423375 508441 486229 509345 514640 435728 791712 530507 573389 603854 576256 787379 525688 560189 608376 422044 513604 625675 420635 504927 515633 514997 442363 430635 436820 825500 548870 483788 634474 607919 544972 484924 551129 819710 565658 543389 590667 527656 614921 461602 503167 528618 553070 632304 527967 522357 448993 559722 622668 776235 521815 546106 648945 508454 595977 414618 768739 812465 807449 590723 800781 506467 442281 785727 650621 785628 779074 478637 707464 565858 476563 570837 544794 524234 776153 502649 475207 489542 515374 808963 553935 552458 571334 520954 529485 ] |
||||||||||||||||||||||||||||||
| 4 | 3.74 ms |
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 414618 420635 421839 422044 423375 424329 430635 435728 436820 442281 442363 448993 461602 475207 476563 478637 483788 484924 486229 489542 502649 503167 504927 506467 508441 508454 509345 513604 514640 514997 515374 515633 520954 521815 522357 524234 525688 527656 527967 528618 529485 530507 543389 544794 544972 546106 548870 551129 552458 553070 553935 559722 560189 565658 565858 570837 571334 573389 576256 590667 590723 595977 603854 607919 608376 614921 622668 625675 632304 634474 648945 650621 707464 768739 776153 776235 779074 785628 785727 785956 787379 791712 800781 807449 808963 812465 819710 825500 ] |
||||||||||||||||||||||||||||||
| 5 | 111.62 ms |
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 414618 420635 421839 422044 423375 424329 430635 435728 436820 442281 442363 448993 461602 475207 476563 478637 483788 484924 486229 489542 502649 503167 504927 506467 508441 508454 509345 513604 514640 514997 515374 515633 520954 521815 522357 524234 525688 527656 527967 528618 529485 530507 543389 544794 544972 546106 548870 551129 552458 553070 553935 559722 560189 565658 565858 570837 571334 573389 576256 590667 590723 595977 603854 607919 608376 614921 622668 625675 632304 634474 648945 650621 707464 768739 776153 776235 779074 785628 785727 785956 787379 791712 800781 807449 808963 812465 819710 825500 ] |
||||||||||||||||||||||||||||||
| 6 | 1.68 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск пов секс втро"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.61 ms |
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.