SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468275 LIMIT 1 [ RunTime:0.000507s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468275 [ RunTime:0.002112s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248462,56305,1015800,398283,294336,133590,389250,199368,303755,851670,672260,965934,461382,341933,288,324360,314535,153567,304171,861878,532210,188938,556986,540049,677068,778251,1033582,695163,37605,213850,988696,668026,781075,602386,35076,98430,385723,465229,230337,173086,167375,281857,1032402,483655,349480,767230,604240,96313,746260,757151,411994,637897,41726,116761,1045879,749422,49025,86535,458829,96984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468275 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468275 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]