SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40611 LIMIT 1 [ RunTime:0.000277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40611 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690047,669403,278192,746060,1014961,653283,265241,693486,475890,359793,319901,493884,620661,997101,452677,915616,780782,548948,547509,615284,436156,932909,248237,206063,128141,331435,78115,847579,127630,437895,491008,13673,179863,904603,581882,846985,159991,561483,1020141,115244,383047,426222,208574,560830,104103,141792,477497,570995,137966,1009174,888595,988894,11531,1032170,527323,519162,1003343,525654,72304,366694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]