Query Metrics
7
Database Queries
7
Different statements
161.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.47 ms (81.31%) |
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 9896 104990 203645 229024 233748 325777 365865 365901 366052 381952 385614 385832 386839 388315 389623 390195 391871 391890 391955 393726 395883 395898 397862 397896 397923 400708 410741 411419 417163 422420 422989 423750 424040 424145 424160 425275 426703 428053 444106 444814 447200 456569 459740 460721 462002 462007 465993 467218 467588 468519 468916 471603 472110 475177 475896 476458 476471 477596 479009 479030 481286 482833 487820 490310 491158 491192 492222 495858 498905 504161 509082 510503 511832 520293 527328 533648 555063 555096 555100 557787 569993 570006 571598 576307 577980 579124 589330 598451 600105 620226 620260 652247 658723 673204 675419 677339 681507 682654 686357 693380 700010 715424 737516 744340 746164 758974 762003 764864 766622 768451 769472 774855 778647 778701 782349 788833 790925 805650 810520 827825 ] |
||||||||||||||||||||||||||||||
|
20.92 ms (12.94%) |
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 509082 652247 589330 774855 782349 788833 744340 778647 805650 425275 104990 390195 422420 477596 385614 233748 400708 700010 447200 365901 388315 491158 366052 395898 481286 385832 482833 490310 762003 459740 468519 472110 9896 428053 417163 675419 677339 673204 600105 758974 764864 810520 769472 766622 424040 475896 203645 475177 391890 579124 426703 467588 681507 391871 462007 462002 393726 444814 471603 511832 492222 527328 491192 365865 391955 410741 397896 495858 827825 555063 571598 682654 715424 576307 598451 620260 778701 790925 737516 768451 325777 397923 468916 422989 381952 389623 411419 229024 386839 533648 557787 686357 620226 460721 397862 395883 424160 746164 570006 456569 423750 424145 479009 487820 498905 510503 504161 476458 555100 577980 465993 569993 479030 444106 476471 658723 467218 520293 555096 693380 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.62%) |
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 9896 104990 203645 229024 233748 325777 365865 365901 366052 381952 385614 385832 386839 388315 389623 390195 391871 391890 391955 393726 395883 395898 397862 397896 397923 400708 410741 411419 417163 422420 422989 423750 424040 424145 424160 425275 426703 428053 444106 444814 447200 456569 459740 460721 462002 462007 465993 467218 467588 468519 468916 471603 472110 475177 475896 476458 476471 477596 479009 479030 481286 482833 487820 490310 491158 491192 492222 495858 498905 504161 509082 510503 511832 520293 527328 533648 555063 555096 555100 557787 569993 570006 571598 576307 577980 579124 589330 598451 600105 620226 620260 652247 658723 673204 675419 677339 681507 682654 686357 693380 700010 715424 737516 744340 746164 758974 762003 764864 766622 768451 769472 774855 778647 778701 782349 788833 790925 805650 810520 827825 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"блондинки раком русск…"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая рак русск"
]
|
||||||||||||||||||||||||||||||
|
1.35 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.