SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501943 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501943 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569548,477909,609785,78736,120248,996652,174193,657839,849828,852268,116907,336668,1008608,649756,364977,941260,683761,10907,247091,474117,700148,717531,797729,623001,454672,200228,719384,300191,485236,206388,707283,271717,163053,653161,213030,260376,995141,1023686,371262,824225,508845,133453,267990,1011979,625775,79209,328585,192202,119052,893602,229036,609285,791511,918627,917023,92540,178326,500392,883234,766954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]