Query Metrics
7
Database Queries
7
Different statements
165.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.42 ms (83.01%) |
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 229389 410677 421819 421836 423784 426826 428249 429362 429602 430598 432320 437188 437190 437624 439187 440949 441149 442754 450847 451081 452567 452624 456308 457620 458368 460109 460439 462267 464868 465005 466564 467966 468668 468975 469831 470146 470150 470599 471030 472296 474213 477485 478519 478797 478824 480858 483052 484272 484277 488165 489703 490714 491141 494805 500518 501907 501912 503544 503561 503621 504428 506734 506813 507145 507677 507993 508378 508713 509639 511289 516394 517709 517739 520552 520610 520613 520928 522331 523691 524169 525919 527853 527914 528462 528660 534772 538054 541706 543366 544452 549786 552811 554981 556726 557940 558508 558654 564620 566093 569622 569629 569788 574062 574664 586656 586934 588877 592862 598050 598141 608550 613995 625631 659370 675866 740552 818654 825793 827477 828109 ] |
||||||||||||||||||||||||||||||
|
17.84 ms (10.77%) |
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 471030 478519 500518 522331 524169 528462 504428 517709 520552 520610 489703 490714 484272 484277 520613 527853 586934 588877 613995 592862 470150 517739 574062 549786 466564 468975 503561 825793 827477 229389 740552 818654 828109 429362 410677 426826 429602 430598 441149 439187 440949 460109 465005 467966 456308 457620 458368 469831 451081 494805 511289 534772 538054 468668 558654 569629 556726 569622 569788 574664 543366 544452 552811 554981 675866 659370 557940 558508 566093 586656 598050 608550 625631 598141 462267 421836 428249 460439 470146 478824 421819 423784 432320 452567 474213 478797 437188 437190 437624 452624 472296 480858 442754 464868 470599 477485 503544 508378 541706 501907 501912 508713 509639 527914 491141 503621 506734 506813 507145 516394 520928 528660 483052 488165 507677 507993 523691 525919 450847 564620 ] |
||||||||||||||||||||||||||||||
|
3.51 ms (2.12%) |
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 229389 410677 421819 421836 423784 426826 428249 429362 429602 430598 432320 437188 437190 437624 439187 440949 441149 442754 450847 451081 452567 452624 456308 457620 458368 460109 460439 462267 464868 465005 466564 467966 468668 468975 469831 470146 470150 470599 471030 472296 474213 477485 478519 478797 478824 480858 483052 484272 484277 488165 489703 490714 491141 494805 500518 501907 501912 503544 503561 503621 504428 506734 506813 507145 507677 507993 508378 508713 509639 511289 516394 517709 517739 520552 520610 520613 520928 522331 523691 524169 525919 527853 527914 528462 528660 534772 538054 541706 543366 544452 549786 552811 554981 556726 557940 558508 558654 564620 566093 569622 569629 569788 574062 574664 586656 586934 588877 592862 598050 598141 608550 613995 625631 659370 675866 740552 818654 825793 827477 828109 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam redhead"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер рыжая"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер рыжая"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.