SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509818 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509818 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (139115,573985,25058,716386,105039,410322,203171,540656,754966,284607,668775,532627,961645,468222,984614,348328,890563,59083,50179,977643,690322,164728,643308,1022618,49471,130173,767508,952909,381073,144948,87139,391062,513986,621406,512626,426315,913299,349839,184618,252013,138080,988609,910824,172829,200722,370224,117358,1046901,1010051,626015,795700,171070,642292,657386,421642,887195,581203,553912,870179,301811) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]