SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.014763s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 639041 LIMIT 1 [ RunTime:0.005987s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 639041 [ RunTime:0.004758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475411,313239,939189,414620,925820,721014,467604,358382,897838,669335,1024321,498675,23964,725138,955283,202864,470497,642568,42688,946983,182166,533226,500094,785574,15484,346637,1000159,283077,754089,595979,510736,342711,704021,266739,302656,186446,341331,608031,509875,677408,879222,920051,905499,740895,918358,547437,272838,340696,290489,983862,539307,1002804,615522,102559,438661,789091,961003,908293,288556,807535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 639041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 639041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002278s ]