SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150038 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150038 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (824729,757865,560626,1008569,635833,214901,988077,189841,614533,162638,316656,932593,195081,60080,357186,761012,196115,838395,548366,584393,719605,524352,845954,169737,598665,1047243,379737,178690,83247,533167,252736,658162,953521,297492,274116,845446,609772,161820,21422,56535,572697,177005,384484,924724,201514,465048,836279,412913,404691,202278,614020,1016494,1008314,835560,71027,1009165,472367,764412,378562,84103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]