Query Metrics
7
Database Queries
7
Different statements
149.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.29 ms (79.91%) |
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 307654 395547 396877 399088 399874 410936 419034 421394 422617 424675 428664 429427 444885 446713 447462 450885 451710 452916 457840 458645 459381 463153 463370 464842 466702 467972 468122 468975 469576 471991 472251 473004 473472 473748 475796 477182 479330 479333 481154 481485 481612 481635 482087 485998 487877 489640 491294 492026 492374 492389 495691 497581 502648 503151 503914 506437 509341 509969 509970 511076 511454 515152 515193 515812 516744 516903 518296 519081 519721 520025 520600 522597 522647 523918 524162 525432 526006 527124 528263 529501 535521 538251 540902 540914 542218 546978 549176 552217 552344 553032 557205 557848 557853 558543 561985 563742 567087 570076 572888 574504 575731 579098 579592 579935 580153 582352 582481 586263 586426 586517 589571 606652 607388 611001 623162 678769 683598 720056 811440 825812 ] |
||||||||||||||||||||||||||||||
|
18.99 ms (12.72%) |
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 511076 399088 473748 451710 457840 458645 472251 468122 546978 574504 582481 586263 586517 479333 479330 540902 487877 491294 466702 535521 567087 580153 582352 586426 606652 463370 477182 450885 523918 519081 497581 506437 481635 572888 557853 811440 428664 516903 520025 307654 444885 473004 515193 678769 683598 481154 447462 503914 482087 520600 518296 522597 419034 579935 471991 464842 540914 489640 495691 446713 463153 481485 485998 575731 481612 429427 528263 511454 519721 538251 492389 557205 557848 459381 524162 492026 526006 529501 509969 422617 396877 399874 395547 421394 553032 611001 468975 503151 589571 509970 825812 492374 561985 509341 579098 515812 522647 515152 469576 720056 467972 410936 542218 552344 552217 558543 570076 424675 563742 525432 473472 475796 549176 607388 502648 452916 623162 516744 527124 579592 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (2.08%) |
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 307654 395547 396877 399088 399874 410936 419034 421394 422617 424675 428664 429427 444885 446713 447462 450885 451710 452916 457840 458645 459381 463153 463370 464842 466702 467972 468122 468975 469576 471991 472251 473004 473472 473748 475796 477182 479330 479333 481154 481485 481612 481635 482087 485998 487877 489640 491294 492026 492374 492389 495691 497581 502648 503151 503914 506437 509341 509969 509970 511076 511454 515152 515193 515812 516744 516903 518296 519081 519721 520025 520600 522597 522647 523918 524162 525432 526006 527124 528263 529501 535521 538251 540902 540914 542218 546978 549176 552217 552344 553032 557205 557848 557853 558543 561985 563742 567087 570076 572888 574504 575731 579098 579592 579935 580153 582352 582481 586263 586426 586517 589571 606652 607388 611001 623162 678769 683598 720056 811440 825812 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl with glasses"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк очкастая"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.