SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 590010 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 590010 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972549,49035,114029,566938,43034,910235,342854,536201,655473,75121,47242,214141,946303,360798,515156,236193,58352,20642,425277,218241,146436,630233,197346,575100,441516,563775,1001552,49270,695476,452719,634343,732125,283005,517586,674157,496766,402859,652333,451798,338973,393771,363425,592241,946946,385344,824500,137718,963443,283013,898677,470081,350681,773508,342649,778340,769900,494807,939910,716079,945946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 590010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 590010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]