SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281710 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281710 [ RunTime:0.003735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972368,372083,45830,217185,293408,207974,40628,831504,196998,486250,575293,78304,1046232,629309,851375,183824,254176,27403,446514,167381,634926,104043,301766,882715,813079,210809,539160,864569,965441,778396,617020,240276,975817,462187,436832,86419,934472,180880,585036,121601,219443,96922,130557,143036,173534,1047539,342084,610316,250968,66491,369196,88963,209025,397080,119642,359440,966019,932820,541117,532790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001119s ]