Query Metrics
7
Database Queries
7
Different statements
391.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.13 ms (53.67%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мультфильм девушк"
]
|
||||||||||||||||||||||||||||||
|
154.97 ms (39.58%) |
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 415074 417828 423427 426592 430884 431020 431829 436727 437523 439828 442238 445455 446203 446363 446396 447072 448489 450722 450977 451064 451149 451257 452430 452833 456525 457349 457978 458928 464994 465008 465665 468012 469507 470443 470449 475272 475338 476514 478829 478994 480861 482140 482999 483162 485138 485150 487367 489077 489679 500571 505279 507928 508474 508800 509970 512512 518723 521276 521431 522669 524845 525061 525968 528813 532349 535486 536616 540356 543337 543344 544784 547243 547481 552270 552412 559547 567304 578067 578401 579358 580180 581749 582972 588534 595200 600453 601160 602249 605474 621482 621760 622278 623931 632084 636288 649619 677712 703364 710871 710943 724209 745493 752661 766590 784146 784152 788132 788260 788264 788268 788994 792554 792555 792558 799721 800570 806228 806591 808865 825864 ] |
||||||||||||||||||||||||||||||
|
17.50 ms (4.47%) |
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 451257 448489 452430 535486 806591 437523 450722 430884 457978 489679 521431 543344 547481 580180 552412 621482 792554 724209 788260 766590 799721 476514 465008 451064 485138 525061 500571 442238 595200 458928 482999 456525 540356 482140 582972 677712 710871 622278 792555 800570 806228 788994 784146 710943 478829 465665 470443 521276 487367 524845 508800 825864 447072 522669 528813 512512 547243 578401 543337 578067 623931 636288 752661 621760 788268 451149 415074 483162 485150 518723 505279 579358 544784 649619 468012 417828 507928 567304 588534 784152 446203 446363 509970 439828 452833 489077 602249 745493 480861 426592 525968 508474 532349 536616 559547 788264 436727 445455 450977 431829 431020 423427 464994 475272 478994 469507 475338 552270 581749 703364 632084 605474 600453 601160 788132 808865 792558 446396 457349 470449 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (0.84%) |
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 415074 417828 423427 426592 430884 431020 431829 436727 437523 439828 442238 445455 446203 446363 446396 447072 448489 450722 450977 451064 451149 451257 452430 452833 456525 457349 457978 458928 464994 465008 465665 468012 469507 470443 470449 475272 475338 476514 478829 478994 480861 482140 482999 483162 485138 485150 487367 489077 489679 500571 505279 507928 508474 508800 509970 512512 518723 521276 521431 522669 524845 525061 525968 528813 532349 535486 536616 540356 543337 543344 544784 547243 547481 552270 552412 559547 567304 578067 578401 579358 580180 581749 582972 588534 595200 600453 601160 602249 605474 621482 621760 622278 623931 632084 636288 649619 677712 703364 710871 710943 724209 745493 752661 766590 784146 784152 788132 788260 788264 788268 788994 792554 792555 792558 799721 800570 806228 806591 808865 825864 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"animated girls"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мультфильм девушк"
]
|
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.