SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403681 LIMIT 1 [ RunTime:0.000562s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403681 [ RunTime:0.003071s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190684,592565,302103,716547,832063,516606,354711,855738,365541,633356,683155,740504,314823,903343,658421,28036,701312,430654,686551,846282,720376,290741,923177,131430,281994,508487,756284,520390,14410,615991,558080,788351,204236,313170,722449,146001,701345,47023,384781,1029939,27272,175313,916016,561036,778024,521916,591932,492303,406527,1006580,1024622,473756,147464,160463,509004,1038963,632621,342292,1015587,726230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001655s ]