SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529328 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529328 [ RunTime:0.001964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (625330,775576,414083,1023393,524388,261969,435848,834917,534589,977472,575075,791611,437844,249854,723711,964111,456120,281151,362179,530888,182353,554164,198407,205439,258626,370998,943765,986461,636648,28647,693810,1021983,424691,859873,407791,471791,130112,453953,509901,572692,479121,533928,728717,379378,787079,576592,676408,783621,429309,258126,610007,436553,323568,81964,448829,432740,477427,410289,725517,886952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]