SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003651s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806712 LIMIT 1 [ RunTime:0.001125s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806712 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475016,1040694,162682,199102,727036,737974,445444,703763,327281,271219,172560,145059,447508,854252,564669,846606,698005,430693,957084,802253,749612,990100,209447,139214,650990,44116,908083,16897,482693,62629,1048125,119934,192379,576779,903306,989589,666594,811132,503200,668842,691548,635027,112090,192132,545080,1008922,393394,938597,589173,908001,278181,485227,834251,59186,691330,683055,725492,705184,919203,382970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]