Query Metrics
7
Database Queries
7
Different statements
149.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.23 ms (82.47%) |
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 387125 387874 390934 393476 403725 421845 421865 424121 426703 426865 427585 432737 434067 436138 441288 446179 447588 448511 452772 454623 455787 456573 456591 457441 459134 461843 463848 465324 465773 465807 466284 470572 479583 490235 490529 493670 508569 511811 512010 512613 523743 524070 529597 534432 537960 538011 544988 545183 545936 546310 552294 556474 563025 565496 566843 568960 571415 579821 587908 590775 599002 612718 614915 617683 623699 633935 639222 640060 644106 649244 650262 650722 652760 655241 655293 657466 662509 663738 672291 673934 683357 710687 717241 720410 720952 723662 728762 739164 742852 751120 760962 764240 765366 765743 765819 767055 772661 775543 777737 778628 782674 788838 791426 793196 794873 798801 800336 800380 800407 800592 800785 801101 801634 804325 804905 806838 807032 815131 817155 819705 ] |
||||||||||||||||||||||||||||||
|
15.69 ms (10.50%) |
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 728762 739164 804325 544988 650722 655293 683357 720952 672291 650262 662509 673934 546310 571415 644106 587908 590775 614915 623699 633935 777737 778628 793196 798801 775543 782674 794873 800336 800407 764240 765366 765819 767055 772661 640060 717241 791426 800785 817155 493670 807032 760962 390934 448511 490529 470572 511811 568960 545183 579821 751120 447588 463848 466284 479583 436138 456591 446179 454623 441288 512010 537960 523743 534432 556474 465324 508569 742852 801101 815131 545936 804905 403725 599002 421865 426865 465807 512613 387125 387874 652760 617683 806838 723662 720410 639222 612718 800592 765743 710687 788838 393476 819705 529597 649244 655241 663738 801634 800380 457441 657466 434067 432737 563025 552294 565496 566843 426703 455787 459134 465773 424121 452772 456573 427585 421845 461843 490235 538011 524070 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (2.07%) |
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 387125 387874 390934 393476 403725 421845 421865 424121 426703 426865 427585 432737 434067 436138 441288 446179 447588 448511 452772 454623 455787 456573 456591 457441 459134 461843 463848 465324 465773 465807 466284 470572 479583 490235 490529 493670 508569 511811 512010 512613 523743 524070 529597 534432 537960 538011 544988 545183 545936 546310 552294 556474 563025 565496 566843 568960 571415 579821 587908 590775 599002 612718 614915 617683 623699 633935 639222 640060 644106 649244 650262 650722 652760 655241 655293 657466 662509 663738 672291 673934 683357 710687 717241 720410 720952 723662 728762 739164 742852 751120 760962 764240 765366 765743 765819 767055 772661 775543 777737 778628 782674 788838 791426 793196 794873 798801 800336 800380 800407 800592 800785 801101 801634 804325 804905 806838 807032 815131 817155 819705 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal doggy pov"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал рак пов"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.09%) |
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.