Query Metrics
7
Database Queries
7
Different statements
167.21 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.66 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.82 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen solo close-up"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.19 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 439359 453213 439046 439325 450599 493696 507951 483691 488049 497482 506168 452773 415874 696061 608091 411255 435793 439158 416694 419200 420295 420816 433601 449104 452775 452843 478514 476887 483737 454509 520419 504781 533917 511240 513790 519698 532370 541278 547493 558132 642022 807580 808327 432179 432268 414114 416663 465148 416680 452436 416009 456244 489615 497667 415957 415966 416529 471148 661510 651904 683446 604387 432180 444535 414116 432288 470458 418144 487200 443219 722373 602614 806580 615918 417396 561346 561970 603092 477757 495568 609892 480800 421678 530948 498226 485149 ] |
||||||||||||||||||||||||||||||
| 4 | 2.89 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 411255 414114 414116 415874 415957 415966 416009 416529 416663 416680 416694 417396 418144 419200 420295 420816 421678 432179 432180 432268 432288 433601 435793 439046 439158 439325 439359 443219 444535 449104 450599 452436 452773 452775 452843 453213 454509 456244 465148 470458 471148 476887 477757 478514 480800 483691 483737 485149 487200 488049 489615 493696 495568 497482 497667 498226 504781 506168 507951 511240 513790 519698 520419 530948 532370 533917 541278 547493 558132 561346 561970 602614 603092 604387 608091 609892 615918 642022 651904 661510 683446 696061 722373 806580 808327 ] |
||||||||||||||||||||||||||||||
| 5 | 140.71 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 411255 414114 414116 415874 415957 415966 416009 416529 416663 416680 416694 417396 418144 419200 420295 420816 421678 432179 432180 432268 432288 433601 435793 439046 439158 439325 439359 443219 444535 449104 450599 452436 452773 452775 452843 453213 454509 456244 465148 470458 471148 476887 477757 478514 480800 483691 483737 485149 487200 488049 489615 493696 495568 497482 497667 498226 504781 506168 507951 511240 513790 519698 520419 530948 532370 533917 541278 547493 558132 561346 561970 602614 603092 604387 608091 609892 615918 642022 651904 661510 683446 696061 722373 806580 808327 ] |
||||||||||||||||||||||||||||||
| 6 | 2.22 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen соло close up"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.72 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen соло close up"
]
|
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.