Query Metrics
7
Database Queries
7
Different statements
202.91 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.51 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.14 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мамки 30 анал"
]
|
||||||||||||||||||||||||||||||
| 3 | 17.45 ms |
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 487338 445436 382255 819506 476262 667644 705325 798680 810828 803459 784307 419531 408245 386189 411615 500938 469595 607230 395818 466801 474095 488373 424455 465892 480392 408138 521149 424460 424458 466229 454658 439699 439457 474681 421327 815959 452579 682145 441001 439628 796079 400852 470166 466063 466242 531070 816784 826246 482299 554321 801319 789733 737152 421995 484739 466221 400807 472148 474652 470196 465075 428837 801165 724906 392076 825143 469489 486445 476588 665414 412288 439641 439565 535022 422171 478832 486346 187800 720197 490822 387905 466011 416982 413901 639718 758535 401933 404698 483147 470254 439607 449428 474678 493221 484585 484704 486341 497921 407650 428827 425990 412262 517052 717852 712694 784152 405012 398545 409312 476348 466986 718576 563127 591046 728446 472905 405830 526745 388722 479765 ] |
||||||||||||||||||||||||||||||
| 4 | 3.12 ms |
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 187800 382255 386189 387905 388722 392076 395818 398545 400807 400852 401933 404698 405012 405830 407650 408138 408245 409312 411615 412262 412288 413901 416982 419531 421327 421995 422171 424455 424458 424460 425990 428827 428837 439457 439565 439607 439628 439641 439699 441001 445436 449428 452579 454658 465075 465892 466011 466063 466221 466229 466242 466801 466986 469489 469595 470166 470196 470254 472148 472905 474095 474652 474678 474681 476262 476348 476588 478832 479765 480392 482299 483147 484585 484704 484739 486341 486346 486445 487338 488373 490822 493221 497921 500938 517052 521149 526745 531070 535022 554321 563127 591046 607230 639718 665414 667644 682145 705325 712694 717852 718576 720197 724906 728446 737152 758535 784152 784307 789733 796079 798680 801165 801319 803459 810828 815959 816784 819506 825143 826246 ] |
||||||||||||||||||||||||||||||
| 5 | 175.17 ms |
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 187800 382255 386189 387905 388722 392076 395818 398545 400807 400852 401933 404698 405012 405830 407650 408138 408245 409312 411615 412262 412288 413901 416982 419531 421327 421995 422171 424455 424458 424460 425990 428827 428837 439457 439565 439607 439628 439641 439699 441001 445436 449428 452579 454658 465075 465892 466011 466063 466221 466229 466242 466801 466986 469489 469595 470166 470196 470254 472148 472905 474095 474652 474678 474681 476262 476348 476588 478832 479765 480392 482299 483147 484585 484704 484739 486341 486346 486445 487338 488373 490822 493221 497921 500938 517052 521149 526745 531070 535022 554321 563127 591046 607230 639718 665414 667644 682145 705325 712694 717852 718576 720197 724906 728446 737152 758535 784152 784307 789733 796079 798680 801165 801319 803459 810828 815959 816784 819506 825143 826246 ] |
||||||||||||||||||||||||||||||
| 6 | 1.92 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин 30 анал"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.60 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин 30 анал"
]
|
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.