SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515823 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515823 [ RunTime:0.002607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026948,642962,180394,819076,327758,830700,303911,939715,330829,563775,571841,698649,873374,302135,355616,210202,802967,715231,312311,599528,507512,958772,945529,910383,614737,747384,310015,556659,617236,287253,589315,575009,722455,109024,311043,163319,348513,248404,282018,89568,404294,572305,378572,74158,795716,389441,165947,195352,242128,194835,292641,696844,304318,22864,238929,917954,712420,144831,994009,311602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]