SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199582 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199582 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78018,528225,246623,796133,874748,55529,595074,968061,794154,140158,968055,528423,998949,251096,743788,140368,832213,213545,738914,883562,561593,607140,836921,909681,88495,15615,239555,710298,951437,469507,949440,442291,348425,92119,381160,671497,800107,614593,870923,322336,574213,670377,255022,650158,642806,387697,103892,191847,1014465,101557,888787,465009,828185,674802,660933,10237,1010030,26733,951785,944130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000372s ]