SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520398 LIMIT 1 [ RunTime:0.000562s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520398 [ RunTime:0.002104s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826640,62734,231022,1028644,919068,490075,102996,913957,181760,922959,329097,59072,35393,585737,402292,562351,185342,672380,376410,714422,669414,137608,353196,630718,541136,266910,985428,369154,924992,407421,817006,167466,877345,77950,951968,999045,37749,439788,455333,88200,877752,318896,2147,840548,746323,1021291,321295,918225,95090,627923,288140,763766,736505,661940,760917,829536,122524,630643,1012847,631622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000744s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]