SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 177398 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 177398 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113954,684246,108369,619768,305127,982873,210525,46004,388580,939417,960607,270163,407410,342283,898613,564292,45419,358386,170793,780925,377947,135733,476631,206092,621371,1040330,641712,637738,728419,366985,346002,579058,250554,487417,13821,174315,500755,1045488,774993,41217,731717,70735,545641,198778,445242,154904,599335,820313,902399,144098,274829,482614,833393,814987,635319,613317,165033,324018,341928,449039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 177398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 177398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000750s ]