SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 910310 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 910310 [ RunTime:0.002101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252089,717019,848548,102000,740707,10952,816284,790725,771485,269542,552362,184996,818329,612232,695765,631353,207677,1022846,906234,89993,70220,955598,97499,149640,1036651,646189,429036,671135,828155,83589,447786,1036697,1003078,674151,370328,855622,433141,720145,445459,727442,715227,93495,137143,986335,654209,668622,191001,614450,1041356,622372,618052,114202,673659,1038002,535420,33068,715879,680650,252738,788918) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 910310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 910310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]