SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001483s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467510 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467510 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671185,1004233,917831,839867,680238,639190,1046367,60958,442358,383240,549802,272769,563351,886083,389549,686456,103187,218719,258507,667773,584075,111614,921124,841886,597765,570933,779978,661279,891971,809377,266876,91769,701375,650416,1023358,68618,187600,556618,200778,655345,66286,1037290,991181,59127,778538,136811,62618,517658,618312,424151,506181,372840,387981,237499,223459,89659,698604,316000,595815,884494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]