Query Metrics
7
Database Queries
7
Different statements
162.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.17 ms (83.70%) |
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 6958 20617 38292 107216 129935 233187 265654 343350 343369 381963 383784 384098 385116 386698 388570 393558 398534 407171 409640 409692 416926 418450 419840 419847 421164 421249 423462 423962 429762 430574 433697 433883 434209 434838 436440 446090 448052 448078 449259 449320 449331 451631 453369 456363 456383 456387 456689 457797 464418 479044 479138 479162 479314 481173 482612 482616 484886 485020 485348 489074 490684 490903 499182 503121 506344 507780 509498 511155 516188 519238 519629 520172 521226 521228 521233 522925 523169 524873 525197 526344 527214 528334 528817 530345 535297 536637 537116 538891 540360 540363 541597 543012 544992 551055 556652 556657 560265 561107 570111 570851 587303 600252 619091 621424 624227 646964 650851 722510 722523 722544 723377 724324 745464 759482 784275 794472 801027 818812 820147 825255 ] |
||||||||||||||||||||||||||||||
|
15.28 ms (9.39%) |
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 434838 457797 511155 490903 383784 384098 343350 818812 825255 451631 456363 448078 506344 527214 538891 560265 541597 551055 722510 722523 722544 570851 621424 724324 801027 393558 398534 20617 385116 6958 38292 107216 430574 388570 479162 519238 485348 507780 536637 449320 481173 503121 418450 520172 544992 429762 453369 522925 523169 524873 561107 421164 650851 600252 386698 129935 343369 434209 409692 449259 464418 482612 482616 485020 537116 521233 528334 535297 540360 540363 516188 479314 489074 570111 556652 646964 587303 759482 745464 794472 381963 407171 265654 433697 521228 484886 233187 416926 419840 421249 419847 423462 820147 456387 456383 449331 456689 509498 521226 530345 543012 556657 723377 619091 784275 624227 409640 423962 479138 436440 448052 479044 446090 526344 490684 519629 525197 528817 499182 433883 ] |
||||||||||||||||||||||||||||||
|
3.73 ms (2.29%) |
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 6958 20617 38292 107216 129935 233187 265654 343350 343369 381963 383784 384098 385116 386698 388570 393558 398534 407171 409640 409692 416926 418450 419840 419847 421164 421249 423462 423962 429762 430574 433697 433883 434209 434838 436440 446090 448052 448078 449259 449320 449331 451631 453369 456363 456383 456387 456689 457797 464418 479044 479138 479162 479314 481173 482612 482616 484886 485020 485348 489074 490684 490903 499182 503121 506344 507780 509498 511155 516188 519238 519629 520172 521226 521228 521233 522925 523169 524873 525197 526344 527214 528334 528817 530345 535297 536637 537116 538891 540360 540363 541597 543012 544992 551055 556652 556657 560265 561107 570111 570851 587303 600252 619091 621424 624227 646964 650851 722510 722523 722544 723377 724324 745464 759482 784275 794472 801027 818812 820147 825255 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy licking slave"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy лиза доминирован"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy лиза доминирован"
]
|
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.