SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 254689 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 254689 [ RunTime:0.003323s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (218845,327101,580711,601093,286122,905648,449135,121625,330103,134311,65994,757686,819397,627192,2135,237026,14305,375406,695786,990084,708501,507549,820951,288607,294622,308269,644521,835503,176704,240909,604100,576942,649508,854833,51516,185152,497702,342978,324577,252002,228298,546965,256656,77943,482410,128667,14009,404959,98935,993239,583069,230394,782733,339453,532537,998247,132648,773161,639914,245109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 254689 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 254689 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]