Query Metrics
7
Database Queries
7
Different statements
185.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.60 ms (86.93%) |
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 23670 69956 185049 185456 185563 205205 350951 357786 357886 359054 382206 382357 383029 383480 383778 383906 384073 386725 386953 387835 388022 389346 390219 390278 390698 390950 393848 395513 402596 403236 404644 404817 408150 409125 410026 420341 425430 431080 435688 446248 448945 462747 480368 494086 503761 503811 510049 513779 519887 525251 526826 526834 527065 539750 545774 551434 554375 559851 566671 583213 590747 610142 610185 610262 613854 615710 620319 622702 624269 625008 625036 628045 628344 636032 643111 643784 643888 661398 663038 663061 663690 664889 666225 666308 667306 667309 669136 669806 669833 670162 690147 701492 707360 713404 716318 716346 721448 726716 732431 738838 738894 738960 741211 742897 744467 749284 754193 759772 771700 776257 784897 793489 795298 796026 799756 801072 803160 803170 806361 811760 ] |
||||||||||||||||||||||||||||||
|
13.71 ms (7.37%) |
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 462747 446248 738838 404644 425430 526834 69956 796026 390950 620319 395513 480368 503761 513779 527065 431080 628045 386953 389346 404817 625008 806361 185049 390278 771700 803170 382357 643111 383480 357786 383778 622702 185456 741211 554375 666308 732431 350951 359054 382206 707360 387835 510049 624269 628344 545774 801072 386725 664889 667309 669806 784897 539750 625036 393848 388022 610142 23670 402596 610262 669833 721448 590747 526826 383906 811760 583213 738894 749284 716318 795298 669136 448945 690147 357886 551434 666225 185563 403236 384073 494086 643888 738960 701492 742897 409125 663038 410026 793489 744467 726716 566671 663690 670162 613854 754193 799756 383029 661398 776257 615710 390219 519887 713404 559851 636032 420341 390698 435688 205205 408150 716346 759772 803160 525251 663061 667306 643784 610185 503811 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (1.71%) |
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 23670 69956 185049 185456 185563 205205 350951 357786 357886 359054 382206 382357 383029 383480 383778 383906 384073 386725 386953 387835 388022 389346 390219 390278 390698 390950 393848 395513 402596 403236 404644 404817 408150 409125 410026 420341 425430 431080 435688 446248 448945 462747 480368 494086 503761 503811 510049 513779 519887 525251 526826 526834 527065 539750 545774 551434 554375 559851 566671 583213 590747 610142 610185 610262 613854 615710 620319 622702 624269 625008 625036 628045 628344 636032 643111 643784 643888 661398 663038 663061 663690 664889 666225 666308 667306 667309 669136 669806 669833 670162 690147 701492 707360 713404 716318 716346 721448 726716 732431 738838 738894 738960 741211 742897 744467 749284 754193 759772 771700 776257 784897 793489 795298 796026 799756 801072 803160 803170 806361 811760 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage big tits"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.84%) |
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.