SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001419s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100421 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100421 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (634230,580453,104077,535296,267591,25345,740823,188356,284769,138699,100463,748146,417014,113359,342017,988634,821605,610104,850621,877500,323241,608499,318157,535750,310575,795164,64662,571123,8795,804124,300241,243840,574176,338425,993073,325259,123048,1000510,919262,817698,652744,321902,366050,78439,573559,1012105,393896,496262,135109,961819,66594,354012,45122,312198,58367,1037708,802239,831986,509948,672253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]