SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413989 LIMIT 1 [ RunTime:0.000612s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413989 [ RunTime:0.004171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399320,567737,21152,562523,14081,837580,324168,645767,468651,463100,134294,722674,13749,937690,122357,552739,857794,969110,727925,988220,233172,580769,227706,25706,477466,239202,423411,774875,919672,164246,165948,327900,28828,768167,126762,989345,61618,446937,16978,131905,773640,745149,209035,764603,318120,618783,1031988,265765,162346,556929,874333,1009839,953154,153344,373239,621659,368639,933431,808012,491389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413989 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413989 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001562s ]