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` = 1409 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1409 [ RunTime:0.002466s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26875,77943,858221,979981,633308,466765,87534,565027,825319,270092,233824,723566,525746,745660,323811,481988,1044158,349006,230725,39077,829218,461938,382183,676569,837047,212639,110160,353122,755790,543381,701602,992120,418108,397888,855722,285153,1038385,1044979,454457,240615,787211,584351,361434,27100,937539,1043960,182309,948175,859981,249317,1007029,848171,347389,11445,430658,592761,850070,270929,216175,114362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]