SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001789s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 297516 LIMIT 1 [ RunTime:0.000483s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 297516 [ RunTime:0.001439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039088,218791,331961,84042,920378,770129,430907,464942,657252,988986,583839,883694,453530,974727,723529,172083,1026236,886614,704876,670895,634296,500268,174889,9609,565257,821990,999120,272454,82464,929126,193454,847830,737690,748134,494543,553016,407047,598798,992484,141791,150883,669173,21320,25659,592880,534415,1047193,965304,379998,806732,373083,474609,249626,357029,76505,343767,229302,149055,622312,22807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 297516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 297516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]