SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681456 LIMIT 1 [ RunTime:0.000509s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681456 [ RunTime:0.003878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (944295,418812,182119,493332,981058,277019,593157,936173,637076,831482,1038450,844181,940716,581983,914152,391615,937251,1032448,739173,445951,1028853,417490,22346,810012,546360,275584,268768,766792,13442,630179,283436,835076,633,366143,861362,705032,680325,42589,462163,1030657,684354,1009430,417228,217031,950866,81303,314624,531028,657563,671389,205007,236001,628270,639907,542247,363303,251655,481564,189157,596961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681456 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681456 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000746s ]