SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454992 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454992 [ RunTime:0.001612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812465,916575,460028,1015169,932030,726964,474469,751933,647001,629651,1045143,501539,1016634,722000,720256,159344,634284,669871,431154,49499,683828,616022,392774,548283,619204,666783,159319,658539,754624,935619,383604,976981,371325,663500,847523,761085,573168,780085,8828,1015340,930568,1042926,518380,193634,780918,591799,812438,796072,243975,515893,209712,666460,109595,770898,500095,803639,694504,1003061,492857,890912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001607s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454992 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454992 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000714s ]