SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193506 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193506 [ RunTime:0.004484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728039,43085,421449,774111,271874,579713,344994,740612,991812,22611,954213,794119,940365,260778,119201,142017,789460,1017191,132128,125921,843792,388601,111119,1012633,805554,248899,223372,815898,970802,666450,230438,527268,319239,192527,452547,487203,1044212,472841,168127,348900,118990,282266,827315,675941,297363,681303,434186,991039,650230,981176,622350,1001030,750991,1039866,171688,932738,48742,331087,541768,514660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]