Query Metrics
7
Database Queries
7
Different statements
172.51 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.46 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.04 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vintage pussy"
]
|
||||||||||||||||||||||||||||||
| 3 | 23.06 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 566409 574265 576646 576705 581386 581394 583878 664157 671756 671759 671763 677707 694181 695629 703051 716405 717862 719099 649196 670098 671737 671739 674081 691820 691992 693030 696351 699631 703080 709624 716244 717873 720726 649091 661891 670093 671713 671741 671888 672122 677729 677730 684030 692315 692786 694374 717903 720379 722211 549774 561993 563152 563197 563201 563203 563214 563227 563415 563453 572542 581315 581354 583835 586015 592390 592475 592500 595735 600320 605324 615565 644379 587795 592388 592636 603187 620170 621308 644321 589692 590696 605007 605322 605328 605330 605344 619485 620152 624395 644311 784358 732716 749100 727751 727794 622366 622830 630288 644289 644306 644324 703039 715676 807976 482945 579345 819506 516221 538816 541324 542484 544277 544313 544468 548297 557187 562842 563001 563125 571242 ] |
||||||||||||||||||||||||||||||
| 4 | 2.52 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 482945 516221 538816 541324 542484 544277 544313 544468 548297 549774 557187 561993 562842 563001 563125 563152 563197 563201 563203 563214 563227 563415 563453 566409 571242 572542 574265 576646 576705 579345 581315 581354 581386 581394 583835 583878 586015 587795 589692 590696 592388 592390 592475 592500 592636 595735 600320 603187 605007 605322 605324 605328 605330 605344 615565 619485 620152 620170 621308 622366 622830 624395 630288 644289 644306 644311 644321 644324 644379 649091 649196 661891 664157 670093 670098 671713 671737 671739 671741 671756 671759 671763 671888 672122 674081 677707 677729 677730 684030 691820 691992 692315 692786 693030 694181 694374 695629 696351 699631 703039 703051 703080 709624 715676 716244 716405 717862 717873 717903 719099 720379 720726 722211 727751 727794 732716 749100 784358 807976 819506 ] |
||||||||||||||||||||||||||||||
| 5 | 139.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 482945 516221 538816 541324 542484 544277 544313 544468 548297 549774 557187 561993 562842 563001 563125 563152 563197 563201 563203 563214 563227 563415 563453 566409 571242 572542 574265 576646 576705 579345 581315 581354 581386 581394 583835 583878 586015 587795 589692 590696 592388 592390 592475 592500 592636 595735 600320 603187 605007 605322 605324 605328 605330 605344 615565 619485 620152 620170 621308 622366 622830 624395 630288 644289 644306 644311 644321 644324 644379 649091 649196 661891 664157 670093 670098 671713 671737 671739 671741 671756 671759 671763 671888 672122 674081 677707 677729 677730 684030 691820 691992 692315 692786 693030 694181 694374 695629 696351 699631 703039 703051 703080 709624 715676 716244 716405 717862 717873 717903 719099 720379 720726 722211 727751 727794 732716 749100 784358 807976 819506 ] |
||||||||||||||||||||||||||||||
| 6 | 1.81 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"vintage pussy"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.51 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"vintage 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.