SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439829 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439829 [ RunTime:0.002641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595242,835310,806634,315930,818335,448787,218390,986943,838506,795446,394382,630169,604500,158357,850108,998965,473169,943184,101385,761601,116405,168971,953388,705909,44906,700130,743419,653369,762286,682541,751706,561550,147568,751533,300326,952933,538634,409668,37489,349627,989614,501982,406850,926966,555444,746630,78053,120316,410439,932693,23407,581937,508614,810341,641439,124618,375078,359111,224159,116958) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439829 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439829 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]