SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981809 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981809 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002775,187674,437527,412886,159819,349375,74321,1024908,972969,88932,941912,921146,1028594,414274,152120,372103,986868,375726,83539,306357,395400,268512,11493,336886,47802,140165,436655,276928,319019,229604,503583,448842,546758,551328,285372,40494,416386,801476,693388,759137,411335,503788,429229,480008,876397,550394,650580,796704,129825,570907,300572,1022152,149317,931118,43557,631895,423880,593900,981425,206350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]