SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586711 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586711 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229472,156540,520232,923835,431790,305701,239457,971438,793795,262038,134053,9988,1008761,76858,1019804,645148,602311,693321,345062,467616,878263,510776,481337,475378,207966,510329,322681,785951,124116,875527,816208,324288,199799,173069,803564,703879,145156,183678,840504,497346,412861,10953,378924,17671,772106,441619,698733,884348,1041263,324370,901871,967096,51036,235594,944871,66005,1039333,971847,334217,835162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]