SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517017 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517017 [ RunTime:0.001947s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262402,244266,947229,776089,754795,270810,781454,400114,152502,535711,442485,406920,467224,714498,784843,938063,971732,353763,128444,469231,629913,688709,603591,1032567,966159,992982,401030,691513,807494,48476,575820,238359,991742,976001,284621,788022,574235,648789,843990,889470,694036,795345,659220,557515,510246,157056,151817,608894,347011,527386,9812,489080,470969,87816,441147,149626,28163,756095,951882,118454) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]