SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403966 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403966 [ RunTime:0.003108s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (726044,1035308,483486,630155,806329,546023,587874,508350,269204,12133,694516,1013140,319129,862961,925805,418190,936702,843492,152011,327482,584629,133251,333539,597129,744404,866703,287676,89932,252915,496321,250433,179370,494052,705361,431455,196868,458013,666202,929434,732163,816233,484199,576352,475566,849594,719666,557690,812622,851041,277961,524252,115394,458009,754294,284262,354850,607693,550103,582751,427971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403966 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403966 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]