SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416208 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416208 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307973,162094,133801,606880,1003352,382494,122298,126693,989689,896449,128014,114110,199949,227770,394514,856919,26261,514159,117173,770407,274085,747027,958521,50951,834475,750174,941210,274277,520719,309613,132399,532648,96718,123139,197423,852579,325617,484303,253587,613995,389250,159315,402817,920683,340965,420037,166253,358150,566579,1018179,898782,1,341869,606401,416015,512350,32710,298325,477652,435077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]