SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002727s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197309 LIMIT 1 [ RunTime:0.005498s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197309 [ RunTime:0.004245s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141190,319581,444797,795418,1015086,74480,983910,874928,1021602,963021,284143,38680,309260,706340,1048474,285794,803821,662252,370153,998160,236611,792571,461843,345501,398248,321300,281304,775786,145531,696811,484934,239148,476680,680589,9195,9883,912263,74379,268080,929541,876566,173729,6405,298071,325654,780018,985147,453009,475832,445049,760290,349816,230721,897238,110020,527736,43890,965095,95151,1017015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000769s ]