SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102371 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102371 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451147,113673,103990,496261,130266,3431,939889,657392,3695,429431,228510,574451,542575,274277,248896,163693,10128,1005329,924472,155394,405378,198444,362644,653857,297375,356844,1022889,444343,762005,207561,246556,231593,94379,431274,334293,499287,729092,458929,491859,442529,339972,862288,167974,81853,997447,506230,240897,945570,177390,456311,106462,690185,804881,744809,462191,711540,12659,12706,968049,686199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102371 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102371 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]