SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023435 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023435 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (963878,375156,1044464,45043,422014,249578,780626,303358,764706,535204,1041648,995226,169097,979270,35991,279320,857942,671344,812528,1023507,457841,954372,494458,715717,505894,940902,399435,331925,549752,812650,514735,162017,405531,14493,588705,551415,876396,1010071,419264,947522,293553,123255,983055,323152,572154,483379,108755,912834,757978,738725,772054,3095,233284,58606,787316,128799,626881,266369,956585,917204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]