Query Metrics
7
Database Queries
7
Different statements
364.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.85 ms (58.69%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин трет вагин"
]
|
||||||||||||||||||||||||||||||
|
121.83 ms (33.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 423998 442830 452092 452097 452983 461169 463034 464084 466927 468826 469137 470441 472941 478651 478950 489278 493219 496182 498014 498816 500069 500477 500531 505132 507310 508283 510843 513832 514843 516093 516752 516763 516764 519242 520890 521453 521849 523160 524873 527123 528416 528562 528838 530062 530741 531413 531437 531441 531466 532022 533534 533915 534320 534616 536790 537487 540346 541408 542148 543198 548213 550960 554182 556025 558413 559106 565975 567141 569043 570725 578300 578531 578803 582234 583037 583049 586494 587220 588296 590887 591739 595766 602631 602811 603004 603255 603364 603831 604901 605902 607049 609203 610686 612125 614515 614720 618381 619007 622252 623261 625262 626337 626347 645918 664591 680267 685465 688042 717179 ] |
||||||||||||||||||||||||||||||
|
19.84 ms (5.45%) |
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 516763 626337 533534 534320 516752 532022 570725 664591 540346 685465 688042 565975 602631 604901 452092 478651 556025 578531 531413 423998 469137 530062 520890 514843 527123 583037 603004 496182 623261 489278 508283 536790 528562 478950 548213 569043 583049 578803 680267 717179 609203 625262 605902 500069 507310 521849 559106 590887 622252 586494 587220 516764 531466 531437 550960 464084 531441 582234 578300 607049 614720 505132 498816 463034 461169 493219 452983 466927 603364 541408 618381 528416 510843 524873 588296 516093 626347 472941 554182 468826 513832 528838 534616 602811 442830 645918 452097 558413 612125 498014 523160 500531 530741 603831 591739 543198 519242 595766 542148 500477 610686 533915 537487 619007 470441 614515 567141 603255 521453 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (0.82%) |
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 423998 442830 452092 452097 452983 461169 463034 464084 466927 468826 469137 470441 472941 478651 478950 489278 493219 496182 498014 498816 500069 500477 500531 505132 507310 508283 510843 513832 514843 516093 516752 516763 516764 519242 520890 521453 521849 523160 524873 527123 528416 528562 528838 530062 530741 531413 531437 531441 531466 532022 533534 533915 534320 534616 536790 537487 540346 541408 542148 543198 548213 550960 554182 556025 558413 559106 565975 567141 569043 570725 578300 578531 578803 582234 583037 583049 586494 587220 588296 590887 591739 595766 602631 602811 603004 603255 603364 603831 604901 605902 607049 609203 610686 612125 614515 614720 618381 619007 622252 623261 625262 626337 626347 645918 664591 680267 685465 688042 717179 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мама трется пиздой"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин трет вагин"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.