SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398995 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398995 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541973,393715,42015,104423,921833,477902,273987,489335,22777,392311,472196,743323,35876,317813,278085,696411,898350,521939,73511,814305,911926,370174,124471,283046,1019087,750260,276603,544553,735573,189290,68342,769912,888051,856863,70827,122431,692739,557008,181720,184298,973520,423254,525204,606577,393297,958041,538383,452991,751038,341797,1023798,1043056,57085,487902,243150,150455,133348,307936,186329,368372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398995 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398995 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]