SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100913 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100913 [ RunTime:0.002477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243371,385327,758023,248508,199121,444322,469498,239996,476151,713344,337936,903589,756051,141779,375809,520078,796992,520782,1025798,723146,84336,875567,312141,339047,993017,358893,284443,8949,341952,622472,404571,422215,916949,254085,39249,83082,687986,980736,354864,404238,317931,639948,488039,101485,576385,815087,766703,284530,387458,413789,279868,391332,305850,974934,286,856530,693891,1013116,447458,270264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]