SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418437 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418437 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909610,328918,112445,138398,315881,602844,686504,996948,309460,650233,560092,389498,29188,127092,353216,125513,378969,806486,653923,256917,288298,507283,296438,525764,576494,78203,112809,388451,130756,752409,558363,36369,30609,233610,914567,923111,1022363,471425,331698,849307,68153,1000839,161435,415848,689490,360728,325871,455783,584457,137930,172402,666426,111739,311445,1001143,315264,790604,489606,495707,228294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418437 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418437 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]