SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 838415 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 838415 [ RunTime:0.002193s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415098,116438,73836,628682,749916,989190,542488,270240,174166,538749,302183,918278,1046535,586718,976709,701441,171169,865335,851227,92515,726489,1008315,306806,770043,697809,838881,216352,534066,321248,588114,772515,789720,683546,171181,12858,702511,428492,886208,636372,625287,415548,997593,861980,803918,712118,424554,705407,645386,745907,707666,14037,972708,999223,521048,501504,758136,300449,334037,668439,497314) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 838415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 838415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]