SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429464 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429464 [ RunTime:0.001872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (833993,145119,212298,534391,714446,865525,587449,203008,987902,235484,372266,892800,97173,766206,859485,269484,425474,662493,1005516,659990,581672,214420,594983,449331,16415,76672,318013,290077,9388,898713,943279,700962,393720,778806,557739,89407,413368,611495,106866,297869,435745,261187,1019860,337451,338445,278870,1004266,264246,979519,131483,937083,851844,78960,324895,789631,291929,40283,681304,375749,736112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429464 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429464 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]