SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5970 LIMIT 1 [ RunTime:0.001812s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5970 [ RunTime:0.002579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (554219,120897,819922,906891,18323,675732,15132,524166,580925,695256,460981,501943,91603,173715,711044,514491,426192,77010,851835,598137,478013,894603,829705,325922,74652,607005,948430,819110,517453,322191,576071,477790,883202,979172,879529,407143,264474,792253,173669,930317,128389,480048,1046298,130520,978336,806467,920691,437525,963783,738518,655947,478713,697079,1004317,66594,444692,863922,976573,578326,954585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002754s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5970 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5970 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]