SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020324 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020324 [ RunTime:0.005194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (717535,442400,62016,1020185,941321,152104,964019,763427,82028,86144,271597,661317,251782,210488,285951,588286,31622,1041167,551274,705478,727395,273561,86089,412239,954465,933117,391650,407311,741203,1036020,915848,1006877,3204,551065,484614,844693,164328,447887,326281,719805,911189,511694,117013,751306,32954,903707,1005296,186794,299931,453078,1021349,951648,27981,1005757,520884,1006795,258999,86419,452916,282585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020324 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020324 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001158s ]