SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 991012 LIMIT 1 [ RunTime:0.003362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 991012 [ RunTime:0.006610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19602,229927,993521,1048106,964160,806002,226196,120341,46878,467662,939382,632986,223093,673372,1005148,825203,1029922,899285,958324,828007,725862,464858,899226,160881,59649,105410,505579,717710,43857,838459,88913,706149,359644,786249,913107,678103,287953,603049,27514,313064,160148,383139,674086,374352,591526,964304,427897,230387,961079,731289,849942,257491,384944,265014,768040,553983,88446,59550,854461,493303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 991012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 991012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003266s ]