SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40214 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40214 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (851432,196303,769243,611949,232632,1034697,874577,869248,918814,1048079,474531,384483,299979,235151,759014,81714,265924,972002,491720,112388,70130,849068,188188,756347,712558,844605,804061,845260,620251,166142,862959,655560,831969,221498,780960,992989,249160,819993,529431,529132,354751,824718,719193,926238,175408,991332,445656,784925,582204,176081,16157,1031124,920094,971014,783912,944644,379417,233737,447708,492368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002307s ]