SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483818 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483818 [ RunTime:0.002437s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (652871,837430,687797,183136,365578,698782,523132,843318,563904,75011,349900,334589,22584,39777,72000,97936,793830,638939,336113,126900,622972,365224,989988,173030,561358,45607,592262,210878,429200,809957,876970,746929,21904,501734,884096,715151,330967,541949,254047,338845,447309,665393,987484,61753,615532,10820,958523,772576,961410,565519,103703,793274,770047,563023,633223,244307,115671,563952,620396,151381) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]