SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001827s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535697 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535697 [ RunTime:0.002172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447984,150080,439752,910615,373503,542925,761495,859219,841248,975824,588815,801547,702336,757978,1033277,583286,848510,1000207,380945,793575,457523,624379,689713,514530,148747,57922,168010,71309,1027220,538100,818450,144007,793384,78264,221126,842244,340558,189396,311376,725081,423602,143602,364829,914218,431982,663029,539271,776535,780343,299980,227382,790022,361643,412260,920765,904028,729643,843529,227749,812167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535697 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535697 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]