SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801718 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801718 [ RunTime:0.001932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (572852,716850,408674,619304,736791,102523,449793,50856,983151,411001,872946,851449,96631,133025,891801,585593,997074,977388,758067,6482,801990,616386,42916,864588,882336,18664,168820,72027,295026,340395,44138,735088,20515,261700,820829,63259,488153,646244,475570,980002,55005,33307,195028,388210,473827,624878,208742,219891,8234,355352,733196,386125,896145,558539,70752,804254,552173,355825,103579,400430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]