SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 289403 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 289403 [ RunTime:0.001946s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (173581,289077,582411,238199,165522,542522,772852,539036,1018402,268354,851896,677948,707449,195095,80656,327003,728299,945511,594109,146445,369157,816743,866030,433834,435635,128709,103259,859969,499886,507566,252559,104619,815711,16310,1001494,711623,620465,200652,1012545,840,768965,838914,310658,541151,530996,113783,287259,900025,364101,223333,914447,558017,422771,605567,667215,1047840,335066,101641,676466,302676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 289403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 289403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]