SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445343 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445343 [ RunTime:0.003072s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836224,371912,471172,350157,56152,260005,347905,759775,184346,788815,1041866,324312,181437,660925,494787,599382,133618,513121,725769,268992,1015370,922448,647158,677928,490709,572540,1008231,759754,536046,752308,74212,801282,12410,592494,238244,81271,782203,978183,693126,573845,603325,253551,825581,583257,494921,286986,919842,922637,319103,406154,533571,806364,813822,583201,643707,294316,344959,630610,521220,456800) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]