Query Metrics
7
Database Queries
7
Different statements
122.08 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.94 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.30 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"show girl"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.26 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 466367 423821 469694 488249 524188 508121 471115 466779 525104 507787 530943 541465 677416 602186 603193 590418 604667 784932 457998 474361 422380 454996 431080 540574 603403 420515 465103 574243 427209 476420 508525 523873 644915 459412 569389 680147 564116 604865 805146 528266 474119 476428 520299 521505 559430 609164 793425 503172 519068 464681 500803 654534 564643 520720 471495 413000 455767 484418 512693 590579 449356 518596 518879 530661 680159 585889 477223 453343 602092 807023 446437 455749 493212 618949 518622 618424 535094 535015 465524 654518 656782 598168 614743 504085 606799 ] |
||||||||||||||||||||||||||||||
| 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 413000 420515 422380 423821 427209 431080 446437 449356 453343 454996 455749 455767 457998 459412 464681 465103 465524 466367 466779 469694 471115 471495 474119 474361 476420 476428 477223 484418 488249 493212 500803 503172 504085 507787 508121 508525 512693 518596 518622 518879 519068 520299 520720 521505 523873 524188 525104 528266 530661 530943 535015 535094 540574 541465 559430 564116 564643 569389 574243 585889 590418 590579 598168 602092 602186 603193 603403 604667 604865 606799 609164 614743 618424 618949 644915 654518 654534 656782 677416 680147 680159 784932 793425 805146 807023 ] |
||||||||||||||||||||||||||||||
| 5 | 95.94 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 413000 420515 422380 423821 427209 431080 446437 449356 453343 454996 455749 455767 457998 459412 464681 465103 465524 466367 466779 469694 471115 471495 474119 474361 476420 476428 477223 484418 488249 493212 500803 503172 504085 507787 508121 508525 512693 518596 518622 518879 519068 520299 520720 521505 523873 524188 525104 528266 530661 530943 535015 535094 540574 541465 559430 564116 564643 569389 574243 585889 590418 590579 598168 602092 602186 603193 603403 604667 604865 606799 609164 614743 618424 618949 644915 654518 654534 656782 677416 680147 680159 784932 793425 805146 807023 ] |
||||||||||||||||||||||||||||||
| 6 | 1.96 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"show девушк"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.79 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"show девушк"
]
|
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.