Query Metrics
7
Database Queries
7
Different statements
151.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.12 ms (82.52%) |
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 387021 396266 398126 401449 413083 414021 414893 415708 416296 419196 421207 424675 444570 445492 446179 447926 451795 454991 457062 458119 458201 458935 460262 460459 465970 468703 469276 471784 471861 472162 473060 479197 481499 485462 486005 487928 492005 493493 494779 497703 498440 501203 501704 501958 502136 508562 508563 511319 511328 513975 514037 514638 516298 516793 517282 521979 521984 523066 524248 525213 527399 527457 528110 528570 533195 536890 540073 542535 545605 550608 552994 555387 555413 558572 559989 560453 565418 566900 567399 570691 573751 575189 576003 576114 578420 578790 581896 582114 583614 584563 585159 588878 592596 596479 602515 606626 607525 611313 618359 622366 622650 637247 647026 648220 649578 677964 688188 696500 720437 721203 742834 744994 756227 761585 785386 794247 794800 795807 803208 811497 ] |
||||||||||||||||||||||||||||||
|
15.96 ms (10.53%) |
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 458119 473060 536890 513975 527399 502136 514037 540073 527457 533195 460459 469276 471784 555413 576003 581896 584563 542535 578420 552994 555387 566900 647026 677964 696500 721203 688188 720437 567399 588878 606626 637247 592596 596479 602515 585159 794247 794800 795807 803208 761585 785386 756227 742834 744994 611313 622366 622650 387021 413083 414021 416296 419196 445492 465970 398126 458201 472162 446179 479197 457062 508562 516793 508563 521979 521984 523066 524248 528110 525213 528570 498440 516298 573751 559989 607525 545605 618359 514638 421207 424675 485462 471861 447926 501958 558572 648220 649578 811497 494779 396266 401449 415708 444570 414893 458935 451795 481499 492005 454991 468703 487928 493493 511319 511328 497703 501704 517282 501203 460262 486005 582114 550608 575189 576114 583614 560453 565418 570691 578790 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.79%) |
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 387021 396266 398126 401449 413083 414021 414893 415708 416296 419196 421207 424675 444570 445492 446179 447926 451795 454991 457062 458119 458201 458935 460262 460459 465970 468703 469276 471784 471861 472162 473060 479197 481499 485462 486005 487928 492005 493493 494779 497703 498440 501203 501704 501958 502136 508562 508563 511319 511328 513975 514037 514638 516298 516793 517282 521979 521984 523066 524248 525213 527399 527457 528110 528570 533195 536890 540073 542535 545605 550608 552994 555387 555413 558572 559989 560453 565418 566900 567399 570691 573751 575189 576003 576114 578420 578790 581896 582114 583614 584563 585159 588878 592596 596479 602515 606626 607525 611313 618359 622366 622650 637247 647026 648220 649578 677964 688188 696500 720437 721203 742834 744994 756227 761585 785386 794247 794800 795807 803208 811497 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"creampie lick pussy"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"creampie лиза pussy"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"creampie лиза pussy"
]
|
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.