SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392541 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392541 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774237,445673,790716,980687,833514,587935,565355,603961,364768,5745,73274,152768,650339,278038,59281,954100,14889,90697,643126,345005,464665,654570,987938,433156,1002688,194509,110208,918508,834963,625893,306072,529883,803515,372018,52513,642869,970952,1044988,814610,233848,954071,334048,297131,374160,757024,893735,243736,20743,448504,713200,795616,340537,284114,1016896,359917,895582,266509,10935,933854,1004310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000757s ]