Query Metrics
7
Database Queries
7
Different statements
178.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.58 ms (83.69%) |
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 45136 191343 233426 233934 386638 391820 396303 397674 398005 401957 405528 407628 408206 408412 408765 409356 411689 412793 415906 423782 425538 427702 428385 432864 434215 438334 440818 441654 444266 446130 447530 448317 448518 449792 449950 451479 451573 453348 453445 454873 456171 459385 461478 461937 462192 462287 463218 464936 467426 467659 468283 469487 473647 474190 474447 475510 476300 476369 478712 479598 481088 482490 484546 485244 485247 485945 490945 491170 491717 493162 493415 493962 494317 495889 498305 499005 500013 502560 504028 504152 505718 509246 509254 509392 510990 514474 514688 516273 516538 519708 519726 526240 546608 548668 552695 554366 558020 559979 560416 560562 561675 563214 566409 567409 567733 573444 574851 575132 575745 576407 580389 580723 584395 584436 588710 629847 748206 772093 796084 809357 ] |
||||||||||||||||||||||||||||||
|
19.02 ms (10.64%) |
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 467659 474190 191343 233934 391820 409356 444266 451573 462192 485945 504028 505718 495889 493415 493962 509246 396303 398005 408765 412793 415906 425538 408206 432864 441654 411689 482490 448518 449792 449950 475510 453445 456171 476300 484546 498305 500013 499005 510990 494317 461937 463218 468283 485247 548668 575132 580389 558020 559979 560416 573444 576407 584395 546608 552695 560562 566409 567409 554366 561675 563214 567733 574851 575745 580723 584436 588710 748206 772093 629847 796084 809357 397674 401957 428385 453348 462287 469487 479598 45136 233426 423782 438334 446130 454873 459385 461478 476369 386638 407628 451479 467426 473647 474447 481088 427702 434215 440818 447530 478712 448317 509392 514474 514688 516273 519708 519726 485244 491170 502560 526240 490945 491717 493162 504152 509254 516538 405528 408412 464936 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.68%) |
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 45136 191343 233426 233934 386638 391820 396303 397674 398005 401957 405528 407628 408206 408412 408765 409356 411689 412793 415906 423782 425538 427702 428385 432864 434215 438334 440818 441654 444266 446130 447530 448317 448518 449792 449950 451479 451573 453348 453445 454873 456171 459385 461478 461937 462192 462287 463218 464936 467426 467659 468283 469487 473647 474190 474447 475510 476300 476369 478712 479598 481088 482490 484546 485244 485247 485945 490945 491170 491717 493162 493415 493962 494317 495889 498305 499005 500013 502560 504028 504152 505718 509246 509254 509392 510990 514474 514688 516273 516538 519708 519726 526240 546608 548668 552695 554366 558020 559979 560416 560562 561675 563214 566409 567409 567733 573444 574851 575132 575745 576407 580389 580723 584395 584436 588710 629847 748206 772093 796084 809357 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fucking a boy"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fucking парен"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fucking парен"
]
|
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.