SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682840 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682840 [ RunTime:0.002166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721232,967566,687304,6650,518240,433000,26082,765011,361000,344598,403564,91199,1026144,654793,232718,444647,895089,303383,328350,335869,765603,206619,247746,107542,349762,777009,208194,963056,14242,961604,571607,349713,861686,792378,268600,975579,728668,454244,545251,49359,827539,805936,738359,292446,131794,99112,67418,459086,289644,501104,1044650,158163,828199,55160,181840,677502,523593,339551,257578,281728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000393s ]