Query Metrics
7
Database Queries
7
Different statements
164.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.61 ms (83.57%) |
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 35344 96109 382313 384998 385257 385344 385376 386867 386874 389243 390502 395679 395702 396650 396665 396707 399824 400196 400638 401140 404615 404800 405061 405074 406289 407444 408262 408293 414133 416165 416864 420561 421118 422619 423267 424505 425336 428479 430479 431015 433477 433656 434492 435443 442398 443138 443558 443819 446148 449435 452061 452080 452838 457165 465976 472488 473491 474553 479021 481877 486179 486516 486531 486594 486963 488904 492519 507686 508698 510592 512192 513781 513947 516221 519093 523712 524560 533182 538190 541368 541725 544485 557336 560462 561131 565539 586628 590695 592500 598185 603509 604555 604984 606681 616336 620130 620160 633132 635949 667288 670717 673537 682129 682489 683870 689610 690831 690902 699053 720245 805789 807936 812795 814861 814883 814892 815204 816553 816958 822692 ] |
||||||||||||||||||||||||||||||
|
17.78 ms (10.80%) |
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 592500 633132 544485 682129 699053 598185 96109 816958 604984 421118 488904 434492 457165 443819 805789 433477 486516 565539 620130 519093 435443 561131 407444 474553 452838 404615 486594 395679 420561 35344 389243 396707 404800 422619 465976 682489 557336 635949 395702 396665 513947 385376 400638 816553 486531 516221 507686 673537 689610 683870 620160 590695 385344 430479 822692 814861 481877 670717 690831 401140 513781 814883 479021 492519 541368 807936 508698 512192 533182 667288 812795 510592 433656 425336 405074 442398 408262 486963 452061 486179 616336 604555 399824 416864 814892 452080 449435 446148 560462 524560 424505 472488 416165 400196 382313 406289 443558 603509 386867 405061 586628 385257 386874 390502 473491 523712 690902 606681 396650 408293 414133 423267 431015 538190 384998 428479 443138 815204 541725 720245 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.43%) |
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 35344 96109 382313 384998 385257 385344 385376 386867 386874 389243 390502 395679 395702 396650 396665 396707 399824 400196 400638 401140 404615 404800 405061 405074 406289 407444 408262 408293 414133 416165 416864 420561 421118 422619 423267 424505 425336 428479 430479 431015 433477 433656 434492 435443 442398 443138 443558 443819 446148 449435 452061 452080 452838 457165 465976 472488 473491 474553 479021 481877 486179 486516 486531 486594 486963 488904 492519 507686 508698 510592 512192 513781 513947 516221 519093 523712 524560 533182 538190 541368 541725 544485 557336 560462 561131 565539 586628 590695 592500 598185 603509 604555 604984 606681 616336 620130 620160 633132 635949 667288 670717 673537 682129 682489 683870 689610 690831 690902 699053 720245 805789 807936 812795 814861 814883 814892 815204 816553 816958 822692 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette hairy threesome"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая волосатая секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.95%) |
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.