Query Metrics
7
Database Queries
7
Different statements
201.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.49 ms (83.55%) |
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 96530 387766 401373 406377 415256 415534 417737 422631 422909 423026 425493 425569 431484 433069 437687 445466 445831 446260 447436 451887 451979 452247 454675 455841 456519 457291 458624 458838 461059 463848 463963 464610 465664 466840 469537 472431 472722 473907 474031 474848 475408 475451 484120 488771 490823 491457 491679 492232 495027 496040 498586 500168 501533 503051 510851 514818 515062 515124 515377 517066 517727 517749 518218 518619 521452 523087 523491 524849 525020 525415 533196 536178 536569 536581 537594 541291 542212 558359 561702 565324 568360 570705 575788 575845 576068 576366 578420 578502 579331 580589 587797 589723 593167 598194 598554 598642 598836 599851 600460 605303 606472 607403 615578 615832 619746 628416 632698 650285 654174 676283 679713 703089 719001 720684 734506 742428 744212 757105 759980 809191 ] |
||||||||||||||||||||||||||||||
|
21.56 ms (10.69%) |
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 568360 96530 679713 615832 744212 607403 425493 437687 576366 542212 606472 615578 809191 605303 415534 431484 475408 491679 525415 524849 463848 498586 433069 401373 422909 473907 474031 537594 575845 576068 654174 598554 490823 451979 452247 515124 515377 533196 515062 578420 650285 561702 598194 757105 759980 472722 465664 518218 495027 523491 541291 387766 457291 458624 558359 598836 484120 521452 415256 514818 456519 619746 496040 461059 492232 455841 565324 580589 503051 446260 417737 628416 719001 632698 734506 676283 720684 525020 425569 488771 536178 536581 598642 599851 703089 447436 517066 406377 458838 536569 579331 587797 445831 517749 517727 422631 454675 469537 500168 472431 570705 600460 589723 742428 445466 451887 464610 518619 510851 501533 578502 593167 466840 491457 523087 423026 463963 474848 475451 575788 ] |
||||||||||||||||||||||||||||||
|
4.42 ms (2.19%) |
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 96530 387766 401373 406377 415256 415534 417737 422631 422909 423026 425493 425569 431484 433069 437687 445466 445831 446260 447436 451887 451979 452247 454675 455841 456519 457291 458624 458838 461059 463848 463963 464610 465664 466840 469537 472431 472722 473907 474031 474848 475408 475451 484120 488771 490823 491457 491679 492232 495027 496040 498586 500168 501533 503051 510851 514818 515062 515124 515377 517066 517727 517749 518218 518619 521452 523087 523491 524849 525020 525415 533196 536178 536569 536581 537594 541291 542212 558359 561702 565324 568360 570705 575788 575845 576068 576366 578420 578502 579331 580589 587797 589723 593167 598194 598554 598642 598836 599851 600460 605303 606472 607403 615578 615832 619746 628416 632698 650285 654174 676283 679713 703089 719001 720684 734506 742428 744212 757105 759980 809191 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс кастинг"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс кастинг"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.80%) |
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.