SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 176214 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 176214 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154045,985300,300043,322302,917505,488641,150182,145947,197693,1019420,186051,773592,802837,333084,251345,222156,850302,344696,325378,292307,753625,163412,698316,345391,127288,34276,571469,297428,355072,428929,61136,482739,183302,818185,863680,150240,720909,677036,927267,909449,829360,782470,311625,146944,242018,299106,195515,991127,369308,256778,1026859,839683,83034,89934,230626,478573,275214,941618,922693,629389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 176214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 176214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]