SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103482 LIMIT 1 [ RunTime:0.000843s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103482 [ RunTime:0.003892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313437,880471,525736,593409,756296,190214,12961,609281,885755,58200,1031725,26826,291622,295088,178797,242065,1037315,700057,258275,909120,163790,516475,255509,340151,970301,236912,445103,864757,112958,782663,690820,936895,658564,513714,828998,256307,317083,491626,7568,552851,803232,314042,349281,495151,906817,793187,657744,916996,743807,767933,529072,648499,460968,439831,757723,548991,705806,222332,453648,505682) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000651s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000845s ]