SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001582s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 322824 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 322824 [ RunTime:0.002096s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502530,1031893,1099,419452,192072,450445,419300,723543,444776,783754,108661,204144,783201,799796,622164,886855,271663,650571,343851,990808,26852,174427,128078,654808,998785,798105,891704,690181,474876,136901,963407,186232,902181,132233,30563,447783,512248,110407,579069,743630,581294,375697,3497,287710,97418,514826,862670,550246,48117,288899,763719,960616,125763,358481,63867,586401,111793,990321,674293,923582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 322824 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 322824 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]