SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508626 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508626 [ RunTime:0.002085s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324703,810443,954859,451411,265128,740807,848844,810331,206763,760971,989850,395333,680383,580123,820324,282003,218122,764132,566208,43128,318714,699521,772924,128369,409950,435474,912899,1045160,198062,517222,361638,286018,659346,83491,514091,199627,780848,647713,306582,602943,584075,636129,375822,181236,27719,217424,108961,997844,535838,1007066,235966,244358,140834,605824,297326,257539,398004,686248,646847,933074) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508626 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508626 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002765s ]