Query Metrics
7
Database Queries
7
Different statements
274.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
247.20 ms (90.09%) |
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 421165 431505 431521 438889 440664 443611 446418 447195 448584 449223 449344 451608 453041 453662 454139 455452 456292 456485 456585 459517 463839 464228 464893 465996 466780 470394 471140 472410 475624 476400 476421 476617 478705 479396 480962 481846 482126 483232 483800 483918 484532 484720 485258 485739 486098 486755 489161 492746 493116 497058 498943 499002 499799 501210 503958 504213 507084 507295 507405 510362 511129 511588 521062 522267 522328 523268 524507 525235 527391 530207 533948 542083 543816 545205 545717 547878 549618 549782 551676 552567 558563 558862 560278 561401 567089 567196 570109 570839 572237 574826 574880 575509 575706 578031 580032 580142 581607 588255 590854 591427 596670 598076 598184 603095 604619 620345 622405 624142 630731 665920 692183 693024 720883 731326 731971 734153 809720 818866 824499 825124 ] |
||||||||||||||||||||||||||||||
|
16.57 ms (6.04%) |
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 570109 575509 545717 567196 552567 558563 561401 570839 575706 580032 567089 574826 580142 598076 603095 588255 622405 590854 598184 731326 624142 720883 421165 438889 431521 440664 449223 449344 453041 455452 464228 472410 447195 454139 464893 481846 484532 471140 478705 497058 498943 549618 558862 560278 574880 542083 551676 545205 547878 549782 665920 693024 572237 578031 581607 604619 620345 596670 630731 591427 731971 809720 470394 475624 476421 480962 448584 463839 465996 479396 431505 446418 453662 456485 476400 456292 466780 476617 443611 456585 459517 499799 511588 527391 483232 485739 486098 499002 503958 522267 523268 484720 492746 493116 507405 521062 525235 533948 485258 507295 510362 524507 522328 504213 530207 692183 734153 543816 824499 825124 818866 483800 486755 451608 482126 483918 489161 507084 511129 501210 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.10%) |
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 421165 431505 431521 438889 440664 443611 446418 447195 448584 449223 449344 451608 453041 453662 454139 455452 456292 456485 456585 459517 463839 464228 464893 465996 466780 470394 471140 472410 475624 476400 476421 476617 478705 479396 480962 481846 482126 483232 483800 483918 484532 484720 485258 485739 486098 486755 489161 492746 493116 497058 498943 499002 499799 501210 503958 504213 507084 507295 507405 510362 511129 511588 521062 522267 522328 523268 524507 525235 527391 530207 533948 542083 543816 545205 545717 547878 549618 549782 551676 552567 558563 558862 560278 561401 567089 567196 570109 570839 572237 574826 574880 575509 575706 578031 580032 580142 581607 588255 590854 591427 596670 598076 598184 603095 604619 620345 622405 624142 630731 665920 692183 693024 720883 731326 731971 734153 809720 818866 824499 825124 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small cock webcam"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая cock вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.63%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая cock вебкамер"
]
|
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.