Query Metrics
7
Database Queries
7
Different statements
182.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.64 ms (84.51%) |
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 45136 327421 388913 394187 394747 396275 400444 402114 409390 413295 415573 417259 418407 418865 423301 423580 425653 429124 429366 434571 443205 443372 451490 453224 453525 458148 459086 459385 462697 462707 464326 472125 473468 479878 480415 485482 488118 491715 494008 494290 495235 496181 497934 499100 504063 504172 512607 512932 514790 515269 515459 515854 517003 520732 521062 521926 521933 522923 523099 523900 523936 524285 526547 529251 550834 565956 569141 572138 574153 576214 580723 587445 587511 588676 591978 593080 593172 593533 594029 594577 596161 597264 597892 600653 602470 603616 605478 608009 608387 614995 615919 616098 620056 620569 623413 624814 624999 630713 665589 667253 674130 680251 683906 686082 687604 690153 695831 705327 713630 713834 721579 723492 732001 748133 748143 753260 755213 759650 760004 809225 ] |
||||||||||||||||||||||||||||||
|
17.09 ms (9.34%) |
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 667253 674130 687604 695831 721579 665589 680251 683906 686082 713630 550834 565956 569141 572138 574153 576214 580723 591978 593533 608387 597264 602470 603616 616098 620056 587511 588676 594029 596161 600653 615919 620569 624814 587445 593080 593172 594577 597892 605478 624999 809225 753260 760004 748133 748143 759650 732001 755213 608009 630713 705327 713834 723492 453224 458148 45136 409390 451490 459086 459385 462707 479878 413295 418407 417259 418865 425653 453525 480415 434571 462697 473468 504063 504172 514790 526547 494008 494290 499100 515854 523900 495235 515269 517003 521062 521933 523099 485482 488118 491715 496181 497934 512607 512932 520732 521926 522923 523936 524285 529251 623413 515459 472125 614995 464326 394187 394747 327421 388913 396275 400444 402114 443372 415573 423580 443205 423301 429124 429366 690153 ] |
||||||||||||||||||||||||||||||
|
4.15 ms (2.27%) |
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 45136 327421 388913 394187 394747 396275 400444 402114 409390 413295 415573 417259 418407 418865 423301 423580 425653 429124 429366 434571 443205 443372 451490 453224 453525 458148 459086 459385 462697 462707 464326 472125 473468 479878 480415 485482 488118 491715 494008 494290 495235 496181 497934 499100 504063 504172 512607 512932 514790 515269 515459 515854 517003 520732 521062 521926 521933 522923 523099 523900 523936 524285 526547 529251 550834 565956 569141 572138 574153 576214 580723 587445 587511 588676 591978 593080 593172 593533 594029 594577 596161 597264 597892 600653 602470 603616 605478 608009 608387 614995 615919 616098 620056 620569 623413 624814 624999 630713 665589 667253 674130 680251 683906 686082 687604 690153 695831 705327 713630 713834 721579 723492 732001 748133 748143 753260 755213 759650 760004 809225 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fucking man"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fucking мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fucking мужчин"
]
|
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.