SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410943 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410943 [ RunTime:0.002102s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134657,1019098,585299,621477,866126,812467,593244,528308,720134,698292,289407,676237,831080,781896,630277,297091,403964,734189,645792,695870,550670,11913,610849,123436,133894,342847,265131,190222,523986,666064,286686,435205,674662,322422,70058,604718,747666,1005191,930994,849760,406908,895604,129581,896884,566081,132694,820484,339387,650964,799097,923478,601065,706930,634062,817688,901746,544797,860151,265802,15279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000709s ]