SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 306718 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 306718 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251736,704223,485956,647234,163029,120539,224640,579857,464469,305651,649936,559017,728229,284690,168894,873159,610032,995889,763957,637893,628122,220066,623291,649227,709570,190220,568234,843167,38081,216243,70805,372132,232915,962280,840256,296814,561446,874394,1024969,212598,581254,809258,437741,123363,174140,553359,344292,295707,1023017,364589,81805,427249,104067,877204,125156,440376,30395,396375,385043,455520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 306718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 306718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]