SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801785 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801785 [ RunTime:0.002095s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20759,409851,278947,72771,775545,707528,192954,937078,954953,106219,830283,722485,314234,957926,289112,414830,490555,246079,315502,941023,1001284,746211,165878,288673,981480,161577,915513,241442,204987,934254,936998,621492,898325,314167,565934,801110,971270,149058,922295,45762,902889,513803,909865,956064,917496,186119,227760,767728,588987,429651,27151,945660,981571,216967,646167,361705,759288,112984,549542,630974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801785 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801785 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]