SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291085 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291085 [ RunTime:0.002029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (976962,664912,640128,168836,672700,622225,676162,598686,381077,286181,839484,522164,364458,767101,896573,419975,228942,394978,259623,1029867,167708,530023,686020,479029,228675,377151,60539,923039,957921,120168,1032031,151865,1040159,70266,19411,17346,204597,665182,979940,487311,855380,160845,772053,694442,361958,994380,652201,933777,927958,714207,429122,795632,383709,337195,747474,190122,792549,903358,2528,861438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]