SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001736s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416823 LIMIT 1 [ RunTime:0.004239s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416823 [ RunTime:0.002824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215870,739257,750025,909248,754611,935764,184075,82309,766824,383995,1812,288761,747874,615191,720531,739092,618660,274276,1002200,352256,785174,1014706,316223,605971,874570,258276,961301,260874,551049,146853,836987,709921,499087,71493,515418,600275,199421,6363,213129,776411,130368,432607,593864,828249,198946,282590,487844,528001,500046,83341,777944,773990,776478,372442,423212,594565,749244,455483,557273,732065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000657s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002530s ]