Query Metrics
7
Database Queries
7
Different statements
182.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.38 ms (84.65%) |
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 129640 130289 154410 326134 360015 382355 383075 383439 383987 386596 389243 390413 395474 396560 396562 396708 397946 397960 398634 400270 400662 403141 404264 404342 404622 405045 405061 405178 405182 405848 406290 406304 408601 409828 410057 414666 415591 416787 416819 416820 417897 418478 419148 419483 419595 420139 420190 420768 421557 421564 422735 423654 423655 423708 425030 429763 429766 429770 429943 435624 445751 446331 447124 449011 449032 457163 457166 462742 464165 464171 465168 466858 468009 468694 468714 468849 471811 475262 477084 477531 478052 480417 480420 481602 481663 482793 482800 488897 489394 491255 491276 494365 494621 495126 495270 496724 496835 497743 497776 499668 500431 508910 510270 512453 512854 516655 516685 516818 519085 520425 521593 524193 525348 527443 527452 527659 529257 568328 583397 617420 ] |
||||||||||||||||||||||||||||||
|
18.21 ms (9.98%) |
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 496724 516818 468694 419148 423654 383075 383439 130289 395474 326134 389243 396708 396560 397946 404264 403141 405848 405178 425030 410057 414666 415591 419595 423708 482793 465168 457166 464165 464171 449011 477084 478052 481663 495126 494365 521593 516655 462742 583397 360015 446331 468849 480417 405045 471811 477531 386596 396562 405182 406290 400270 468714 500431 516685 527443 497743 489394 491255 499668 508910 488897 494621 519085 527452 529257 429770 449032 445751 617420 383987 129640 397960 400662 406304 416787 418478 422735 416820 435624 423655 429763 429766 421557 466858 475262 468009 481602 382355 404342 480420 390413 409828 419483 447124 405061 417897 512453 527659 496835 512854 524193 525348 491276 495270 497776 510270 520425 568328 154410 398634 404622 408601 420190 421564 420768 420139 429943 416819 482800 457163 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.53%) |
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 129640 130289 154410 326134 360015 382355 383075 383439 383987 386596 389243 390413 395474 396560 396562 396708 397946 397960 398634 400270 400662 403141 404264 404342 404622 405045 405061 405178 405182 405848 406290 406304 408601 409828 410057 414666 415591 416787 416819 416820 417897 418478 419148 419483 419595 420139 420190 420768 421557 421564 422735 423654 423655 423708 425030 429763 429766 429770 429943 435624 445751 446331 447124 449011 449032 457163 457166 462742 464165 464171 465168 466858 468009 468694 468714 468849 471811 475262 477084 477531 478052 480417 480420 481602 481663 482793 482800 488897 489394 491255 491276 494365 494621 495126 495270 496724 496835 497743 497776 499668 500431 508910 510270 512453 512854 516655 516685 516818 519085 520425 521593 524193 525348 527443 527452 527659 529257 568328 583397 617420 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"негр жестко"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чернокожий хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.89%) |
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.