Query Metrics
7
Database Queries
7
Different statements
201.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.29 ms (86.88%) |
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 6698 68383 188282 233707 381991 385048 388149 396865 400421 407516 409774 411375 411790 426917 430822 438562 441234 443692 444926 445620 446954 447485 449851 451460 453652 454559 457081 461302 461575 462018 465342 465860 466350 467026 468945 473931 474399 481276 484429 484591 484849 488693 490195 490924 490945 491540 491573 492658 494346 501770 502718 503822 507405 507877 508047 510642 510689 511747 512252 516441 516822 516980 518329 518995 520889 521342 521861 522539 523018 523902 524146 526387 527806 528373 535365 552184 559083 560653 561460 562319 567738 570256 570380 570478 571620 571913 572121 572501 572568 572801 572822 573095 590533 601190 605083 612083 649536 659105 676914 676979 692910 701296 712652 714848 722127 722537 723961 724726 741047 753089 769750 776103 781970 788729 794689 795782 807769 808631 811404 820123 ] |
||||||||||||||||||||||||||||||
|
14.68 ms (7.27%) |
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 465342 468945 481276 381991 400421 411375 426917 430822 441234 447485 454559 466350 473931 233707 407516 443692 444926 465860 474399 445620 457081 461575 467026 501770 508047 510689 518329 520889 522539 524146 484429 484591 491540 492658 511747 512252 484849 494346 507405 521342 523018 523902 528373 490195 490924 490945 491573 502718 503822 507877 516822 516980 518995 521861 527806 409774 411790 68383 385048 188282 6698 388149 396865 438562 820123 446954 449851 453652 488693 461302 451460 462018 510642 516441 526387 535365 552184 559083 561460 570380 572822 560653 570256 572801 562319 567738 571620 571913 572568 573095 649536 659105 676979 692910 722127 712652 714848 676914 701296 722537 570478 572121 572501 601190 590533 605083 612083 776103 781970 795782 808631 811404 723961 741047 753089 788729 794689 807769 769750 724726 ] |
||||||||||||||||||||||||||||||
|
4.43 ms (2.20%) |
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 6698 68383 188282 233707 381991 385048 388149 396865 400421 407516 409774 411375 411790 426917 430822 438562 441234 443692 444926 445620 446954 447485 449851 451460 453652 454559 457081 461302 461575 462018 465342 465860 466350 467026 468945 473931 474399 481276 484429 484591 484849 488693 490195 490924 490945 491540 491573 492658 494346 501770 502718 503822 507405 507877 508047 510642 510689 511747 512252 516441 516822 516980 518329 518995 520889 521342 521861 522539 523018 523902 524146 526387 527806 528373 535365 552184 559083 560653 561460 562319 567738 570256 570380 570478 571620 571913 572121 572501 572568 572801 572822 573095 590533 601190 605083 612083 649536 659105 676914 676979 692910 701296 712652 714848 722127 722537 723961 724726 741047 753089 769750 776103 781970 788729 794689 795782 807769 808631 811404 820123 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boy kissing"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен kissing"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"парен kissing"
]
|
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.