SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50183 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50183 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (955587,615460,416327,729399,765213,203595,341704,1041966,229103,473416,82083,617804,203400,629329,957155,918003,411790,645362,536640,450600,469807,356697,725454,854223,176824,102003,714601,901861,361947,118844,355264,900712,717479,300960,597844,749470,5122,335459,419203,42980,10971,822046,896758,634539,720548,65723,106846,624299,782091,696782,145550,296917,495711,815871,1235,81897,834715,872157,395631,118234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000719s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]