Query Metrics
7
Database Queries
7
Different statements
138.82 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.54 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.81 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom is horny"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.95 ms |
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 481925 405541 451311 465312 506335 513785 518203 488772 516852 424305 416165 488378 489399 522785 513155 531416 520819 522673 472879 564716 581882 662653 646199 668528 681310 572259 586555 599921 624875 593534 599164 608353 591432 595667 598292 623883 636290 641455 810976 788262 805146 411854 424200 411751 426203 444165 425070 511827 524560 524979 527232 488011 514768 510042 515420 518170 523816 494329 509988 520815 521262 522604 404740 485462 482240 537203 556834 559845 576689 646229 601147 808526 809936 425214 404316 517844 483569 514973 517369 477890 596851 624201 599844 607707 629961 439767 505814 635215 454709 521446 486594 494778 540511 550100 582624 639334 424780 430444 562831 593499 453313 469409 479629 489112 502741 585725 ] |
||||||||||||||||||||||||||||||
| 4 | 2.47 ms |
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 404316 404740 405541 411751 411854 416165 424200 424305 424780 425070 425214 426203 430444 439767 444165 451311 453313 454709 465312 469409 472879 477890 479629 481925 482240 483569 485462 486594 488011 488378 488772 489112 489399 494329 494778 502741 505814 506335 509988 510042 511827 513155 513785 514768 514973 515420 516852 517369 517844 518170 518203 520815 520819 521262 521446 522604 522673 522785 523816 524560 524979 527232 531416 537203 540511 550100 556834 559845 562831 564716 572259 576689 581882 582624 585725 586555 591432 593499 593534 595667 596851 598292 599164 599844 599921 601147 607707 608353 623883 624201 624875 629961 635215 636290 639334 641455 646199 646229 662653 668528 681310 788262 805146 808526 809936 810976 ] |
||||||||||||||||||||||||||||||
| 5 | 114.83 ms |
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 404316 404740 405541 411751 411854 416165 424200 424305 424780 425070 425214 426203 430444 439767 444165 451311 453313 454709 465312 469409 472879 477890 479629 481925 482240 483569 485462 486594 488011 488378 488772 489112 489399 494329 494778 502741 505814 506335 509988 510042 511827 513155 513785 514768 514973 515420 516852 517369 517844 518170 518203 520815 520819 521262 521446 522604 522673 522785 523816 524560 524979 527232 531416 537203 540511 550100 556834 559845 562831 564716 572259 576689 581882 582624 585725 586555 591432 593499 593534 595667 596851 598292 599164 599844 599921 601147 607707 608353 623883 624201 624875 629961 635215 636290 639334 641455 646199 646229 662653 668528 681310 788262 805146 808526 809936 810976 ] |
||||||||||||||||||||||||||||||
| 6 | 1.58 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom horny"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.64 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom horny"
]
|
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.