SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401294 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401294 [ RunTime:0.002327s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510310,1016259,597333,204491,3715,952801,394799,825338,156915,706752,757994,205301,551056,823543,664844,599995,289622,794404,639143,483039,307372,251416,1031339,744585,577794,541818,164158,236267,593272,45331,755333,460417,501772,653803,345374,456054,1010676,889080,795841,953701,859029,997902,134648,884626,752624,363729,256864,373453,801954,779492,852899,658615,949100,526434,113915,483225,355672,184941,311577,809870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]