SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 113800 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 113800 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009661,452636,807716,1027473,500453,668864,350364,624893,120454,954619,684553,729655,440649,970831,730789,47014,735708,568411,281108,310009,473113,395447,999238,177059,181879,131307,152478,429801,225398,593590,768609,971574,937919,846416,352931,292371,221438,849983,573499,250801,103981,903110,320917,383051,767428,606128,225370,1005790,156386,660829,827256,114418,146348,519895,1214,951841,289781,564217,569312,12944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 113800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 113800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002590s ]