SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405989 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405989 [ RunTime:0.002246s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118977,121574,306798,258799,70212,15254,959450,1039995,502023,99354,87442,1047604,1008933,646824,338252,845076,323815,962611,725726,919157,306070,266414,264643,743899,855078,835881,361740,64861,291380,640593,666044,535596,976186,295893,177824,720092,870421,873336,997901,408336,288457,553822,980729,728446,67019,315157,538116,322520,350417,559445,971796,309748,409734,747677,54671,342001,896457,727811,242957,277431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405989 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405989 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]