Query Metrics
7
Database Queries
7
Different statements
241.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.42 ms (87.11%) |
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 397364 397530 400249 401318 401933 404308 406592 407168 412145 412288 413901 416841 421000 421164 421353 425043 425802 426203 429409 430422 430444 430556 430630 431269 431352 434611 442946 445436 445934 447655 458719 461018 462465 462477 462702 464327 465371 466133 471628 473204 474147 475249 476909 476913 480367 481163 482350 482492 486198 486594 489979 490430 490944 492099 492106 492269 494516 494778 497356 497537 498039 505814 508860 510254 514647 515122 517301 518751 528401 530884 531943 531981 532129 533426 533541 534334 534394 535344 536370 542188 543519 550571 558904 560219 562894 563856 571680 581897 584488 586681 596515 599160 603364 604524 605496 609140 612868 621645 623641 629357 631179 633158 639258 643113 650419 650660 650849 674415 682545 688586 690124 691196 698933 712696 716220 717744 719326 799936 808526 815268 ] |
||||||||||||||||||||||||||||||
|
19.57 ms (8.10%) |
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 425043 462702 426203 480367 492099 497537 490430 494516 430630 397364 434611 489979 462465 534334 534394 530884 514647 558904 650419 690124 717744 674415 691196 650660 650849 623641 629357 633158 604524 643113 808526 612868 621645 719326 401933 404308 462477 400249 425802 465371 445934 447655 397530 442946 466133 528401 430422 416841 412288 815268 461018 476909 492269 536370 533541 563856 560219 682545 698933 688586 712696 716220 799936 412145 421353 482350 407168 421000 431352 406592 430556 476913 518751 505814 486198 482492 471628 481163 531943 543519 550571 581897 571680 584488 599160 631179 474147 473204 486594 494778 490944 497356 498039 508860 510254 429409 421164 445436 458719 492106 517301 531981 532129 533426 515122 535344 542188 562894 639258 605496 596515 609140 586681 603364 401318 464327 475249 431269 413901 430444 ] |
||||||||||||||||||||||||||||||
|
4.87 ms (2.02%) |
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 397364 397530 400249 401318 401933 404308 406592 407168 412145 412288 413901 416841 421000 421164 421353 425043 425802 426203 429409 430422 430444 430556 430630 431269 431352 434611 442946 445436 445934 447655 458719 461018 462465 462477 462702 464327 465371 466133 471628 473204 474147 475249 476909 476913 480367 481163 482350 482492 486198 486594 489979 490430 490944 492099 492106 492269 494516 494778 497356 497537 498039 505814 508860 510254 514647 515122 517301 518751 528401 530884 531943 531981 532129 533426 533541 534334 534394 535344 536370 542188 543519 550571 558904 560219 562894 563856 571680 581897 584488 586681 596515 599160 603364 604524 605496 609140 612868 621645 623641 629357 631179 633158 639258 643113 650419 650660 650849 674415 682545 688586 690124 691196 698933 712696 716220 717744 719326 799936 808526 815268 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old mom facesitting"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.66%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.65%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old mom фейсситтинг"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old mom фейсситтинг"
]
|
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.