SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283053 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283053 [ RunTime:0.002141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344706,899571,648769,620233,457185,412715,1030750,90094,510747,580010,362103,857984,103847,779563,492034,52545,195308,861765,296417,667237,608315,982731,956373,971155,785158,100877,907055,108056,999627,899420,27414,877031,105520,356081,230117,585211,1717,276105,1034277,598897,106253,571156,45016,512959,714530,229143,444764,423434,277226,706995,845515,626761,1012620,1027523,159212,465407,112707,433491,40701,885053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005651s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001568s ]