SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009876 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009876 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194486,902285,452003,486001,660835,741269,746397,696426,222963,761847,867239,399214,836839,360168,36808,713532,126340,481201,532283,230208,888414,327057,742965,336702,966362,615286,487,466813,864192,548777,452778,536071,274597,129191,483878,775680,978677,959161,21926,423560,368876,916092,1022600,751329,960006,170115,56897,740937,25585,222981,207483,674708,489561,1013671,437396,386497,673121,869431,271811,804738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]