Query Metrics
7
Database Queries
7
Different statements
131.11 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.90 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.20 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"daddy xxx"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.16 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 524561 524573 484127 496356 526255 486348 510692 515824 519460 524253 422565 444882 476903 484954 520941 523159 524089 510466 496086 486314 550614 555857 579707 583654 567152 663380 663465 571958 621767 598824 599295 397548 412738 413096 481847 404811 463165 464650 395856 463134 500803 511200 521357 539001 489823 519402 485304 497424 509696 519695 529125 399263 444660 446457 452828 518559 568558 613683 605467 467162 446682 454871 453529 517549 521426 525262 482824 452178 493192 557064 567046 619569 590851 519977 503934 523030 644954 577822 603124 520005 523809 424746 559044 659216 564136 613488 609922 532644 490204 ] |
||||||||||||||||||||||||||||||
| 4 | 2.86 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 395856 397548 399263 404811 412738 413096 422565 424746 444660 444882 446457 446682 452178 452828 453529 454871 463134 463165 464650 467162 476903 481847 482824 484127 484954 485304 486314 486348 489823 490204 493192 496086 496356 497424 500803 503934 509696 510466 510692 511200 515824 517549 518559 519402 519460 519695 519977 520005 520941 521357 521426 523030 523159 523809 524089 524253 524561 524573 525262 526255 529125 532644 539001 550614 555857 557064 559044 564136 567046 567152 568558 571958 577822 579707 583654 590851 598824 599295 603124 605467 609922 613488 613683 619569 621767 644954 659216 663380 663465 ] |
||||||||||||||||||||||||||||||
| 5 | 105.10 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 395856 397548 399263 404811 412738 413096 422565 424746 444660 444882 446457 446682 452178 452828 453529 454871 463134 463165 464650 467162 476903 481847 482824 484127 484954 485304 486314 486348 489823 490204 493192 496086 496356 497424 500803 503934 509696 510466 510692 511200 515824 517549 518559 519402 519460 519695 519977 520005 520941 521357 521426 523030 523159 523809 524089 524253 524561 524573 525262 526255 529125 532644 539001 550614 555857 557064 559044 564136 567046 567152 568558 571958 577822 579707 583654 590851 598824 599295 603124 605467 609922 613488 613683 619569 621767 644954 659216 663380 663465 ] |
||||||||||||||||||||||||||||||
| 6 | 1.56 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"daddy xxx"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.33 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"daddy xxx"
]
|
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.