Query Metrics
7
Database Queries
7
Different statements
203.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.72 ms (88.41%) |
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 94529 152276 181009 191160 213627 233027 233102 248770 282481 302771 309283 325863 381913 382748 382857 384395 384888 385549 385908 387548 388935 389355 390592 390981 394247 395428 395784 396215 396889 396958 397054 397436 397679 398045 400926 401509 401522 402012 402065 406070 414516 416841 417272 418155 424497 426666 426844 427803 429145 429193 429216 431722 436827 440569 443053 450125 454040 454045 460173 460632 460856 462980 463220 466042 466787 468053 469824 470716 470784 470952 473286 474389 476276 478397 479486 486902 490646 491996 492361 492610 495741 498104 498453 501678 501690 508830 518795 520919 522555 522608 523484 525749 542876 546715 551209 563155 563456 563625 564902 565303 566867 570595 571623 574498 576685 577290 598018 600464 644160 654466 680616 681692 701302 774243 780867 800071 806004 812137 819390 827932 ] |
||||||||||||||||||||||||||||||
|
14.11 ms (6.94%) |
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 598018 426666 431722 382748 398045 463220 523484 395428 454045 468053 680616 681692 800071 774243 812137 390592 522555 443053 486902 402012 470952 416841 576685 440569 654466 508830 495741 522608 490646 325863 563456 469824 478397 564902 546715 574498 563155 600464 414516 470716 492610 491996 387548 397436 388935 492361 401522 436827 473286 827932 466787 152276 302771 233027 397679 460632 384395 390981 94529 384888 565303 566867 563625 402065 474389 395784 397054 309283 577290 213627 806004 701302 385549 385908 191160 396958 400926 406070 479486 450125 498453 501690 501678 551209 542876 570595 571623 644160 780867 396215 460856 498104 525749 520919 819390 470784 426844 282481 394247 518795 396889 462980 476276 429145 181009 389355 248770 233102 401509 466042 382857 381913 418155 429193 427803 417272 424497 429216 454040 460173 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.43%) |
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 94529 152276 181009 191160 213627 233027 233102 248770 282481 302771 309283 325863 381913 382748 382857 384395 384888 385549 385908 387548 388935 389355 390592 390981 394247 395428 395784 396215 396889 396958 397054 397436 397679 398045 400926 401509 401522 402012 402065 406070 414516 416841 417272 418155 424497 426666 426844 427803 429145 429193 429216 431722 436827 440569 443053 450125 454040 454045 460173 460632 460856 462980 463220 466042 466787 468053 469824 470716 470784 470952 473286 474389 476276 478397 479486 486902 490646 491996 492361 492610 495741 498104 498453 501678 501690 508830 518795 520919 522555 522608 523484 525749 542876 546715 551209 563155 563456 563625 564902 565303 566867 570595 571623 574498 576685 577290 598018 600464 644160 654466 680616 681692 701302 774243 780867 800071 806004 812137 819390 827932 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кун и"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куннилингус оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 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.