SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311518 LIMIT 1 [ RunTime:0.000524s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311518 [ RunTime:0.003627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810240,72360,343524,56987,801105,553169,328166,894805,1000003,949912,465309,470710,202357,265306,1047142,752981,207226,793946,43160,386558,124062,791227,859016,101138,324122,429324,57732,829252,48853,796393,1011451,223363,728003,15823,278301,108139,116392,916475,261448,770198,831606,467096,529414,975164,24834,24477,917122,850508,31625,218611,320404,941330,702086,394487,711613,609821,399167,104580,942442,865134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]