SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027450 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027450 [ RunTime:0.002018s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (645478,77127,459636,221654,205042,13554,521285,978539,634448,106219,766692,381122,171022,465180,729644,940529,235036,671635,253559,697981,114878,446325,823757,214500,873553,668579,966346,856886,920019,646016,385959,315642,259557,954169,597175,1045220,522496,1009300,315714,251669,193793,528068,391603,929753,998895,358423,741551,934050,808427,88966,312719,675842,551115,184416,1042313,203404,959598,1029519,512855,433527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]