SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413838 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413838 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539704,648004,671300,928875,764074,8716,960228,605378,130630,443065,803686,230508,789186,363981,125891,1027940,678180,105387,754822,912774,76713,818411,10617,255862,75116,230752,819459,705048,520456,318715,284547,491466,914265,999393,1044685,410920,576035,182733,109005,1047251,259380,874187,185522,886801,668778,881761,970013,942054,296034,256855,430183,672271,729747,1011145,778311,768765,57850,322477,509829,340289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]