SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 59200 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 59200 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371683,261488,483895,514613,709471,991164,823899,124560,979245,330015,697511,271490,439252,626724,449313,412933,347981,337351,881697,303453,953676,7353,384517,170204,895928,78151,446726,667769,705818,648976,456633,4589,165378,853828,108953,751145,204832,1031102,802384,573078,500342,105123,235369,98249,331912,609716,282034,643834,552622,194945,788522,854112,539756,101039,517664,638657,536350,408652,780888,505033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 59200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 59200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]