Query Metrics
7
Database Queries
7
Different statements
190.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.00 ms (84.44%) |
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 383902 390831 395267 398681 400638 401762 402546 404320 407777 410060 415958 416568 416701 417898 418101 419933 420480 421109 424195 425462 425712 425816 428117 428535 433042 434346 434908 438851 439194 439230 442430 444702 445081 446577 447573 447936 449970 451560 452410 457174 457650 457955 460328 461271 462994 463446 464128 464314 466719 466878 467699 468747 471676 471772 473851 475232 476776 477502 477687 482138 482761 483687 483762 487519 489217 489971 494964 495038 497452 498226 501273 502281 502328 503990 504997 505250 506024 507290 508451 509265 510205 511721 512102 512694 514273 515568 518185 519173 519706 520813 521682 521998 524385 527904 529209 536931 543304 545614 549261 549860 558127 559617 561478 578496 580672 590057 590493 592188 595013 597528 599370 602009 602296 603810 613268 617423 620098 633466 662445 762569 ] |
||||||||||||||||||||||||||||||
|
20.16 ms (10.57%) |
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 477502 507290 466719 467699 468747 477687 483762 578496 590057 595013 424195 425712 457955 416568 416701 425462 425816 398681 447936 428535 509265 512102 518185 524385 505250 519173 529209 487519 512694 527904 419933 438851 543304 662445 558127 401762 420480 415958 449970 457174 457650 464128 471676 504997 502281 580672 762569 602296 434346 442430 434908 476776 433042 439230 452410 463446 471772 514273 520813 521682 536931 483687 494964 501273 519706 633466 498226 515568 617423 502328 592188 603810 613268 599370 495038 561478 549860 620098 497452 407777 489217 451560 400638 402546 559617 597528 390831 489971 404320 461271 475232 395267 545614 590493 508451 421109 460328 482138 503990 549261 383902 511721 521998 418101 444702 445081 466878 473851 482761 462994 464314 510205 506024 602009 410060 428117 446577 417898 439194 447573 ] |
||||||||||||||||||||||||||||||
|
2.92 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 383902 390831 395267 398681 400638 401762 402546 404320 407777 410060 415958 416568 416701 417898 418101 419933 420480 421109 424195 425462 425712 425816 428117 428535 433042 434346 434908 438851 439194 439230 442430 444702 445081 446577 447573 447936 449970 451560 452410 457174 457650 457955 460328 461271 462994 463446 464128 464314 466719 466878 467699 468747 471676 471772 473851 475232 476776 477502 477687 482138 482761 483687 483762 487519 489217 489971 494964 495038 497452 498226 501273 502281 502328 503990 504997 505250 506024 507290 508451 509265 510205 511721 512102 512694 514273 515568 518185 519173 519706 520813 521682 521998 524385 527904 529209 536931 543304 545614 549261 549860 558127 559617 561478 578496 580672 590057 590493 592188 595013 597528 599370 602009 602296 603810 613268 617423 620098 633466 662445 762569 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"огромные секс бабы"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные секс женскийрод"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.69%) |
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.