SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403281 LIMIT 1 [ RunTime:0.003262s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403281 [ RunTime:0.003361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807844,112413,621170,152232,299689,94396,695886,234115,92980,392925,765905,1012024,526193,632474,492330,514029,882378,610949,634950,568918,298836,381133,802879,410062,159128,938252,1040982,917726,269655,8390,306274,436,736407,316032,885422,788158,939395,1005555,125604,428589,994692,510158,560015,492561,217250,869635,116088,873911,94682,366379,337534,552794,137209,640381,756449,608577,508014,131511,125603,201305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]