Query Metrics
7
Database Queries
7
Different statements
241.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.82 ms (87.55%) |
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 397508 400581 418594 422176 435502 439551 449904 450847 451652 452663 453710 453725 455875 455943 457192 459412 469604 482070 484066 484498 485064 489073 490763 493249 493316 493851 495140 496169 496553 496667 496853 497935 498766 501554 503004 507697 509027 512589 512741 513838 513915 514375 514456 514638 517248 517320 518607 518634 520014 520283 522735 524416 525590 526380 527555 527641 527670 528386 529420 529438 529710 529777 535056 535578 540071 547649 547658 552350 555798 558414 559933 561191 564162 564327 564526 564556 565631 566922 568580 569014 569256 573802 577612 581719 581996 582694 583037 591595 596823 597587 598718 605162 610593 615818 616778 617214 623724 625144 625861 625968 626126 632055 650992 682303 714307 786933 ] |
||||||||||||||||||||||||||||||
|
20.11 ms (8.31%) |
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 518607 522735 527641 527670 518634 520283 496169 498766 525590 527555 489073 493851 496667 512589 615818 397508 418594 451652 452663 457192 485064 535578 496553 520014 524416 526380 509027 503004 552350 564556 569256 573802 547649 582694 583037 561191 564526 566922 714307 559933 565631 577612 605162 597587 610593 625144 623724 786933 435502 439551 453725 482070 455875 513915 484066 493316 517248 501554 514456 517320 422176 459412 453710 513838 529420 507697 495140 528386 558414 581719 569014 616778 598718 617214 632055 449904 529710 490763 529438 455943 450847 529777 535056 540071 555798 568580 581996 650992 682303 564162 591595 400581 469604 564327 625968 514375 514638 484498 497935 547658 596823 625861 496853 512741 626126 493249 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (1.31%) |
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 397508 400581 418594 422176 435502 439551 449904 450847 451652 452663 453710 453725 455875 455943 457192 459412 469604 482070 484066 484498 485064 489073 490763 493249 493316 493851 495140 496169 496553 496667 496853 497935 498766 501554 503004 507697 509027 512589 512741 513838 513915 514375 514456 514638 517248 517320 518607 518634 520014 520283 522735 524416 525590 526380 527555 527641 527670 528386 529420 529438 529710 529777 535056 535578 540071 547649 547658 552350 555798 558414 559933 561191 564162 564327 564526 564556 565631 566922 568580 569014 569256 573802 577612 581719 581996 582694 583037 591595 596823 597587 598718 605162 610593 615818 616778 617214 623724 625144 625861 625968 626126 632055 650992 682303 714307 786933 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"she is cum"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"she cum"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.61%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.33 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"she cum"
]
|
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.