SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34400 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34400 [ RunTime:0.002158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (962133,580835,17515,17638,94394,997041,983846,389087,253398,120564,464850,617472,419640,488492,981168,408829,360153,995533,983196,930284,867829,978847,501637,69182,760098,764883,375961,384837,649134,81480,134387,337778,981336,297252,970931,48661,215470,717355,763150,391587,919613,354755,242705,387884,1029222,744547,542458,195096,505665,921547,359142,442826,757400,725155,748963,513063,832148,768800,292022,69841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000843s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000717s ]