SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539227 LIMIT 1 [ RunTime:0.000617s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539227 [ RunTime:0.003493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382363,866510,751812,789397,189809,1038178,690834,670228,35886,829404,468426,774347,873896,982441,785002,731236,943768,959082,59029,384271,875398,437739,1033698,624614,636570,254283,422926,135213,98853,101842,719956,1044710,497088,945052,471229,535528,452757,715278,687349,366154,1031478,258871,452973,149333,543053,766934,71606,518013,1008305,526946,209223,713591,73799,843563,677854,796442,44055,580159,571889,188201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539227 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000736s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539227 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000895s ]