SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003935s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196401 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196401 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404607,622657,551840,1021100,593305,967118,462890,499954,711635,277166,484303,597380,657682,808933,223428,926752,779714,1014033,377838,742158,12298,588631,1044517,799670,83325,85722,613451,204318,946464,896821,245972,230115,541868,203739,531098,942080,513859,153793,920328,426961,531628,181390,260627,42537,78669,964038,949048,881602,821611,907542,440589,110876,827291,1010352,122231,103549,674684,990374,1003965,391082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]