SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104800 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104800 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599592,720070,880388,769433,328608,788161,515917,365317,136200,626875,756753,689885,470712,179548,215676,878987,527353,250903,188100,330725,1031924,899406,569235,917291,564368,934726,1043632,731185,843736,524685,214365,309770,344808,905261,540042,43626,300422,195629,639827,1042455,870131,491337,849162,683004,49318,737331,851659,577796,676031,536286,911010,582897,599435,28204,958563,645798,2550,92728,243929,335177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001151s ]