SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101698 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101698 [ RunTime:0.001914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148584,629372,316254,5938,482729,102897,831893,248258,142783,107040,827544,832881,251308,440101,935293,405927,961351,148699,550965,12392,343009,771084,826280,371664,502222,1001426,393037,89219,60559,125530,660667,630004,661471,69188,54456,448341,435422,289246,159047,588777,152486,618238,14417,509417,701535,909640,721871,14442,905066,972398,945743,559209,703678,758206,1025570,708142,592701,1000404,441460,169713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]