SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036857 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036857 [ RunTime:0.001542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043357,190046,149063,473916,399358,109075,725948,633948,469763,750680,2247,524251,585206,619330,647022,431870,1008307,994210,1035229,704181,981904,698565,739627,838955,500717,426517,457451,1037301,277200,735321,763166,1035378,836587,388865,94100,203045,422515,243198,683157,918563,845158,1026042,235274,835416,396354,841248,11697,312373,948197,712180,396219,867286,99098,1009420,108228,1032459,980797,96217,89853,239135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]