SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418250 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418250 [ RunTime:0.002737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286692,207421,971429,543612,150003,215214,266994,44428,758468,239746,351717,602846,221581,428933,948217,1036952,537266,918210,328997,546794,404960,347451,421162,261794,483890,298504,904691,296858,807657,59979,625099,33108,291225,607894,325558,408107,465442,936493,89858,484080,711272,489673,108167,352330,404298,1044374,965561,341817,332161,762432,157780,611957,819883,964489,854703,102003,641477,927429,710060,766082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418250 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000699s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418250 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]