Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

[
  "asian slave"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'asian slave' LIMIT 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  497425
  497392
  478032
  560198
  499481
  506804
  543874
  623616
  423291
  458287
  524038
  540195
  584860
  584971
  550747
  787950
  421520
  458100
  429660
  422515
  422688
  511809
  423400
  527121
  419840
  438878
  497962
  527116
  532483
  485074
  513230
  512176
  536214
  519903
  498119
  490785
  532500
  546777
  591550
  597244
  422567
  525079
  528356
  413044
  382834
  538270
  428293
  663537
  427851
  526168
  556421
  566047
  622990
  423267
  412583
  533538
  536340
  528713
  529184
  519908
  427278
  497422
  537199
  546786
  560217
  541848
  421249
  435711
  559183
  460969
  427174
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.post_id IN (497425, 497392, 478032, 560198, 499481, 506804, 543874, 623616, 423291, 458287, 524038, 540195, 584860, 584971, 550747, 787950, 421520, 458100, 429660, 422515, 422688, 511809, 423400, 527121, 419840, 438878, 497962, 527116, 532483, 485074, 513230, 512176, 536214, 519903, 498119, 490785, 532500, 546777, 591550, 597244, 422567, 525079, 528356, 413044, 382834, 538270, 428293, 663537, 427851, 526168, 556421, 566047, 622990, 423267, 412583, 533538, 536340, 528713, 529184, 519908, 427278, 497422, 537199, 546786, 560217, 541848, 421249, 435711, 559183, 460969, 427174);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  382834
  412583
  413044
  419840
  421249
  421520
  422515
  422567
  422688
  423267
  423291
  423400
  427174
  427278
  427851
  428293
  429660
  435711
  438878
  458100
  458287
  460969
  478032
  485074
  490785
  497392
  497422
  497425
  497962
  498119
  499481
  506804
  511809
  512176
  513230
  519903
  519908
  524038
  525079
  526168
  527116
  527121
  528356
  528713
  529184
  532483
  532500
  533538
  536214
  536340
  537199
  538270
  540195
  541848
  543874
  546777
  546786
  550747
  556421
  559183
  560198
  560217
  566047
  584860
  584971
  591550
  597244
  622990
  623616
  663537
  787950
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (382834, 412583, 413044, 419840, 421249, 421520, 422515, 422567, 422688, 423267, 423291, 423400, 427174, 427278, 427851, 428293, 429660, 435711, 438878, 458100, 458287, 460969, 478032, 485074, 490785, 497392, 497422, 497425, 497962, 498119, 499481, 506804, 511809, 512176, 513230, 519903, 519908, 524038, 525079, 526168, 527116, 527121, 528356, 528713, 529184, 532483, 532500, 533538, 536214, 536340, 537199, 538270, 540195, 541848, 543874, 546777, 546786, 550747, 556421, 559183, 560198, 560217, 566047, 584860, 584971, 591550, 597244, 622990, 623616, 663537, 787950);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  382834
  412583
  413044
  419840
  421249
  421520
  422515
  422567
  422688
  423267
  423291
  423400
  427174
  427278
  427851
  428293
  429660
  435711
  438878
  458100
  458287
  460969
  478032
  485074
  490785
  497392
  497422
  497425
  497962
  498119
  499481
  506804
  511809
  512176
  513230
  519903
  519908
  524038
  525079
  526168
  527116
  527121
  528356
  528713
  529184
  532483
  532500
  533538
  536214
  536340
  537199
  538270
  540195
  541848
  543874
  546777
  546786
  550747
  556421
  559183
  560198
  560217
  566047
  584860
  584971
  591550
  597244
  622990
  623616
  663537
  787950
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (382834, 412583, 413044, 419840, 421249, 421520, 422515, 422567, 422688, 423267, 423291, 423400, 427174, 427278, 427851, 428293, 429660, 435711, 438878, 458100, 458287, 460969, 478032, 485074, 490785, 497392, 497422, 497425, 497962, 498119, 499481, 506804, 511809, 512176, 513230, 519903, 519908, 524038, 525079, 526168, 527116, 527121, 528356, 528713, 529184, 532483, 532500, 533538, 536214, 536340, 537199, 538270, 540195, 541848, 543874, 546777, 546786, 550747, 556421, 559183, 560198, 560217, 566047, 584860, 584971, 591550, 597244, 622990, 623616, 663537, 787950);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "азиатк доминирован"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'азиатк доминирован';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "азиатк доминирован"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'азиатк доминирован';