SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409862 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409862 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722534,730662,944396,956109,449659,428357,622739,474842,798484,1008903,784360,486217,183330,389629,24656,80108,326759,554372,567779,444278,108800,39849,199529,687535,810785,94014,461056,671009,444067,350069,195249,167653,802840,272875,299965,226136,206749,349188,679412,734341,53646,305618,476591,405237,781914,975151,753315,568964,44588,99797,707136,793414,269234,253162,901600,394442,154885,449026,479587,72131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409862 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409862 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]