SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001699 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001699 [ RunTime:0.003039s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180044,135292,390827,721769,771534,112318,392074,125579,385346,547594,963105,129188,624979,1036146,750024,961876,690297,790403,173310,725309,704692,919269,112412,986184,399826,220500,479962,511049,111875,110357,512236,480994,1001999,210107,950250,741489,541024,818122,237171,12711,48947,754886,76350,215523,923773,821435,716201,275275,527549,471995,272448,854791,639916,535489,456847,1006152,955772,859722,120375,629340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]