SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451215 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451215 [ RunTime:0.003704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444023,324200,525363,625208,181083,382220,162109,38191,796086,516654,240947,271131,773641,570666,786241,176822,777303,879932,1011463,868607,374008,950144,16078,323357,530169,317972,758830,49612,251002,925470,172998,24352,91212,634959,239728,303068,245355,255230,326931,770704,7470,59341,721892,370178,422648,953185,354476,270054,813679,221923,824885,917370,716752,420812,446184,155928,211383,335419,870809,1045723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001108s ]