SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200831 LIMIT 1 [ RunTime:0.001408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200831 [ RunTime:0.006722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (995023,871589,1039360,337010,311880,900144,634402,336780,239598,1027754,181476,721845,29805,1033625,871661,886266,205278,386355,317666,210558,488301,681676,1014332,898682,310332,123687,736136,169680,88257,626396,179546,59710,366543,16270,435465,235038,289924,574710,778797,375963,917192,3268,850544,533176,888705,1011886,717699,620989,928898,742020,210913,637686,127356,570368,542093,264889,652884,369239,284011,655028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001774s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002174s ]