SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489699 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489699 [ RunTime:0.002037s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282606,16043,926192,110216,843578,180536,483510,89100,133689,204224,479450,456364,835953,8945,677555,150511,416560,544651,556961,333823,846206,1027831,771378,36564,785402,660776,721809,559859,684429,867554,553182,111796,572597,765927,49487,615480,409068,762615,860293,537054,131420,417673,819851,312345,326720,790013,177649,114050,152734,562186,613781,718914,140515,829083,551305,498738,327906,1005092,478524,466503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001841s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]