SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200813 LIMIT 1 [ RunTime:0.001099s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200813 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39945,593144,861743,927035,124145,533791,686749,572913,59613,633963,846993,69636,282191,206963,522130,759981,539089,375546,121535,747760,938006,6060,60875,876697,488463,374645,633933,251861,508898,922586,212382,449528,494897,1030256,995785,938627,335530,870741,870760,95963,895522,148109,279488,133233,970026,514986,378590,1035244,329272,293006,748999,732708,539807,388751,723805,569215,911136,293534,407968,10893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000795s ]