Query Metrics
7
Database Queries
7
Different statements
195.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.11 ms (87.42%) |
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 386686 416111 418024 418277 420912 421189 421338 422371 423444 424178 424231 424575 424932 424969 425562 426779 427000 427081 429135 432368 432519 432563 433420 434610 435020 435754 438029 442442 448237 449647 449652 450372 450442 452650 452766 454374 456063 456976 457198 458632 459187 460543 460894 461391 461912 462983 463479 463599 463618 464822 466773 468968 471182 471641 473232 473557 473673 475610 475851 476071 476477 479164 479298 483470 483967 484007 484111 485268 489613 489664 492614 493844 496616 499750 499953 499959 501133 501383 504741 505567 508981 509381 512051 515742 517169 517214 517634 518081 518450 518809 520318 522001 522635 522993 524049 524094 524115 524163 524390 525571 526247 556441 557090 557361 558630 568570 571256 577468 595834 601953 602504 605205 618586 620491 621745 662567 673244 686596 709431 726410 ] |
||||||||||||||||||||||||||||||
|
15.45 ms (7.89%) |
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 452766 456063 457198 460894 461391 461912 416111 418277 420912 421189 422371 424178 424231 424969 425562 427000 427081 432519 438029 442442 450372 458632 462983 471182 471641 476477 479298 386686 421338 423444 429135 434610 449647 456976 463618 466773 473232 475851 418024 433420 435754 448237 460543 463479 463599 464822 473557 475610 476071 499959 518809 520318 524049 483967 484007 489613 492614 501383 512051 518450 524390 499750 499953 501133 504741 508981 517214 522001 524115 525571 526247 484111 493844 505567 515742 522635 524163 479164 517169 557361 577468 595834 424932 449652 459187 452650 483470 485268 468968 522993 524094 496616 509381 518081 517634 489664 558630 571256 568570 673244 686596 709431 662567 556441 557090 621745 602504 620491 618586 726410 601953 605205 424575 432368 473673 450442 426779 432563 435020 454374 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.33%) |
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 386686 416111 418024 418277 420912 421189 421338 422371 423444 424178 424231 424575 424932 424969 425562 426779 427000 427081 429135 432368 432519 432563 433420 434610 435020 435754 438029 442442 448237 449647 449652 450372 450442 452650 452766 454374 456063 456976 457198 458632 459187 460543 460894 461391 461912 462983 463479 463599 463618 464822 466773 468968 471182 471641 473232 473557 473673 475610 475851 476071 476477 479164 479298 483470 483967 484007 484111 485268 489613 489664 492614 493844 496616 499750 499953 499959 501133 501383 504741 505567 508981 509381 512051 515742 517169 517214 517634 518081 518450 518809 520318 522001 522635 522993 524049 524094 524115 524163 524390 525571 526247 556441 557090 557361 558630 568570 571256 577468 595834 601953 602504 605205 618586 620491 621745 662567 673244 686596 709431 726410 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sister sperm"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sister сперм"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.21 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sister сперм"
]
|
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.