SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341397 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341397 [ RunTime:0.001579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937782,926944,662555,984207,867735,692325,689204,103835,792990,839411,872484,989571,356612,754026,674465,207853,16912,1017534,379427,447471,48665,953962,741085,58049,598051,619149,334955,530977,950140,443449,741808,938204,841987,914180,282370,47859,887401,876332,363632,1041787,529331,502672,70031,238755,998417,37391,345048,247170,1000801,1046295,476387,1040212,732646,370998,209480,43693,921624,791459,407613,987871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000897s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341397 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341397 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]