SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001755s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103580 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103580 [ RunTime:0.003670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (756517,500140,517979,541862,661201,150763,775225,812387,398688,918586,914060,92130,111907,577219,266664,56294,978601,96811,872548,623203,249532,891574,80530,61610,688014,1043963,148128,258557,436123,771693,598353,186635,272527,425083,268177,504058,217302,574894,774913,204660,275505,159475,405383,377240,753632,754999,69163,247491,69779,351972,633560,393320,158244,892449,345398,1002428,1022973,9633,413298,570494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]