SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441680 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441680 [ RunTime:0.001396s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289080,111783,502892,643240,228211,319944,801585,940684,708436,679522,1047945,720219,183511,963063,240457,615382,569009,335850,640588,383186,763296,1022829,1002847,137244,761960,731267,87897,223617,301484,48151,29584,484888,506353,758620,897323,82911,884904,1007364,2889,349322,1028705,182686,69692,385184,473244,196896,255375,55848,518042,424401,680554,981138,468064,720168,476575,826854,93696,271289,345999,329590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001494s ]