Query Metrics
7
Database Queries
7
Different statements
187.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.83 ms (85.64%) |
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 187203 370949 382020 382140 383828 387251 387544 388713 390447 390574 391392 395513 404528 407819 414385 415145 418876 421325 424741 425503 428223 428453 430144 433217 436134 441110 443171 446313 447276 451127 453471 454186 454192 454208 454714 455058 455957 457389 457775 458707 460418 465592 465788 467075 471445 471648 472241 473891 475679 477071 479258 480809 481345 481663 482483 482505 484396 484439 484683 485751 486531 486789 486955 488560 490474 490877 492648 493203 494204 494563 495678 495714 497798 498037 498081 498702 498763 499073 499184 499549 500940 506535 507165 507209 507739 507901 509260 509376 512607 513964 514289 515572 515635 515643 519343 520583 520935 522978 523175 523634 523778 523834 523852 526071 527224 528800 529401 536462 540552 542525 549968 555987 556467 556938 557244 558021 563053 564445 567431 573734 ] |
||||||||||||||||||||||||||||||
|
17.53 ms (9.33%) |
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 498702 507165 514289 515635 519343 520935 522978 527224 484396 484683 490474 494204 498037 506535 509260 523175 523634 523778 526071 484439 490877 492648 494563 495678 495714 498081 498763 499073 499184 512607 515643 523834 523852 528800 383828 187203 395513 370949 382020 382140 388713 387544 387251 390574 390447 391392 404528 418876 425503 428453 433217 436134 441110 414385 421325 407819 415145 430144 443171 424741 428223 482483 482505 446313 451127 453471 454186 455957 457389 457775 458707 471445 479258 486955 447276 454714 475679 493203 454192 454208 455058 465592 465788 472241 473891 477071 481663 485751 486531 488560 499549 507901 509376 520583 529401 540552 507209 513964 500940 497798 507739 515572 536462 460418 467075 471648 480809 481345 486789 556467 557244 558021 563053 564445 573734 555987 556938 567431 542525 549968 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.45%) |
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 187203 370949 382020 382140 383828 387251 387544 388713 390447 390574 391392 395513 404528 407819 414385 415145 418876 421325 424741 425503 428223 428453 430144 433217 436134 441110 443171 446313 447276 451127 453471 454186 454192 454208 454714 455058 455957 457389 457775 458707 460418 465592 465788 467075 471445 471648 472241 473891 475679 477071 479258 480809 481345 481663 482483 482505 484396 484439 484683 485751 486531 486789 486955 488560 490474 490877 492648 493203 494204 494563 495678 495714 497798 498037 498081 498702 498763 499073 499184 499549 500940 506535 507165 507209 507739 507901 509260 509376 512607 513964 514289 515572 515635 515643 519343 520583 520935 522978 523175 523634 523778 523834 523852 526071 527224 528800 529401 536462 540552 542525 549968 555987 556467 556938 557244 558021 563053 564445 567431 573734 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"даму"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дам"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.71%) |
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.