SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429078 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429078 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706982,514197,995939,244802,858910,30278,21283,139817,99904,255835,642817,499550,915470,756936,611562,405249,653025,98985,326695,200767,513529,237957,852938,864066,471347,428277,15670,474001,90486,1022925,676019,347578,101976,954581,197078,748393,683061,304443,902631,792201,299309,166435,260158,333445,742909,798816,436519,636027,420326,411638,738476,186088,471781,613101,1027574,796434,199570,818782,422341,929937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]