SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 356020 LIMIT 1 [ RunTime:0.000611s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 356020 [ RunTime:0.004566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250184,819064,589839,102565,773444,850615,253618,1010229,478780,41245,412008,859990,466016,123717,674709,156253,377491,861736,529223,389589,883796,847164,277829,698530,991659,21021,983242,558316,541984,815217,785676,810156,757393,525570,586860,327759,327860,334236,1031200,194669,731406,945792,587369,372507,44538,691722,414045,435095,773329,817720,1034468,496865,651876,809416,475929,867925,231335,12450,618220,788482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 356020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 356020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]