SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485897 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485897 [ RunTime:0.002113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483175,231977,480907,749643,296200,87669,752118,192093,493727,1047047,964199,336866,845366,525702,258669,252918,55510,194093,698400,983341,402402,36457,144573,409559,539293,1007825,514297,193696,482440,457175,47634,709092,666453,1030856,340001,361562,841814,156320,261145,96412,1006675,342442,999676,327578,947987,389508,747482,43137,211819,906866,908066,576411,1017381,615776,222365,771794,468191,352074,964178,672633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000662s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]