SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001878s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320186 LIMIT 1 [ RunTime:0.000592s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320186 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (11193,131325,1021260,18986,860415,73825,7659,823573,940220,446480,986268,563244,1042998,127249,38984,663598,68597,619813,883987,87556,509502,105137,26314,467536,157374,907775,655029,986385,653567,571116,840370,455826,522842,919260,213691,776138,902396,384370,748992,756431,1009837,338927,344981,1046126,1037931,599583,47292,921047,382501,492298,291666,94246,785977,823263,18380,89751,314410,607296,487799,301331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320186 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320186 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000807s ]