SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591101 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591101 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690302,968368,766418,76983,58642,440798,614204,241847,521437,444247,64363,582534,343683,72685,313558,408920,945163,198082,215048,220016,904083,215000,135904,791538,110183,321462,914416,650152,80834,901113,788109,304311,19035,537204,585642,560309,144550,970747,272107,813245,906597,864666,21833,362701,690543,79017,757922,357751,186711,439344,593667,1020124,386014,432176,163652,938603,174359,573166,192586,287654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]